472,142 Members | 1,244 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,142 software developers and data experts.

Database compare software question

Hello. I have an information question. In my work I often have to
compare databases between releases in order to upgrade them to needed
version of software we developing.
And I am looking for software that could do that. It doesn't have to
be free, but have to be good.
I need to be able to compare table structures, amount of rows,
procedures, triggers.
I found one: Red Gate , but I am not sure that it is the best in the
market, and it is pretty expensive too.
Any suggestions are appreciated.
Thank you in advance.
Jul 20 '05 #1
3 1798

"inna" <me****@hotmail.com> wrote in message
news:34**************************@posting.google.c om...
Hello. I have an information question. In my work I often have to
compare databases between releases in order to upgrade them to needed
version of software we developing.
And I am looking for software that could do that. It doesn't have to
be free, but have to be good.
I need to be able to compare table structures, amount of rows,
procedures, triggers.
I found one: Red Gate , but I am not sure that it is the best in the
market, and it is pretty expensive too.
Any suggestions are appreciated.
Thank you in advance.


I use Red Gate, and I would say that it's one of the cheaper options in the
market for what it does, although I appreciate that what is cheap for one
company may be expensive for another. USD195 is not much money compared to
some other tools (and compared to the cost of MSSQL itself, a developer's
time etc.). For example, Embarcadero has a suite of products for schema
comparison, synchronization etc., and they are arguably much more powerful
than Red Gate, however the cost is significantly higher.

Simon
Jul 20 '05 #2
Hi

This request gets posted almost daily in this news group. By far the best
way to control this is through correct source code control, so you can
script any version of the database at any time.

SQL Server Magazine www.sqlmag.com had a product at reviewed from
www.e-dule.com

You may want to browse/search Google for other postings.

John

"inna" <me****@hotmail.com> wrote in message
news:34**************************@posting.google.c om...
Hello. I have an information question. In my work I often have to
compare databases between releases in order to upgrade them to needed
version of software we developing.
And I am looking for software that could do that. It doesn't have to
be free, but have to be good.
I need to be able to compare table structures, amount of rows,
procedures, triggers.
I found one: Red Gate , but I am not sure that it is the best in the
market, and it is pretty expensive too.
Any suggestions are appreciated.
Thank you in advance.

Jul 20 '05 #3
"inna" <me****@hotmail.com> wrote in message
news:34**************************@posting.google.c om...
Hello. I have an information question. In my work I often have to
compare databases between releases in order to upgrade them to needed
version of software we developing.
And I am looking for software that could do that. It doesn't have to
be free, but have to be good.
I need to be able to compare table structures, amount of rows,
procedures, triggers.
I found one: Red Gate , but I am not sure that it is the best in the
market, and it is pretty expensive too.
Any suggestions are appreciated.

Another that might be examined is at:
http://www.ssw.com.au/SSW/SQLTotalCompare/

Jul 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by democratix | last post: by
346 posts views Thread by rkusenet | last post: by
15 posts views Thread by chaseexchange | last post: by
3 posts views Thread by RichardLamont | last post: by
reply views Thread by Jack | last post: by
reply views Thread by Winder | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.