Generate Database script for all tables using SMO

Question

Hi, I want to generate a database script for all tables only same as we do it in SQL Management Studio manually using SMO in C#. Thanks

Kirtan Patel · Answer

Friend, Here is your Solution . Just Run Following Commands Programatically . and it will Create the Script Files . private void button1_Click( object sender, EventArgs e) { Process p = new Process (); p.StartInfo.FileName = @"C:\Program Files\Microsoft SQL Server\90\Tools\Publishing\sqlpubwiz" ; p.StartInfo.Arguments= @"script -d AdventureWorks "C:\AdventureWorks.sql" ; p.Start(); } Other commands wich will helps you ,are below just Execute it like above :) Command to run which will create schema and database: C:\Program Files\Microsoft SQL Server\90\Tools\Publishing\sqlpubwiz script -d AdventureWorks "C:\AdventureWorks.sql" Command to run which will create schema: C:\Program Files\Microsoft SQL Server\90\Tools\Publishing\sqlpubwiz script -d AdventureWorks "C:\AdventureWorks.sql" -schemaonly Command to run which will create data: C:\Program Files\Microsoft SQL Server\90\Tools\Publishing\sqlpubwiz script -d AdventureWorks "C:\AdventureWorks.sql" -dataonly

jayakrishnan Morayur · Answer

Nice code but an error occued "An error has occured while cnnection to database" please replay

Amit Gautam · Answer

I found error- "The system cannot find the file specified" Please guide.. code is- protected void Button1_Click(object sender, EventArgs e) { Process p = new Process(); p.StartInfo.FileName = @"C:\Program Files\Microsoft SQL Server\90\Tools\Publishing\sqlpubwiz"; p.StartInfo.Arguments= @"script -d AdventureWorksC:\AdventureWorks.sql"; p.Start(); }

Vikram · Answer

Hi, Thanks for your reply. Its working fine. But it gives schema of all objects, actually I want schema of tables only. Is is possible with same option. Thanks,

Generate Database script for all tables using SMO

Answers (4)