Post reply

Data Migration in SQL Server 2005 having difference in the table name and filed names

  • May 5, 2008 at 11:43 pm

    #185093

    Hi,

    I have two different databases in SQL Server 2005, Both the DB's having the tables for a similar purpose.

    Example In DB1 i have a table called users with userid,username,logindate as the fields

    In DB2 i have a table with the name tblusers with the following fields intuserid, txtusername,dtlogin, remarks [ allows null ]

    If the structure is some what like this in my 2 different database and i need to migrate the datas from DB1 to DB2 how do i go with this,

    please any one help me it is very urgent

    With Regards

    Dakshina Murthy

  • May 6, 2008 at 3:38 am

    #811076

    You can do this using an SSIS package. Have you tried it and are you facing any problems with it?

  • May 6, 2008 at 3:58 am

    #811084

    I havent tried it , i will try that and let you know if i have any problem. Thanks a lot for the instant reply.

    One more thing can i use Export option in the Database.

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

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