MS SQL ScriptDB tool

Description :
ScriptDb is a simple console app written in C# that uses SQL Management Objects (SMO) to script all the objects in a database.

Running this console appl. with following parameters will generate the SQL scripts for Tables and Views.

scriptdb.exe -con:server=(local);
database="YourDBName";trusted_connection=yes 
-outDir:D:\ScriptDB\scripts -v –p 

image

The version posted on http://scriptdb.codeplex.com/ is only against MS SQL version 2000 – 2005.

But someone upgrade the source for MS SQL 2008 !

http://tech.trailmax.info/2012/10/scriptdb/scriptdb/ – 2008 version DotNet 4.0 needed.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: