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

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

SysInternals Tools

Sysinternals Suite :

http://technet.microsoft.com/en-ca/sysinternals/0e18b180-9b7a-4c49-8120-c47c5a693683.aspx

Includes:

BGInfo – displays configuration, such as its name, IP address, or operating system version as a desktop wallpaper

ZoomIt – screen zoom and annotation tool for technical presentations

ProcessExplorer – displays which program has a particular file or directory open