Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to do sql DB compare and sync in automated Expand / Collapse
Author
Message
Posted Monday, August 6, 2012 6:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 7, 2012 5:36 AM
Points: 2, Visits: 7
HI

How to do sql DB compare and sync among two database from different server and it will be automated process.(without using any tools)
Post #1340551
Posted Monday, August 6, 2012 6:58 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 13,872, Visits: 9,596
Are you talking about something like Replication, where data will be automatically copied from one server to another? Or about auditing, where data will be compared from one server to another?

What end result are you trying to achieve.


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1340567
Posted Monday, August 6, 2012 7:02 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 5:56 AM
Points: 1,980, Visits: 3,351
Are you synchronising data and/or structure?
What is the purpose of the second server - High Availability, Disaster Recovery, Reporting, Test/Development?

Thanks
Post #1340571
Posted Monday, August 6, 2012 11:41 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 7, 2012 5:36 AM
Points: 2, Visits: 7
I want sync two Database structure
One Database is located in staging server and another Database located in production server. Generally both DB structure is same. But if we upgrade or update staging DB then automatically the production DB also updated by DB structure sync.
Post #1341011
Posted Monday, August 6, 2012 11:51 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, August 14, 2014 6:01 AM
Points: 885, Visits: 259
Pls check this.. May be useful

http://mssqltipsandtricks.blogspot.in/2012/08/how-to-schedule-auto.html


Thanks
Post #1341015
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse