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

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (4)