Post reply

Batch job to allow Data migration from different databases in SQL Server 2005

  • September 3, 2008 at 11:03 pm

    #192322

    Hi,

    I have a requirement wherein i need to migrate data from tables A,B,C from one database into another schema tables D,E,F.

    The columns are not similar in both the database tables. I have prepared a list that would define which column would map to what column in the target database.

    Can anybody help me in providing a way by which i can achieve this task as a batch job ? Something like a dbUnit script that needs a query or procedure which would run and insert data into the target database tables based on the select from the original database.

    I will look forward to hear from you soon.:)

    Thanks,

    Vijoy

  • September 4, 2008 at 12:25 am

    #866964

    You should go for SSIS or you can also create the job which can execute the batch script to migrate the data.

    Abhijit - http://abhijitmore.wordpress.com

  • September 4, 2008 at 12:39 am

    #866967

    Hello Abhijeet,

    Thanks for a prompt response. I dont know what SSIS means. But i will definetely look into it rite now.

    Regarding the other part of your reply, I needed that script which i would run as a batch job. Can you please guide me on that ?

    Thanks,

    Vijoy

  • September 4, 2008 at 3:12 am

    #867008

    you just have to write a simple sql statements for getting the data from source table and inserting it into destination.:cool: if you want to put a check that if record exist exist or not then create a join on it and retrieve only those records which are not in destination. 😉

    Abhijit - http://abhijitmore.wordpress.com

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

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