473,836 Members | 1,474 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SQL Databases compare tool

Can someone recommend what SQL Database compare tool to use
and why?

Thank you

Jul 23 '05 #1
1 1729
I recommend you check out DB Ghost (www.dbghost.com).

Not only does it compare databases and give you the differences, it can
also generate a delta script that is *guaranteed* to work.

It works on data as well as the schema (metadata).

Once you evolve beyond simply comparing databases is when DB Ghost
really starts to shine as it's big differentiator is that it can
compare and upgrade a target database from simple drop/create scripts
held in source control. The reason that this concept is so powerful is
that, no matter how many developers you have, as a DBA/Configuration
Manager your workload does not appreciably go up when it comes to
deploying the changes. The simple rule for the developers is 'If it is
checked in to source control it will be promoted at the next release'.
For the DBA all that is needed is a simple execution of DB Ghost to
compare and upgrade the test (for example) system. No matter how many
changes have been made, it could be one, it could be thousands, DB
Ghost will handle them all automatically.

The reason that this method is so compelling is that a major bottleneck
and time waster in most processes is the release process. What do you
use? the development database? Even when you use a
database-to-database diff tool you still have the onerous task of
looking at all the differences and deciding which does and does not get
promoted. It's a job I've done before and I found it excruciatingly
dull. With DB Ghost you don't have to filter the list of differences,
you simply use what is in source control. If there are any problems
discovered later on then you have a full audit trail in your source
control system of who made what change, when and why.

DB Ghost is the only tool that provides this integration with source
control and every one of our customers can't imagine developing SQL any
other way now.

So that you can be the judge a fully functional evaluation version can
be downloaded at



Jul 23 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Cara | last post by:
LAST CALL FOR VOTES (of 2) unmoderated group comp.databases.etl Newsgroups line: comp.databases.etl Extraction, transformation, loading issues. Votes must be received by 23:59:59 UTC, 12 Dec 2003. This vote is being conducted by a neutral third party. Questions about the proposed group should be directed to the proponent.
by: Evgeny Gopengauz | last post by:
Hello all! My question is: how to compare two database structures if I only have their DDL files? As the result I would expect an sql-script upgrating one database structure to another. The most 3rd-party tools I tested require connection to both databases. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!
by: serge | last post by:
Is there a way to compare two databases one being an old database and the second being a new database, I will update the old database's objects to match the new database's objects? Is there SQL code that could do this easily? How do you do this if you deal with the same scenario? Thank you
by: rcamarda | last post by:
Hello, I wish to see if the tables from database A server A1 exist in database A on server B1. I setup a linked server from my first server (robertcamarda) to a target (cognos-dev) This works from robertcamarda: select count(*) from .ds_v6_source.dbo.stdmas and this works: select * from ds_v6_source.information_schema.tables order by
by: shsandeep | last post by:
Is there any provision in DB2 to compare databases, something similar to the diff operator in unix. As I was not able to find any, i reverse engineered the databases into ERwin and used the 'Complete Compare' feature of ERwin. I have heard that oracle has such a tool called 'Change Manager'. anything for db2? Cheers,
by: reviswami78 | last post by:
I'm a newbie to RDF and have been facing a fundamental question as read more about RDF. RDF positions itself away from plain XML representations of data saying XML suited for representing data with containment hierarchies, and where "order" is important, whereas RDF has a flatter structure, represents only references among different entities. That sounds just like what a relational database is supposed to do, and those are critieria when...
by: Rodjk #613 | last post by:
Hello, I am working with a database that is in use in several locations. The structure of the databases are identical, but the data is different. I am tasked with combining the data into one large database. (It is SQL 2000) I have .bak files for each location. Is there any way to restore a backup into a database, combining the data?
by: teddysnips | last post by:
I have upsized a client's application from Access BE/FE to Access FE/ SQL Server. All is fine with initial testing, and they want to run the systems in parallel prior to going live. The MD, who is not particularly technical, is more or less insisting that every day a comparison is made of the two data repositories to see if they are out of sync. There are about four users who will be expected to key the data into the two systems...
by: BilalMahmood | last post by:
Hi all, Can anyone tell me that who can i compare 2 databases. I have a backup database and a current database. I want to know what is the difference between both in terms changes in table schema, stored procedures, views, UDFs. I there any tool available for this.
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.