A public forum for discussing the design of software, from the user interface to the code architecture. Now closed.
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:
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
I use RedGate SqlCompare, SqlDataCompare and love it.
Anon cause I fear the real world
Saturday, May 17, 2008
++1 RedGate SQL Compare
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
Powered by FogBugz