Databases can sometimes be forgotten - hidden behind the applications that they support. Yet, if you find yourself without support and your data is left exposed – even temporarily, you may be putting your organization at risk.
For those organizations still running SQL Server 2005, it may be time to seriously start evaluating an upgrade. On April 12, 2016, after ten years of going strong, extended support for all versions of SQL Server 2005 is coming to an end. The good news is, over the last decade, Microsoft has continued to invest in this technology and SQL Server has evolved to be an enterprise-class solution to support the growing business needs of organizations - large and small. Upgrading is not just a maintenance task, but an opportunity to provide new value to your business.
With April 12th right around the corner, there's no better time to start the evaluation process.
Depending on the type of application, the migration destination, the scale of the move and resources allocated, migrations can take several months, and without extended support you will no longer get security updates and may also experience:
Higher maintenance costs
Potential compliance issues
Watch this short video Is It Time To Upgrade You Database? to help you determine if it’s the right time to migrate and begin achieving breakthrough performance with a move to SQL Server 2014 and/or Azure SQL Database.
In addition to deciding if it’s the right time for you to upgrade, you'll need to weigh all your migration options.
- SQL Server 2014 (On-Premise Server)
SQL Server 2014 can provide very fast performance with built-in technology to speed up applications compared to older versions of SQL Server. In fact, SQL Server 2014 benchmarked 13x faster than SQL Server 2005 and 5.5x faster than SQL Server 2008. Reduced downtime, increased mission-critical uptime, fast failover, improved manageability, and better use of hardware resources are just some of the benefits that users report after leveraging SQL Server 2014.
- SQL Azure (Cloud)
With SQL Server 2014 available on Azure, you can prioritize cost savings and minimal administration.There are currently two options for hosting: SQL Server workloads in the cloud through Azure SQL Database (Software-as-a-Service/ SaaS) or SQL Server on Azure Virtual Machines (Infrastructure as a Service/ IaaS). We can walk you through which options make the most sense for you.
- Hybrid Approach: On-Premise Server + Cloud
Microsoft has added several hybrid cloud options to SQL Server 2014 that is showing real value, even for those who continue to run on premise. The hybrid cloud options don’t require you to move your entire SQL Server databases to the cloud. Instead, you can extend to on premise SQL Server instances to the cloud where it makes sense for your business. With enhancements to SQL Server 2014’s Backup, AlwaysOn Replicas, and SQL Server Data Files, these hybrid options can cover all the bases of a complete and secure SQL Server setup.
- Disaster Recovery As A Service – DRAAS
Allows on premise database to sync out to the cloud for backup and disaster recovery. This can be the best of both world while it allows for fast on LAN speeds and full operation ability in the cloud.
What is the best path for you?
Utilizing Microsoft-based funding, Interlink is currently offering a detailed SQL Modernization Assessment along with a Proof of Concept for SQL Server 2014 and SQL Azure. Through both the assessment and POC, our team can help you determine the right approach, technologies and tools for data platform modernization for SQL Server 2014 and/or SQL Azure Database. The scope, activities, and deliverables for each will vary based on your unique objectives, ultimately tailoring the right fit for your organization the first time.