Post reply

Database Migration using SSIS

  • July 21, 2015 at 11:20 pm

    #302607

    Hi ,

    I am having 2 database.

    DB_A and DB_B are the 2 database.

    Now I want to migrate data from DB_A to DB_B.

    I am having 500 tables in both database.I want to to migrate the database in a such a way that If records are new it should be inserted or if exist it should be updated.

    Please suggest me if we can achieve using SSIS.

    Regards,

    Vipin Jha

  • July 22, 2015 at 12:15 am

    #1813998

    Yes, you can achieve this using SSIS.

    ____________________________________________________________

    AP

  • July 22, 2015 at 12:32 am

    #1814002

    Hi Anshul,

    If possible, Please post the solution.

    Thanks

    Rambabu

  • July 22, 2015 at 12:55 am

    #1814007

    http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/75331/[/url]

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • July 22, 2015 at 1:03 am

    #1814011

    Hi,

    As per Vipin requirement, we need to create 500 packages for 500 tables.

    I think this is complicate solution for vipin requirement.

  • July 22, 2015 at 1:10 am

    #1814014

    maddukuru.rambabu (7/22/2015)

    Hi,

    As per Vipin requirement, we need to create 500 packages for 500 tables.

    I think this is complicate solution for vipin requirement.

    You are, of course, welcome to your opinion.

    But if you are going to be negative, at least be constructive about it and offer an alternative.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • July 22, 2015 at 1:35 am

    #1814020

    Hi,

    below link is my suggestion. But here data migration only happened.

    http://www.sqlservercentral.com/Forums/Topic1704137-364-1.aspx"> http://www.sqlservercentral.com/Forums/Topic1704137-364-1.aspx

    But I am also looking for If records are new it should be inserted or if exist it should be updated.

    Thanks

    Rambabu

  • July 22, 2015 at 1:52 am

    #1814022

    maddukuru.rambabu (7/22/2015)

    Hi,

    below link is my suggestion. But here data migration only happened.

    http://www.sqlservercentral.com/Forums/Topic1704137-364-1.aspx"> http://www.sqlservercentral.com/Forums/Topic1704137-364-1.aspx

    But I am also looking for If records are new it should be inserted or if exist it should be updated.

    Thanks

    Rambabu

    I want to to migrate the database in a such a way that If records are new it should be inserted or if exist it should be updated.

    That link does not include a solution for the above.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 8 posts - 1 through 7 (of 7 total)

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