belle’s sql musings

How to script out your database objects (Database Publishing Wizard)

Posted in Tools by belle on October 3, 2008

I work with MySQL, and MySQL has a mysqldump client that scripts out database schemas + records in the tables.

There is no “native” tool in SQL Server 2000/2005 that does this (as far as I know). Luckily there’s a SQL Server add-in that allows scripting of both schema + records.

You can download the Database Publishing Wizard from CodePlex:
http://www.codeplex.com/sqlhost/wiki/view.aspx?title=database%20publishing%20wizard

Advertisements
Tagged with:

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: