November 4, 2015 at 9:31 am
Taking a 2005 DB and restoring it on SQL 2012 platform, that restore db is now 2012 but if I change the Compatibility Level (of the restore db) to SQL Server 2005(90) this will say the database is still 2012 by yet is backward compatible to function as a 2005.
November 4, 2015 at 10:15 am
kd11 (11/4/2015)
Taking a 2005 DB and restoring it on SQL 2012 platform, that restore db is now 2012 but if I change the Compatibility Level (of the restore db) to SQL Server 2005(90) this will say the database is still 2012 by yet is backward compatible to function as a 2005.
Is there a question here?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
November 4, 2015 at 10:27 am
Compatibility level affects how the parser, query optimiser and query processor treat some T-SQL constructs (ones that have changed across the versions). It doesn't change the database version, that's defined by what version of SQL the DB is attached to.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 4, 2015 at 12:09 pm
Thank you.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply