The Design of Software (CLOSED)

A public forum for discussing the design of software, from the user interface to the code architecture. Now closed.

The "Design of Software" discussion group has been merged with the main Joel on Software discussion group.

The archives will remain online indefinitely.

Database schema difference comparison and updation

Hi guys,

I'm trying to migrate a SQL Server 2000 database (schema + data) to a new SQL Server 2005 database. The new database has nearly the same schema as the old one, but some schema changes have been made.

I'm looking for a tool to generate a script for data transformation from the old database to the new database. The tool should be able to detect the schame changes between the old and the new databases, and then copy the data from the old database to the new database based on the detected mapping.

I guess it cannot be 100% automated due to the schema mapping requirements, but atleast a tool that can transform the data with some manual tweaking.

Any help is very much appreciated! Thanks :)
Thursday, May 15, 2008
Check out the groovy SQL Server tools at Red Gate:
Odysseus Send private email
Friday, May 16, 2008
+1 redgate.

I also use the schema compare tool in Visual Studio.

MS Publishing wizard is also handy.
Justin Send private email
Friday, May 16, 2008
SSIS (SQL Server Integration Services) is included with SQL Server 2005, and you can automate a lot of what you are talking about in there. It's a pretty decent DTL tool.

The SQL Server 2000 version is called DTS, but i wouldn;t use that - not as much automation potential.
Friday, May 16, 2008
Check xSQL Object and xSQL Data Compare at
They have command line versions also, so you can automate your procedures.
Albert Tollkuci Send private email
Friday, May 16, 2008
I use RedGate SqlCompare, SqlDataCompare and love it.
Anon cause I fear the real world
Saturday, May 17, 2008
++1 RedGate SQL Compare
Mike M Send private email
Monday, May 19, 2008
Couldn't live without RedGate. Great software, GREAT prices, and great support.
Wednesday, May 21, 2008

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
Powered by FogBugz