Link to home
Start Free TrialLog in
Avatar of Manojtanwar
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
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

I never tried this before but I would like to get a try when it's possible!

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.
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
ASKER CERTIFIED SOLUTION
Avatar of Deepak Chauhan
Deepak Chauhan
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial