data/schema comparison

[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?

[Hugo Kornelis]

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

[Mork69]

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.

[Dan Guzman]

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" <ks****@nycap.rr.comwrote in message
news:96**********************************@26g2000h sk.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?

[Helmut Woess]

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