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 hosting). 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.
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.
Hi, 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
