Recent entries
Author: Galina Snurnikova Created: 11/18/2008 12:21 AM
Everything about database migration and database tools

By Galina Snurnikova on 11/18/2008 12:52 AM

I promised, I continue to describe database comparison tools, which I happened to use. The next tool was Apex SQL Diff 2005.14. The connection is performed quickly. The interesting feature is that the tool can create a database snapshot and compare a database and a snapshot. The other useful feature is that it creates an optional backup of altered database before synchronization and you can return the synchronized database in the previous state. Apex SQL Diff can compare nearly all SQL Server objects.

Read More »

By Galina Snurnikova on 11/18/2008 12:31 AM

In my previous post I wrote about free tools for database comparison. Now I will make a review of some paid products. The next tool I tried was SQLDBCompare 2.4. This program is paid. It costs $129.00 to $599.00. It supports SQL Server 2000 and 2005. You can compare just standard objects by means of this tool (tables, check constraints, primary keys, foreign keys, indexes, views, DML triggers, stored procedures and user-defined functions). The convenient feature is that you can synchronize each database object by copying the object from one database to another. The unpleasant things are error messages on closing and during object synchronization.

Read More »

By Galina Snurnikova on 11/18/2008 12:22 AM

Every DBA encounters a situation when he/she has to compare two databases or schemas. There may be a production and a development database in your system. How to compare them quickly and effectively and make the production database equal to the development one?

Nowadays you can find several tools that will help you to do this. They differ in price, supported objects, variants of synchronization script representation and database platforms supported. Let’s review them.

Read More »