Post reply

Data migration from one database to multiple databases

  • January 29, 2018 at 4:27 am

    #343440

    Hello,

    There are millions of records in one database and expecting to migrate records from two or more tables to other database in different domain. What is the fastest way to achieve this migration?

  • January 29, 2018 at 8:27 am

    #1977701

    Why would you migrate only some tables? If you are sharding the DB to give a separate server to certain clients or geographical locations then SSIS is your tool, to define the databases and keep them in sync, assuming you are starting from scratch, then you may want to look at Flyway.

    ...

  • January 29, 2018 at 3:11 pm

    #1977790

    banda.sai - Monday, January 29, 2018 4:27 AM

    Hello,

    There are millions of records in one database and expecting to migrate records from two or more tables to other database in different domain. What is the fastest way to achieve this migration?

    IMHO, backup and restore.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • January 31, 2018 at 12:30 am

    #1977999

    HappyGeek - Monday, January 29, 2018 8:27 AM

    Why would you migrate only some tables? If you are sharding the DB to give a separate server to certain clients or geographical locations then SSIS is your tool, to define the databases and keep them in sync, assuming you are starting from scratch, then you may want to look at Flyway.

    Thank you Geek.

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

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