Post reply

Data Migration

  • January 18, 2005 at 7:09 am

    #164281

    Hi All,

           I have a Employee table in oracle database .Which contain 150 columns

    .I have to migrate those values into another database ,which is sqlserver.

    I need to push the data from oracle(150 columns) to sqlsever but in 5 tables.

    (ie in sql server we have splited those 150 columns in 5 different tables)

    I am .net developer.Can i use DTS to achive the above said problem or What is best method to approach this problem.

    The data migrtaion will happen daily

    Thanks&regards

    Sanjayanthan.v

     

  • January 18, 2005 at 10:16 am

    #537887

    I would create the relevant tables on SQL, create a dts package which loads the requisite data into each table from the oracle server. Should it be your wish, you could truncate the sql tables at the start of the package and schedule it to run daily for the population.


    Shamless self promotion - read my blog http://sirsql.net

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

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