Microsoft announces the SQL Server Hosting Toolkit.
It's a command line-based scripting tool. This is the first CTP so it's limited in proposed functionality - but even so, it's already impressive.
After installing the utility, access it from the Start menu:
I immediately aimed it at AdventureWorks in a local instance of SQl Server 2005 on my laptop - hoping to generate a database script. It failed:
At this point, I decided to read the ReadMe file:
There's a link to Known Issues which took me to a page describing supported database objects and unsupported data types. The returned error listed the database table where the issue originated (nice touch!): DatabaseLog. It turns out DatabaseLog contains an XML field - one of the unsupported types.
To test, I first created a database and added one of each supported database object - a table, index, view, and stored procedure:
I added data to the table with an index, created a view that returned SELECT *..., and created a sproc that accepted a single parameter (id) and returned everything in the view. After test execution of the sproc, I used SQLPubWiz to generate scripts for the database:
I next deleted the objects I created earlier and used the generated script to recreate them. Executing the sproc returned an error - it no longer existed.
One cool feature I noticed right away is the data in the table is also included in the script. Re-executing the sproc proved the database and data had been restored.
Technorati Tags: SQLPubWiz SQL Server Hosting Toolkit SQL Server Utilities