Very Computer

by **Greg Hine** » Fri, 19 Oct 2001 12:07:42

Hi all,

I'm after a third party product that will compare 2 DB's and generate
scripts on the differences. Ideally it should compare both schema and data
differences.

We are developing an SQL7 product and we what to be able to generate scripts
that can be run on older versions to upgrade their DB's to the current
level, before installing the new application.

What do you recommend?
--

Remove NOSPAM when replying

by **Dejan Sark** » Fri, 19 Oct 2001 17:17:51

Greg,

there are some 3rd party tools. I don't want to recommend any specific tool.
But at this moment I can remember one link only - http://www.sqlcompare.com/
.

--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.

> Hi all,

> I'm after a third party product that will compare 2 DB's and generate
> scripts on the differences. Ideally it should compare both schema and
data
> differences.

> We are developing an SQL7 product and we what to be able to generate
scripts
> that can be run on older versions to upgrade their DB's to the current
> level, before installing the new application.

> What do you recommend?
> --

> Remove NOSPAM when replying

by **Ross Norne** » Fri, 19 Oct 2001 22:00:43

The only tool I have seen is SQL Compare, www.sqlcompare.com I think, we
played with it here and were not very impressed. It does with very basic
databases with very little code or complexity, but when we tried it on our
beta to live server and compared large databases with lots of stored
procedures, it was not very intelligent on figuring out what is a change or
just a quirk in the scripting between the two servers.

--

Ross Nornes
DBA Services Manager
James Tower
http://www.JamesTower.Com

> Hi all,

> I'm after a third party product that will compare 2 DB's and generate
> scripts on the differences. Ideally it should compare both schema and
data
> differences.

> We are developing an SQL7 product and we what to be able to generate
scripts
> that can be run on older versions to upgrade their DB's to the current
> level, before installing the new application.

> What do you recommend?
> --

> Remove NOSPAM when replying

by **Patrick Ikhif** » Sat, 20 Oct 2001 04:46:19

I agree. SQlCompare is not an enterprise class tool

> The only tool I have seen is SQL Compare, www.sqlcompare.com I think, we
> played with it here and were not very impressed. It does with very basic
> databases with very little code or complexity, but when we tried it on our
> beta to live server and compared large databases with lots of stored
> procedures, it was not very intelligent on figuring out what is a change
or
> just a quirk in the scripting between the two servers.

> --

> Ross Nornes
> DBA Services Manager
> James Tower
> http://www.JamesTower.Com

> > Hi all,

> > I'm after a third party product that will compare 2 DB's and generate
> > scripts on the differences. Ideally it should compare both schema and
> data
> > differences.

> > We are developing an SQL7 product and we what to be able to generate
> scripts
> > that can be run on older versions to upgrade their DB's to the current
> > level, before installing the new application.

> > What do you recommend?
> > --

> > Remove NOSPAM when replying

Very Computer

Recommendations Please

Recommendations Please

Recommendations Please

Recommendations Please

Recommendations Please