Search code examples
sql-serverazure-sql-databasebacpac

After upgrade to 2016 can't import Azure V12 bacpac


We've recently upgraded our development server from 2014 to 2016. We had already been using some 2016/Azure V12 functionalities on production in certain views.

Now that we want to restore a recently exported bacpac file from our production database on Azure, it fails with the following message:

enter image description here

Perhaps the internal DB engine is still running on 2014? I couldn't find anything concrete about it on Google.


Solution

  • The documentation on STRING_AGG() indicates the feature is available in Azure SQL Database and SQL Server 2017, but not SQL Server 2016. You need to use only common features if you want to import BACPACs between different versions.

    If this was working before the on-prem upgrade, I suspect that was before the proc with STRING_AGG() was created or changed.