SQL compatibility changes when migrating to Business Central

Hello All!  I want to make you aware of a change that happened in May 2021 regarding SQL supportability when it comes to migrations to Business Central.  This change was rolled out in the Migration App that requires a SQL compatibility of 130.  What this means is SQL 2014 is no longer supported.  If you are on SQL 2014 and attempt to migrate, you will receive the following error:

ErrorCode=SqlOperationFailed,’Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed with the following error: ‘Database must be compatibility level 130 or higher for replication to function.’,Source=,”Type=System.Data.SqlClient.SqlException,Message=Database must be compatibility level 130 or higher for replication to function.,Source=.Net SqlClient Data

The only way around this error is to upgrade your On Prem SQL database to a version of SQL that supports the compatibility level of 130.  For reference, here is how SQL versions relate to compatibility levels:

COMPATIBILITY_LEVEL { 150 | 140 | 130 | 120 | 110 | 100 | 90 | 80 } Is the version of SQL Server with which the database is to be made compatible. The following compatibility level values can be configured (not all versions supports all of the above listed compatibility level):

This does mean that if you vetted a migration BEFORE May 2021, it would have worked on SQL 2014 but if you are going live AFTER May 2021 you will need to address the compatibility level before you proceed or use a hybrid approach to get the data over to BC for Go Live. 

This change was not taken lightly but it was needed to address issues with sizable tables coming into BC from On Prem environments.  If you have any questions, please let us know but my hopes are we can get this information out there, so you are not caught off-guard if you attempt to migrate in your current environment.

- Advertisement -

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisement -

Latest News

- Advertisement -

More Articles Like This

- Advertisement -