This chart more or less depicts the SQL Server Life Cycle, and quit of existence assist for distinctive SQL Server versions. It isn't always drawn to scale, however it still can provide a message. Where do your packages stand within the life cycle? If you are like most agencies, you have some of each version somewhere in the enterprise.

Let’s talk about approximate levels of aid. The Greenline indicates complete mainstream assist which includes provider packs, bug fixes, and safety patches. The Yellow line shows extended help. The extended guide is essential “Security Patches” only. The Red dot indicates an “out of assist” scenario because of this that you'll most probably not pass an audit.

SQL Server 2012 comprises a set of programming extensions to enhance the Structured Query Language (SQL), a fashionable interactive and programming language for getting data from and updating a database

CloudMint offers SQL Server 2012 Enterprise Edition image. Enterprise users who are seeking out geared up to apply SQL Server 2012 Enterprise Edition can use this 1-click prepared to use Image.

SQL Server Enterprise Edition gives you comprehensive excessive-cease datacenter competencies with blazing-rapid performance, limitless virtualization, and stop-to-cease enterprise intelligence enabling excessive service degrees for mission-critical workloads and cease user get right of entry to information insights.

Installation of your new SQL Server

Download SQL Server 2017 Express 

If you are on Windows 7 then you may have to set up SQL Server 2012 Express. 

Instructions for installing and configuring SQL Server 

Restoring the IRIS database into your new example and connecting your installation.

For this step, you'll need to hook up with the SQL Server 2017 the usage of the SSMS Instance and repair the IRIS database.

To open SSMS you could click on the start button and look for SSMS or use a run prompt and type SSMS.

Find the steps on the way to repair your IRIS database.

Note: When you view your new example in SSMS you'll not have a database to right-click, you'll need to right-click the Databases folder option instead.

Note: You will want to go to the Files web page in the top left and tick the relocate all files to folder alternative to successfully restore.  Read more SQL Server DBA Training in Hyderabad 

Let’s talk about what every model method for you nowadays (Summer 2013).

• SQL 2000 – Already Dead. Do whatever you can to improve or to rip/replace the machine. If there's a protection flaw, there may be no patch to be had.
• SQL 2005 – Almost Dead. Better here than on SQL 2000, but in approximately 2.five years, any machine on SQL 2005 could be like SQL 2000 is today.
• SQL 2008/2008R2 – You are appropriate for one year in mainstream support. Many agencies have the majority of their structures right here these days. Migrating to SQL 2012 over this coming 12 months makes loads of sense to preserve in compliance and live on a supported version of SQL Server.
• SQL 2012 – Current Version. If the maximum of your systems is on SQL 2012 these days, you have got every other four years of assist.
• SQL 2014 – Coming in early 2014. Supported Life projected till 2019.
• SQL Server 2016 Service Pack 1 

There are tools out there to help you improve from one model to another which includes Upgrade Advisor from Microsoft. Scalability additionally has a device known as Upgrade Assistant for SQL Server which is available from our internet site. And SE may also be engaged to help your crew with the upgrade process. Contact your SE rep these days for extra details.

To learn more approximately upgrading or migrating to SQL Server, please view my page SQL Server DBA Online Training