Post reply

ways to migrate data from sql 2000 database to sql 2005 database with new DB structure.

  • October 29, 2008 at 2:34 pm

    #124121

    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 29, 2008 at 3:33 pm

    #891510

    Since you've created the SQL 2005 database with different table schema than the SQL 2000 database, you can't use backup and restore either. SSIS or DTS are the methods that come to mind and, since you posted this in the SSIS forum, you're probably thinking the same thing.

    I've also seen T-SQL scripts used to migrate to new table structures, although that method would probably take longer than using SSIS or DTS.

    Greg

  • October 29, 2008 at 3:53 pm

    #891516

    Thanks Greg. You are right. I am thinking of SSIS only.

    link/example/reference towards that conversion would be great help.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply