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