Post reply

Data Migration using ETL

  • March 10, 2014 at 11:53 am

    #151328

    Hi friends,

    In our organisation we have develop new Database structure from existing database , but the new database structure is completely different from the existing one, now we want to migrate the existing database data to new database,need suggestion on how can that been done?

    we are planning for Microsoft SSIS i.e ETL for the same is that a feasible solution?

    Thanks in advance,

    AS

  • March 10, 2014 at 12:14 pm

    #1695696

    archi (3/10/2014)

    we are planning for Microsoft SSIS i.e ETL for the same is that a feasible solution?

    Exactly, SSIS is designed for such stuff.

    Igor Micev,My blog: www.igormicev.com

  • March 10, 2014 at 12:26 pm

    #1695701

    Thanks for reply.

    But how to go for it, i mean what are the Steps for it to process with?

  • March 10, 2014 at 12:33 pm

    #1695702

    care to share some of the "differences".....and provide an idea of what the exg db tables/columns map to in the new db.

    whatever process you use....you will need to map these.

    also some idea of the number of tables and rows that require to be moved.

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • March 10, 2014 at 12:40 pm

    #1695704

    archi (3/10/2014)

    Thanks for reply.

    But how to go for it, i mean what are the Steps for it to process with?

    If you don't have some experience with SSIS, than you can start with this link: http://technet.microsoft.com/en-us/library/jj720568.aspx

    Once you start you'll like it.

    Igor Micev,My blog: www.igormicev.com

Viewing 5 posts - 1 through 5 (of 5 total)

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