Via the course, you will learn essential hands-on SQL Server Administration tips on SQL Server maintenance, security, performance, integration, error handling and more. (special limited-time discount included in link). Strengthen your SQL Server Administration Skills – Enroll to our Online Course!Ĭheck our online course on Udemy titled “ Essential SQL Server Administration Tips” You can however migrate it to a SQL Server 2008 R2 instance. For example if you have a SQL Server 2000 database you cannot migrate it to a SQL Server 2012 or 2014 instance because there is not backwards compatibility support for such an old version of SQL Server. However, each version of SQL Server supports up to a specific compatibility level. In such cases you can make use of the backwards compatibility the Database Engine of SQL Server provides. Now, you might encounter certain cases where you deal with a “legacy” application and it might be nearly impossible to upgrade its supporting database to a newer version but at the same time you want to move it to a newer version of SQL Server.

Sql server versions