Generate SQL Script of databases with data through an exe
-
Hi, I have to develop an exe module to generates a script text file for all the databases exist on a server(in my case SQL Server2008) with all its objects, data, triggers,etc.. I know this can be achieved by Generate Scrip for Task menu in SQL Server2008 but this is manual & needed to work for each database with explicitly defining its properties selection, thus making it long hours task. Any sample project would be appreciated Regards Ashish
-
Hi, I have to develop an exe module to generates a script text file for all the databases exist on a server(in my case SQL Server2008) with all its objects, data, triggers,etc.. I know this can be achieved by Generate Scrip for Task menu in SQL Server2008 but this is manual & needed to work for each database with explicitly defining its properties selection, thus making it long hours task. Any sample project would be appreciated Regards Ashish
Following link might be useful to you. http://stackoverflow.com/questions/1695738/programmatically-generate-script-for-all-objects-in-a-database Hope this help!
Peace ON In Simple Sense... Start Shining Stories We Live...
-
Hi, I have to develop an exe module to generates a script text file for all the databases exist on a server(in my case SQL Server2008) with all its objects, data, triggers,etc.. I know this can be achieved by Generate Scrip for Task menu in SQL Server2008 but this is manual & needed to work for each database with explicitly defining its properties selection, thus making it long hours task. Any sample project would be appreciated Regards Ashish
There's this: Library for scripting SQL Server database objects with examples[^] Also SqlPubWiz, which is what I use.
-
Hi, I have to develop an exe module to generates a script text file for all the databases exist on a server(in my case SQL Server2008) with all its objects, data, triggers,etc.. I know this can be achieved by Generate Scrip for Task menu in SQL Server2008 but this is manual & needed to work for each database with explicitly defining its properties selection, thus making it long hours task. Any sample project would be appreciated Regards Ashish
The previous replies should enable you to complete your task but in case you are still having problems, try these: Scripting database objects using SMO[^], Generate scripts for database objects with SMO for SQL Server[^] or Using PowerShell and SMO to script SQL Server database objects[^] if you feel adventurous/like PowerShell. These were all from the first page of a google search on script database objects with smo
Henry Minute Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.” I wouldn't let CG touch my Abacus! When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is. Cogito ergo thumb - Sucking my thumb helps me to think.