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 11:01 am
BJ (10/30/2008)
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
SQL Server Integration Services aka SSIS. You can right-click your new SQL 2005 database, select tasks, import data and use the wizard. Alternatively, you could use Business Intelligence Studio.
Tommy
Follow @sqlscribeViewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply