Post reply

updating changes from one database to another database in the same server

  • May 11, 2010 at 9:50 pm

    #222374

    I have a copy of client database say 'DBCopy' which already contains modified data. The copy of the client database (DBCopy) is attached to the SQL Server where the Central Database (DBCentral) exists. Then I want to update whatever

    changes already present in DBCopy to DBCentral. Both DBCopy and DBCentral have same schema. How can i do it programatically using C#.NET maybe with a button click. Can you give me an example code as how to do it?.

    In the actual scenario there are about 7 client database all with same schema as the central database. I am bringing copy of each client database and attach it to Central Server where the central database resides and try to update changes present in each copy of the client database to central database one by one programatically using C# .NET . The clients and the central server are physically seperate machines present in different places. They are not interconnected.

    I need to only update and insert new data. I am not bothered about deletion of data.

  • May 12, 2010 at 1:47 am

    #1165996

    You can use Replication in SQL Server. Also you can use third part tools like SQL Data Compare or SQL Delta.

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG     [font="Arial Black"]here[/font][/url][/right]

  • May 12, 2010 at 9:19 am

    #1166308

    Actually the copy of the client database already has some updates. How do i replicate it to central database?....i had tried transactional replication with push subscription without sending the snapshot (as central database already has scehma defined which is similar to that of client database and there is some data already present in it) but i failed to transfer the updates because when i set the replication for the first time and run the synchronizing agent the data present in the backup database (copy of client database) which already has the modified or updated data is untouched . How do i tackle this. Hope the problem is clear to you. Here i am just attaching the copy of the client database to the server . I just want to transfer the updates already present in the backup database to the central database which is on the same server.

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

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