none
DATABASE MIGRATION

    Question

  • Hi,

    I have an old database with about 20 tables that has to be migrated to a new database with around 45 tables.

    The tables in the old database are widely different than in the new one in structure and relation though the data is common.

    Can anyone please suggest on an efficient way of tackling this.

    Also please let me know if any more info is needed.

    Saturday, October 19, 2013 12:17 PM

Answers

  • Hello shuvayan,

    If your requirement is to move certain tables from one DB to another, you can generate the create table script , execute it in the new DB, use import/export wizard to import data into table in new DB.

    If your requirement is to insert few records into an already existing table in another DB, you can prepare the appropriate select query which gives you the desired result set. Use that select query in the import/export wizard to import data.

    In either case, you can make use of import/export utility

    http://technet.microsoft.com/en-us/library/ms140052.aspx

    Thanks

    Please click the Mark as answer button and vote as helpful if this reply solves your problem

    • Marked as answer by Shuvayan Sunday, October 20, 2013 4:38 PM
    Saturday, October 19, 2013 6:59 PM

All replies

  • Hello,

    Few clarifications would be helpful.

    What do you mean by old database and new database. Are you referring to databases residing in two different instances of two different versions of SQL Server .

    There are more than one way you can move these tables from one Db to another DB in same server or in different server. You can make use of the transfer objects task in a SSIS package.

    http://technet.microsoft.com/en-us/library/ms142159.aspx

    http://www.mssqltips.com/sqlservertip/2064/transfer-database-task-and-transfer-sql-server-objects-task-in-ssis/

    Thanks

    Please click the Mark as answer button and vote as helpful if this reply solves your problem



    • Edited by udhayan Saturday, October 19, 2013 1:51 PM
    Saturday, October 19, 2013 1:36 PM
  • The databases are in the same server.Just that the old one was used for an application that was in use in only one country whereas the new database will contain data for the same application with multi-country version.There will be few common data that needs to be migrated to the new database.
    Saturday, October 19, 2013 3:14 PM
  • Hello shuvayan,

    If your requirement is to move certain tables from one DB to another, you can generate the create table script , execute it in the new DB, use import/export wizard to import data into table in new DB.

    If your requirement is to insert few records into an already existing table in another DB, you can prepare the appropriate select query which gives you the desired result set. Use that select query in the import/export wizard to import data.

    In either case, you can make use of import/export utility

    http://technet.microsoft.com/en-us/library/ms140052.aspx

    Thanks

    Please click the Mark as answer button and vote as helpful if this reply solves your problem

    • Marked as answer by Shuvayan Sunday, October 20, 2013 4:38 PM
    Saturday, October 19, 2013 6:59 PM
  • Hi,

    Thanks a lot.will do !!

    Sunday, October 20, 2013 4:38 PM