Re: Code in the database or middle tier (the CLR controversy)

Erland Sommarskog wrote:

> Microsoft has in my opinion a quite elegant take on this: you can run a
> database in compatibility mode for an earlier version. This permits
> MS to drop support or to make incompatible changes in order to improve
> things, but still makes it possible for people to migrate.

[Quoted] I'm not sure I'd use the phrase "quite elegant" as it is just a copy of functionality available in all commercial RDBMS products.

For example Oracle, in its init.ora (now compilable as the spfile), has a parameter called compatible that can be set to a wide range of previous versions. That parameter has existed longer than SQL Server.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)