Sunday, February 19, 2012

Export table from SQL 2000 to SQL 2005


Hi, I have just installed SQL 2005 and I started moving my tables from one server (SQL 2000) to the new one (SQL 2005). I noticed when I use the import option (SQL 2005) it does not create indexes, pk, and do not create columns as identity. In this case I decided to script all objects and create them in 2005 what should be fine. After that I use the same import to move data from 2000 to 2005 when it show the data mapping screen if I do not click on edit and check the option "Enable Identity Insert" it will fail for tables where I have identity columns. Is there a fast way to move tables from 2000 to 2005 with data ? Also, a fast way to move just data from 2000 to 2005 and do not have to check "Enable Identity Insert" for each table. Could I apply this option to all tables ? I appreciate if someone could help me. Thanks, VSThe easiest thing is to create a database backup on SQL 2000 and restore it to SQL 2005.

No comments:

Post a Comment