Applying CU with Azure SQL

(0) Share

Report

Posted on by Gwenael Riotteau

237

I have a database on SQL Azure with a 2016 CU4, and i want to apply the Cumulative Update 6
When i open the database with the dev environement (in order to convert it), i have this message :

The xxx database on the xxx server must be converted before you can use it with this version of Microsoft Dynamics Nav Development Environment.
You must convert the database before it is deployed to a SQL Azure Server

How do i deploy my CU ?
I try with 'Invoke-NavDatabaseConversion', but with no success
(and i do not want to retrieve the database in my local server, convert it and send it again ...)

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Community Member on at

Like (0)

Report

Are you able to convert your database to newer CU from your development environment?

Was this reply helpful? Yes No
Gwenael Riotteau 237 on at

Like (0)

Report

No it's my issue !

i am not able to convert the database (i have the error as soon as i open the database with the development environment)

(the same operation is ok with a database on my local server)

Was this reply helpful? Yes No
Tharanga Chandrasekara 23,118 on at

Like (0)

Report

I had the same issue and what I did was retrieve the DB to local server and then do the upgrade and then upload it back. Since you do not want to proceed that way I will check is there any other methods available to do the database conversion without taking to local server.

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

This problem occours because the master db on Azure SQL is readonly and the NAV upgrade process checks the master db. From NAV 2017 (I dont remember from what CU now) this problem never exists (the master db is not checked).

Was this reply helpful? Yes No