As part of the SQL server hosting toolkit, Microsoft released a database publishing wizard, which allows you to publish a database on a hosting service, both schema and data. It provides two ways to accomplish this:
- By generating one SQL script file of the entire database schema and data or
- By connecting to a web service provided by the hosting company to transfer the database directly.
I originally read about the database publishing wizard on Scott Guthrie's blog, and then immediately forgot about it until I was talking with Chad at Tellus last week, and he was using it. So I grabbed the download and installed it. And it appears to work well. You can use it via a GUI wizard, or from the command line. Here are a couple tips from my usage so far:
- Command line parameters are case sensitive. It took me a while to figure out that the server parameter was capital (-S), not lower case (-s).
- It does not script the diagrams, but then what does script the diagrams? Believe it or not, there is a way to script the diagrams in SQL 2005. Take a look at this article on CodeProject for details.