ansaurus

Question

Generate script for all objects for SQL Server Database

Answer 1

A:

You can try precaching required objects to improve performance with PrefetchObjects method:

var server = new Server(new ServerConnection(connectionString));
var database = server.Databases[databaseName];

database.PrefetchObjects(typeof(Table));

If you're trying to implement anything related to database schema migration, check out Wizardby.

Anton Gogolev 2010-01-22 10:50:22

I tried this:Server server = new Server(con);var database = server.Databases[vstrDatabase];database.PrefetchObjects(typeof(Table)); foreach(Table tbl in database.Tables){ sbr = new StringBuilder(); StringCollection script = tbl.Script(); foreach (string str in script) { }}tbl.Script takes plenty of time for remote server, so the whole process is taking a long time. I need to create scripts for all object. So what would be the best way.

Anshuman Roy 2010-01-22 11:14:57

Answer 2

+1 A:

I would use SQL Server Management Studio

From the Database item right click and select tasks, generate scripts. Many options there for you to enjoy.

(You can even have it script data in the tables.)

Hogan 2010-01-22 14:24:27

I have to do this programmatically using c#.

Anshuman Roy 2010-01-25 06:32:40

ansaurus

tags:

views:

answers:

Generate script for all objects for SQL Server Database

related questions