October 30, 2008 at 10:26 am
Hi,
I have a application running with sql 2000 database. We were redesigning the application and decided to move to sql 2005. We designed a new front end architecture and also new database design.
I have the new sql 2005 database ready. Requirement is that, i need to migrate data from old design sql 2000 database to newly designed sql 2005 database. Its more or less has same number of columns but the column name, table name, column type are different.
what is the best way to do this? I know for sure that detach and attach wont work here.
Help appreciated.
-Thanks
BJ
October 30, 2008 at 10:30 am
you could do back-up / restore
or dettach /attach
or script out the database, and wrtie a SSIS package to transfer the data
why wont dettach / attach work?
October 30, 2008 at 1:34 pm
Hi,
Thanks for the info. As i said earlier the sql 2000 DB and sql 2005 Db has 2 different table structures. Detach/attach i believe works if i want to move the entire database.
What would be the best choice to move data between 2 different table structures which are in 2 different versions of SQL?
-BJ
January 15, 2011 at 8:03 pm
If you use SSIS to do the data migration, you can change data types inside the SSIS package, and then write the data to the final table. Once you get your head around SSIS, that's probably the easiest way to go.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply