Post reply

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

  • 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 2 posts - 1 through 3 (of 3 total)

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