Looking for a tool that I can compare like db's on different servers.
I.E. I want to compare and see differences in the data on our dev
server versus our production servers.
Anyone know of a good one?

On Mon, 15 Sep 2008 10:53:47 -0700 (PDT), Keith wrote:

>Looking for a tool that I can compare like db's on different servers.
>I.E. I want to compare and see differences in the data on our dev
>server versus our production servers.
>Anyone know of a good one?

Hi Keith,

There are several such products available. One that I have briefly used
is Red Gate's SQL Data Compare 6. I used it too brief to give a
recommendation for or against it, except to say that it fulfilled my
needs at that time.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

Keith wrote:
> Looking for a tool that I can compare like db's on different servers.
> I.E. I want to compare and see differences in the data on our dev
> server versus our production servers.
> Anyone know of a good one?

There is also DB Ghost from Innovartis - it does schema and data
compare combined so you get to see it all in one place. It even
writes a delta script of the differences too.

Another option is the Database Developer Edition of Visual Studio 2008.
It's a bit pricey if you use only the schema/data comparison features,
though.

There are a couple of free options too. One is to script objects to text
files and then use a text compare utility like WinDiff. Another option is
the tablediff utility. See the Books Online for details.

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"Keith" <kstay1@nycap.rr.com> wrote in message
news:96ae388a-19e2-4d57-94e5-4d2479a9224d@26g2000hsk.googlegroups.com...
> Looking for a tool that I can compare like db's on different servers.
> I.E. I want to compare and see differences in the data on our dev
> server versus our production servers.
> Anyone know of a good one?

Am Mon, 15 Sep 2008 10:53:47 -0700 (PDT) schrieb Keith:

> Looking for a tool that I can compare like db's on different servers.
> I.E. I want to compare and see differences in the data on our dev
> server versus our production servers.
> Anyone know of a good one?

Take a look at SQL Examiner (my favorite):
http://www.sqlaccessories.com/Products.aspx

bye,
Helmut