Generate Database script for all tables using SMO

Vikram

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kirtan Patel17y ago
Accepted 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
0
jayakrishnan Morayur15y ago
Nice code but an error occued

"An error has occured while cnnection to database"

please replay
0
Amit Gautam16y ago
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();
        }
0
Vikram17y ago
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,
0