Manojtanwar
asked on
how to update or sync sql server database from second database in sql server 2012
I have two same database in two different offices. i want to update first office database from second office database when any change or upddate made in second office databse through lan or internet. is that possible. both database are exact same
Thanks
Manoj
Thanks
Manoj
Hi.
1. Have linked server to connect to other database
2. Use table trigger to update other tables remotely to add changes to remote database
1. Have linked server to connect to other database
2. Use table trigger to update other tables remotely to add changes to remote database
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you could be interesting to look into Microsoft Sync Framework on how it can be used to build a synchronizable solution:
Microsoft Sync Framework
https://msdn.microsoft.com/en-us/sync
try look for the Database Synchronization section.
It looks like a feasible solution for Microsoft products.