How can we help you today? How can we help you today?

Real Time data compare and scheduled data compare

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.
air_salak
0

Comments

3 comments

Sort by
  • 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
    Chris Spencer
    0
  • air_salak
    Hi Chris,

    Is there any evaluation copy that i can download?
    air_salak
    0
  • richardjm
    You can instructions on how to get a trial at...

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

    HTH
    richardjm
    0

Add comment

Please sign in to leave a comment.