The Database Publishing Wizard is THE tool to use when one needs to script both data and schema for deployment around the office or world. Get it here!

WTF TighOf course it would not be Microsoft if every thing worked smoothly and this is no exception :( You will find the scripts this tool generates will NOT usually run in SQL Management studio. This is because of the way the team designed the managers memory use. Basically, it does not have a lot of memory to run scripts in–who would use a script anyway huh– and therefore will fail on almost all but the simplest of scripts.

The official upshot is it is a “Command Line” tool not meant to run the scripts in the management system. Uh huh, right … < sideways glance > sure.

For more about this actually pretty cool tool go to Scott’s Blog.

Tags: ,