By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,574 Members | 1,977 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,574 IT Pros & Developers. It's quick & easy.

data/schema comparison

P: n/a
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?
Sep 15 '08 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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
Sep 15 '08 #2

P: n/a
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.
Sep 16 '08 #3

P: n/a
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?
Sep 16 '08 #4

P: n/a
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
Sep 16 '08 #5

This discussion thread is closed

Replies have been disabled for this discussion.