What is the "Improved SQL 2000" Support?
Some of this information was in a response to an earlier post by Chris
Tybur a few weeks ago. If you read between the lines, you can see how
support for SQL 2000-specific features has been enhanced:
1. Issues relating to User-Defined Functions, exclusive to SQL 2000:
"Fixed problem with script order of UDF dependant tables. This was because
UDF dependencies were being incorrectly described as table type dependencies
and not UDF type."
2. Bug fix for Cryptographic Context Error: I believe that this problem
crept in due to a change in security capabilities in SQL 2000.
There are probably more, but I don't have any information on the 1.51->1.61
I wouldn't upgrade for performance reasons, if that's your primary logic
for an upgrade. SQL Compare slowed down quite a bit between 1.61 and 2.01
due to improvements in dependency checking. Between 2.01 and 2.03, it was
optimized a bit. The next version, due out in a few weeks, will be quite a
bit faster than 1.61 judging from the early Alphas I've seen.
So if you're happy with 1.51, I would wait for the next version. If you
really need the enhancements in 2.03, by all means, buy it and help pay my
salary! You may be eligible for an upgrade discount if the upgrade comes out
soon after your purchase (see upgrade policy
http://www.red-gate.com/upgrading.htm), and if you order 1 year of support,
the upgrade is absolutely free.
"dennis" <[email protected]> wrote in message
> In the upgrade information it mentions "Improved SQL 2000 Support", what
> fact does this mean? We have 1.51 already and are looking for what is the
> compelling reason to upgrade to 2.03. The only compelling reason so far I
> saw mentioned in the newsgroup was speed.