Data Synchronization


We have sql server 2008 standard edition. i have a requirement that the customers need to have a realtime data update onto the test machine from production. But if any issues reported in the production they want to able to run tests on the test machine, which would involve updating and processing the data in the test machine, and the changes done to the test do not propaget to the production. But is this possible with replication or mirroring on? this would throw the databases out of sync with replication and mirroring. If this is not possible how can we achieve this?


more ▼

asked Oct 31, 2012 at 08:56 PM in Default

avatar image

Katie 1
1.4k 132 164 205

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

You could probably use Log Shippung, Replication or Mirroring for this. My choice would possibly be Log Shipping. Either way you would have to stop the process once the issues are reported. At that point you would essentially have two separate databases. Take a backup of the test copy so you can easily go back to the point when the issues were noticed while you try running your tests. Once you have completed your tests you would need to reinitialise the replication/mirroring solution. This is why I would choose Log Shipping as it is likely to be easier to restart, depending on the backup/restore schedules that you use and how often the issues are likely to arise.

more ▼

answered Nov 01, 2012 at 09:38 AM

avatar image

Fatherjack ♦♦
43.8k 79 101 118

(comments are locked)
10|1200 characters needed characters left

You could use mirroring to keep test in sync, but then create a snapshot to create a working version of the database for you to run issues against. This may work if you only need read-only access. See http://msdn.microsoft.com/en-us/library/ms175511(v=sql.100).aspx

more ▼

answered Oct 31, 2012 at 09:13 PM

avatar image

Kev Riley ♦♦
66.8k 48 65 81

snapshot not available on Standard Edition

Nov 01, 2012 at 09:33 AM Fatherjack ♦♦

fair cop

Nov 01, 2012 at 08:14 PM Kev Riley ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 31, 2012 at 08:56 PM

Seen: 825 times

Last Updated: Nov 01, 2012 at 08:14 PM

Copyright 2018 Redgate Software. Privacy Policy