Real Time data compare and scheduled data compare

air_salak

Hi,

I want to perform 2 type of data comparisons over 2 database on 2 different database servers. Both database are similar (similar in structures and tables).

1. Real time comparisons and updates. If i update/delete/add anything in database1, i want it to be updated to database2. I only want to select a few tables in database1 for this action, and for all fields in each tables.

2. Able to perform scheduled content comparisons for selected tables in database1 to database2. if there is update in database1, the software able to update database2.

i need the above functions using Red Gate data compare. It is something like transactional replication, but i do not want to spend thousands to purchase additional SQL Server Ent Edition just to perform this. I am not interested to use triggers as there are more than 100 tables that i want to compare and updates.

Please advice. I am new to red-gate software. Thanks.

Chris Spencer

Hi

We also wouldn't want you to spend thousands for overpriced SQL Server editions which is why the professional version of data compare gives you access to a command line interface. An even more sophisticated alternative is to get a SQL Toolkit license and use the public API - this will allow you to schedule automatic comparisons/synchronizations directly from your code.

Hope this helps
Regards
Chris

air_salak

Hi Chris,

Is there any evaluation copy that i can download?

richardjm

You can instructions on how to get a trial at...

http://www.red-gate.com/products/SQL_Toolkit/index.htm

HTH