January 9, 2014 at 7:56 am
Is there a way to schedule a job (daily, weekly, twice a month) to synchronize a production database to another server using Red Gate's SQL Data Compare?
January 10, 2014 at 3:53 am
Sure. You can use SQL Agent to call the command line utility of Data Compare. You can then have that output to a report, generate a script or even update databases on the fly. Here's a getting started page on the Red Gate web site.
Disclosure: I work for Red Gate
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 14, 2014 at 7:47 am
thank you for the link, one more question, how do you compare/synchronize databases on remote server?
January 14, 2014 at 10:55 am
Ah, a remote server is tough. You either have to have a tunnel to it through the firewall (and that's whether or not you're using SQL Compare) or, you have to export a copy of it, send it back over the wire, and then use the scripts to compare to (SQL Compare can compare to scripts as well as databases or even backups).
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply