Etl migration

  • hi, I am looking for anyone who has performed data migration.

    We shall take data from sql table, transform it, by having old column to new column.

    We may insert data, merge it or append to a key to make it unique.

    It will be oracle to sql and sql to sql.

    We need to keep log, and it also display counts of records, error etc.

     

    Anyway just curious what tools have been used in your job.

     

     

     

     

     

     

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • Your requirement isn't very specific, so here's a very general answer.  You have three choices that I can think of:

    1. A bespoke tool;
    2. SSIS;
    3. Routines that you write yourself using T-SQL, PowerShell, or any combination of your favourite scripting languages.

    John

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

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