Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!sn-xit-04!sn-xit-10!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: DA Morgan Newsgroups: comp.databases.ibm-db2,comp.databases.oracle.tools,comp.databases.ms-sqlserver,microsoft.public.sqlserver.programming Subject: Re: Code in the database or middle tier (the CLR controversy) Date: Sun, 05 Jun 2005 16:08:33 -0700 Organization: Ye 'Ol Disorganized NNTPCache groupie Message-ID: <1118012928.398487@yasure> User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <1117621720.962502.258120@g49g2000cwa.googlegroups.com> <5lps9190n65mc59r1b7dn74luur3dj18hq@4ax.com> <1117682093.775003@yasure> <1117720147.568210@yasure> <1117748941.505705@yasure> <1117916310.346336@yasure> <1117935507.945926@yasure> <1117995294.829970@yasure> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@oracle.advtechserv.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 18 Xref: dp-news.maxwell.syr.edu comp.databases.ibm-db2:88367 comp.databases.oracle.tools:68644 comp.databases.ms-sqlserver:105261 microsoft.public.sqlserver.programming:483200 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. 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@x.washington.edu (replace x with u to respond)