script DB
-
hey guys, i have quite a few SQL databases on my PC. I want to script all the databases into a text file. The script should contain both the data and the structure of the databases. How can i do this? I want to execute this process from a batch file. Is there a tool or something that i could use? I've been hunting for something like this for a long time but I haven't found anything. In MySQL tis is a relatively simple process which can be accomplished by using the mysqldump utility.
-
hey guys, i have quite a few SQL databases on my PC. I want to script all the databases into a text file. The script should contain both the data and the structure of the databases. How can i do this? I want to execute this process from a batch file. Is there a tool or something that i could use? I've been hunting for something like this for a long time but I haven't found anything. In MySQL tis is a relatively simple process which can be accomplished by using the mysqldump utility.
Hi You can take a dump, use BCP for that and write it to a flat file. Then you can use command line prompt to export that flat file using BCP. Check these link: http://www.databasejournal.com/features/mssql/article.php/3391761[^] http://www.paladn.com/bulk-copy-program.htm[^]
Rate this message. Thank you. Harini :)