Migrating data from SQL Server 2000 to SQL Server 2005

Posted by Muhammad Kashif Nadeem on Server Fault See other posts from Server Fault or by Muhammad Kashif Nadeem
Published on 2011-02-22T15:16:24Z Indexed on 2011/02/22 15:26 UTC
Read the original article Hit count: 435

I have to migrate existing data which is in SQL Server 2000 to SQL Server 2005. The schema of two databases is different. For Example Locations table in SS2000 is split into two tables and has different columns. This is one time activity. After successful migration I don't need old db anymore.

  • What is the best way to transfer data from one SQL Server to another having different schemas?

I can write stored procedures to fetch data from SQL Server 2000 and insert/update tables in SQL Server 2005.

  • What about SSIS? I don't have any experience with this and is this better to create package of SSIS because I don't need this again and need to learn it first.

Thanks.

© Server Fault or respective owner

Related posts about sql-server

Related posts about sql-server-2005