Not a supported version

Question

Hi 

When i  trying to deploy database (This is just test database) from SSMS  (Microsoft SQL Server 2014 - 12.0.4213.0 (X64)  from my local machine. I am getting below error please help me.

Answer 1

If a version incompatibility is reported by a DAC (Data tier application) -based process including deploy to Azure, export, import, extract, the first thing to check is that you are running the latest version of SSMS.  SSMS is available stand-alone and is updated regularly.  As you are exporting and working with Azure SQL Database it is particularly important that you stay on the latest version.  You can download it here https://msdn.microsoft.com/en-US/library/mt238290.aspx   

Answer 2

Hi,

I installed SSMS 2014. But now I am getting some other error.

Answer 3

Vijay, if you look closely at the errors reported you will see the reasons.  The first refers to an encrypted stored procedure, export of which is not supported (hey, it's encrypted!).  The later errors refer to the presence of external references that are not permitted; SQL agent and dbmail are not supported in Azure. 

You can find more information on what is permitted in a DAC package at this link: https://msdn.microsoft.com/en-us/library/ee210549.aspx, and what is supported in Azure SQL Database at this link: https://azure.microsoft.com/en-us/documentation/articles/sql-database-transact-sql-information/#features-partially-supported-in-sql-database-v12 . 

Regarding sending mail from Azure SQL DB, which is not supported, a quick search turned up several discussions on Stack Overflow and this interesting blog post that I'm sharing here with no warranties!  https://vpolizzi.wordpress.com/2010/09/11/database-mail-on-sql-azure/  No idea if there are any issues with this but it certainly is an interesting solution.

Thanks, Bill    

Answer 4

Thank you bill.

I fixed all the issues. Now i am able to deploy.