Mike,
I own both Red-Gate and AdeptSQL. The Red-Gate product is so slow it's
almost unusable. AdeptSQL is unbelievably fast. In fact, Red-Gate takes at
least 20 minutes to compare my two databases containing roughly 3200
objects. AdeptSQL takes under 1 minute. Adept also allows me to execute
change scripts right inside the program. I have to copy and paste in
Red-Gate. Adept has at least 2 frustrating bugs which the author seems
unwilling to acknowledge (I've tried twice) but fortunately they are fairly
easily worked around. Red-Gate also has a bug in that it doesn't recognize
changes in foreign key contraints.
J.R.
Largo SQL Tools
The Finest Collection of SQL Tools Available
http://www.largosqltools.com
"mike guice" <mike.guice (AT) rbc (DOT) com> wrote
Quote:
Anyone
Does anyone know of a good database compare program? This
program needs to be run daily (scheduled without any
manual intervention) and compare two databases. The
results (differences) need to be written to a file.
Your help will be greatly appreciated!
Thanks
Mike Guice
mike.guice (AT) rbc (DOT) com |