Database compare software question

[inna]

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.

[Simon Hayes]

Re: Database compare software question


"inna" <mednyk@hotmail .com> wrote in message
news:347a408b.0 401160757.4dfdf aeb@posting.goo gle.com...[color=blue]
> 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.[/color]

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

[John Bell]

Re: Database compare software question

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

https://www.e-dule.com

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

John

"inna" <mednyk@hotmail .com> wrote in message
news:347a408b.0 401160757.4dfdf aeb@posting.goo gle.com...[color=blue]
> 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.[/color]

[mountain man]

Re: Database compare software question

"inna" <mednyk@hotmail .com> wrote in message
news:347a408b.0 401160757.4dfdf aeb@posting.goo gle.com...[color=blue]
> 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.[/color]


Another that might be examined is at:

http://www.ssw.com.au/SSW/SQLTotalCompare/