SQL Server Performance

Need tool for SQL database synchronization

Discussion in 'Third Party Tools' started by Tanai, Apr 16, 2008.

  1. Tanai New Member

    Please can somebody help me with the following:

    Our company has an enterprize site (a very large one). From time to time we need to make changes in it. In other words, we had to synchronize one database (local where we make all changes) and database on hosting. So, we did it manually (wrote scripts and inserted them in database on hos
    ting). But as the databases grew it became impossible to synchronize everything manually. So we need some tool which could cope with this task. The problem is that, as I know, there are many tools which can do it, but we are tight in time and can't evaluate them all. Please share your ideas on what tool is worth evaluating? Thanks in advance.
  2. Luis Martin Moderator

    Check Red Gate Products.
  3. Tanai New Member

    What about Red Gate - we've heard that we can use it as a component (to emplement it into our solution), but we are not sure if we can distribute this component inside our solution.
  4. ghemant Moderator

    This certainly depends upon the business logic and organizational need, allowed latency time and whether automatic fail over is required or not; based on this you can select any out of this four option
    1.) Automatic Fail-Over
    -->a) Cluster
    -->b) Mirroring
    2.) Manual Fail-Over
    -->a) Replication
    -->b) Log Shipping
  5. knowledgy New Member

    Check out Apex's SQL Diff tool also

Share This Page