Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Halle
Starting Member
9 Posts |
 Posted - 2014-02-12 : 03:26:34
|
| We began a new class this week at my college. The class is database management system using SQL Server. Now the class is focused on SQL Server 2008 R2 only. They issued us the book; "Murach SQL Server 2012 for developers" and told us that we are using SQL Server 2008 R2. I have asked the IT department if SQL Server 2012 was backwards compatible. They said no, it isn't. I'm still happy I got the book. I can still start learning SQL Server 2012 in my free time. I understand a database designed in 2012 probably won’t open in 2008 R2 but is the learning concepts compatible? Will you understand 2008 R2 after learning SQL Server 2012 as far as concepts? Are the two similar or are they that different from each other. I know that if someone learns Microsoft Access 2010, it will teach them nothing about Access 2003. Is SQL Server 2012 close enough to 2008 R2 to learn similar concepts? As I am looking through the 2012 book’s table of content compared to the 2008 R2 version, the content look similar. Thanks for any help. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-02-12 : 05:25:30
|
| SQL Server 2012 was backwards compatible. They said no, it isn'tthats not true. All versions of SQL Server are backward compatible including 2012. so all features in previous versions will work fine in 2012 except some really old ones which are documented as breaking changes.I understand a database designed in 2012 probably won’t open in 2008 R2 but is the learning concepts compatible?thats true a database created on 2012 will not work on 2008 R2Basic concepts are compatible between 2012 and 2008 R2 but there are additional features in 2012------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
Halle
Starting Member
9 Posts |
Posted - 2014-02-12 : 09:34:23
|
| Visakh16, thanks for your help. I am amazed that it is so difficult to find a good book on SQL Server 2008 R2. I don't like that "Unleashed Book Series". It's all reference and no hands on work. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-02-13 : 07:53:49
|
quote:
Originally posted by Halle
Visakh16, thanks for your help. I am amazed that it is so difficult to find a good book on SQL Server 2008 R2. I don't like that "Unleashed Book Series". It's all reference and no hands on work.
Very few books (if at all they do) exist with hands on information. For hands on purpose I feel more comfortable to refer blogs rather than using books. As for learning concepts yes they do help.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
SQL Server 2012 & 2008 R2, similar learning?