Posted by Mork69 on 09/01/07 07:39

Hi Richard,

Erland is quite right - having the scripts that create your entire
schema under source control is the most fundamental step in taking
control of database changes. But how do you propagate changes to
CREATE scripts through to your test and production databases easily?

That's where DB Ghost (http://www.dbghost.com) comes in. It is not
like the myriad of "diff tools" out there that just write you an
upgrade script of the differences between two databases as it enables
your "source database" to be a set of CREATE scripts thereby
automatically giving you all the benefits of source control, but for
SQL (versioning, history, diffs - basically who changed what, when and
why).

The other big differentiator for DB Ghost is that, when it does
produce a delta script it is guaranteed to work - a feat not managed
by most products on the market.

Kind regards,

ML
Innovartis Ltd. (http://www.innovartis.co.uk)
DB Ghost, build, compare and synchronize from source control =
database change management for SQL Server

[Back to original message]