![]() One of the migration tools which might be suggested is the Data Migration Assistant. Based on your selections the Database Migration Report will provide relevant information such as which migration tools can be used and whether bulk load or replication is a viable option.įigure 1: The data migration guide Database Migration Assistant The Azure Database Migration Guide, creates a customized report on how to migrate your data sources to your selected target versions by following a solid methodology. Regardless of which path you choose, you should start with the Microsoft Database Migration Guide. There are multiple options for upgrading. ![]() It’s been about a decade so there are so many new features that has been added since then it would be hard for me to make a complete list.Īnd of course, the ability to now run on Linux and inside Docker containers. Last but not least, if you upgrade to SQL 2017 or Azure SQL DB or Azure SQL Managed Instance, you will have a whole plethora of new features and functions which will undoubtedly make your life a whole lot easier. Regulatory compliance such as PCI-DSS for credit card transactions may no longer be met, which could put your company at risks for fines or penalties and affect your ability to do business in Europe once the GDPR comes into effect on the 25 th of May 2018.Īdditionally, it will probably result in must higher maintenance costs. You will no longer get critical security updates, which may put your data at risk, and possibly affect your compliance with industry standards and regulations. When the end of support comes around on the 19 th of July 2019 the abovementioned will no longer apply. If you wanted any other kind of support (not security), you can still get it by paying for it. SQL Server 20 R2 are currently in the extended support, which means that security updates are still made available. I will also discuss some of the tools that you might use to make the upgrade as painless as possible. ![]() In this article I am going to tell you why you would want to upgrade to a newer version of SQL Server (2016 or 2017) or Azure SQL Database. If you are still running SQL Server 2008 or SQL Server 2008 R2, now is definitely the time to upgrade. Which is approximately a year from now, give or take a couple of months. After hanging around for a good decade SQL Server 2008 and SQL Server 2008 R2 has started the countdown to its End of Life.ĭ-day for SQL Server 2008 and SQL Server 2008 R2 is set to the 19 th of July 2019. As with everything else, all good things must come to an end. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |