Deploy SQL Server 2005 objects and data to SQL Server 2000
Posted
11. travanj 2008 17:32
by
dadamec
I recently had to deploy DB that was developed in SQL Server 2005 Express to SQL Server 2000. The little tool i found help me a lot.
It's a Database Publishing Wizard - part of SQL Server Hosting Toolkit. The toolkit has a wider purpose but the DB Publishing wizard is really usefull because it can script database (both 2000 and 2005, and both schemas, objects and data) with customized syntax for target SQL Server version. Writing scripts by hand with little changes in syntax or object names changed (sys.objects - sysobjects) can make you a lot of trouble and this tool can save you a lot of your time. And of course - time is money - isn't it? Or could I say - time is free time ;-)