locked
Data Migration within two SQL server databases RRS feed

  • Question

  • Hi All,

           I am a newbie to sql server. I need to migrate data from Version 1 database to version 2 database. The table structures are different in both including the datatypes. And also there is a possibility for redundant records. For ex) There can be redundant entries for item name say 'data1' but existing as two different rows with seperate id's in version 1. This should be converted to a single row in the version 2 database and all the corresponding child tables should be made to point to this row in version 2.

     

    I am confused how to proceed?. SSIS or Procedures & Cursors or ADO.net application. Is SSIS capable of supporting matchings based on each record's values? Suggest me the right direction.

     

    Thanks,

    Saravanan K

    Monday, July 26, 2010 11:36 AM

Answers

  • You need to write some logic based on your business requirements and migrate the data... even if you choose using SSIS

    I would also take a look into red gate tools to do such things

    www.red-gate.com

     


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Monday, July 26, 2010 12:00 PM
    Answerer
  • Hi Saravanan,

     

    There is less information in your post. In order to assist you to solve this issue, we need more information.

    For further investigation, please provide us the following information:

    ·         Structure of source table and target table

    ·         Some sample data in source table

    ·         Some sample result in target table

     

    If anything is unclear, please let me know.

     

     

    Wednesday, July 28, 2010 11:23 AM

All replies

  • You need to write some logic based on your business requirements and migrate the data... even if you choose using SSIS

    I would also take a look into red gate tools to do such things

    www.red-gate.com

     


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Monday, July 26, 2010 12:00 PM
    Answerer
  • Hi Saravanan,

     

    There is less information in your post. In order to assist you to solve this issue, we need more information.

    For further investigation, please provide us the following information:

    ·         Structure of source table and target table

    ·         Some sample data in source table

    ·         Some sample result in target table

     

    If anything is unclear, please let me know.

     

     

    Wednesday, July 28, 2010 11:23 AM