467,211 Members | 1,257 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,211 developers. It's quick & easy.

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
  • viewed: 1671
Share:
3 Replies

"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
1 post views Thread by poppybush@gmail.com | last post: by
14 posts views Thread by kdv09@excite.com | 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
By using this site, you agree to our Privacy Policy and Terms of Use.