How to do sql DB compare and sync in automated

Question

How to do sql DB compare and sync in automated

sam_surya

Grasshopper

Points: 22
More actions
August 6, 2012 at 6:36 am

#279240

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)

Viewing 5 posts - 1 through 4 (of 4 total)

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

GSquared SSC Guru Points: 260824 More actions · Answer 1

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

Gazareth One Orange Chip Points: 27737 More actions · Answer 2

Are you synchronising data and/or structure?

What is the purpose of the second server - High Availability, Disaster Recovery, Reporting, Test/Development?

Thanks

sam_surya Grasshopper Points: 22 More actions · Answer 3

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.

deepzzzz SSCrazy Points: 2890 More actions · Answer 4

Pls check this.. May be useful

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

Thanks