Comments on: Moving SQL Server 2005 Express databases to SQL Server 2000

By: Kangkan

Kangkan — Fri, 20 Feb 2009 06:21:41 +0000

An incredible post. This helped me a lot.

Of course, I needed to do the same a bit differently.

Read how I moved my SQL Server 2005 Express database to SQL Server 2000 here: http://www.geekays.net/post/Moving-SQL-Server-2005-Express-databases-to-SQL-Server-2000.aspx

By: Jason

Jason — Tue, 17 Feb 2009 13:57:21 +0000

Thank you. This was an incredibly easy and painless way of achieving this much-frowned-upon exercise!

By: Andrew

Andrew — Sun, 10 Aug 2008 15:25:55 +0000

Do you sample scripts available? Sounds great, but having some sample scripts would save me from re-inventing the wheel.

Please feel free to email me directly. Great article. Thank you!!

By: Frank gives me a mention over at The Code Project at The Social Programmer

Frank gives me a mention over at The Code Project at The Social Programmer — Tue, 18 Sep 2007 16:02:55 +0000

[...] you’re new here, you may want to subscribe to my RSS feed. Thanks for visiting!Further to my earlier post about moving a SQL Server 2005 database back to SQL Server 2000, Frank has written it up in a [...]

By: Joe

Joe — Thu, 31 May 2007 01:51:03 +0000

Thanks, this helped!

By: Craig Murphy

Craig Murphy — Tue, 15 May 2007 16:01:41 +0000

The Red Gate products are on my list to look and and review over the remainder of this year. They look to be a very comprehensive set of tools.

By: Ian Ringrose

Ian Ringrose — Tue, 15 May 2007 14:57:23 +0000

If I had to do this, I would look at using “SQL Compare” and “SQL Data Compare” from Red-gate and getting them to sync a block SQL server 2000 database with the SQL 2005 database. However these tools are not free and we already have “SQL Compare” to help with creating our database upgrade scripts.

Using Microsoft SQL Server Database Publishing Wizard is a VERY clever way of doing this without having to buy in and learn any 3rd party tools.