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 |
|
gaby_58
Starting Member
33 Posts |
 Posted - 2014-03-24 : 08:48:38
|
| Hi All, We have databases created in SQL Server 2008 and my company is installing 2014 version now, so will I still be able to access 2008 databases or will there be any problems regarding this? Should I keep both the versions? 2008 version is just a download from website, 2014 will be completely installed on my laptop. Any suggestions are greatly appreciated. Regards and Thanks |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2014-03-24 : 08:54:18
|
Each version of SQL Server supports databases of a few previous versions. SQL 2014 will support databases from SQL 2008 and later. So you should be able to access the 2008 databases after upgrading to SQL 2014. There is one caveat though, and that is that if your databases on SQL 2008 happened to be from an even older version, then they won't be accessible without changing the compatibility level.Run this query on each of your databases:sp_dbcmptlevel 'YourDatabaseNameHere' If it indicates compatibility level 100 or higher, you are fine. If not, you will need to change the compatibility level. Look up Microsoft documentation on changing compatibility levels and what to watch out for. |
 |
|
|
|
|
|
SQL Server Installation Question