Migrating data from SQL Server 2000 to SQL Server 2005
- by Muhammad Kashif Nadeem
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…