dbTalk Databases Forums  

Re: database compare

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss Re: database compare in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Largo SQL Tools
 
Posts: n/a

Default Re: database compare - 08-21-2003 , 04:38 PM






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






Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.