Is there any query i can run through ASP which can create a .sql file for table/database structure & data which i can download or store it somewhere on web server .. say in the directory where the ASP page is ..
You can use DMO to script out creation scripts for database objects. There are a myriad of ways to get the data into a local file, from passing it through ADO to calling bcp to using XML.
--Jonathan
--Jonathan
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply