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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply