Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Question about deployi...
Small and medium business | Business Central, N...
Suggested answer

Question about deploying NAV database to Azure

(1) ShareShare
ReportReport
Posted on by oaktree5433 15

Hello all,

I want to deploy a NAV 2013 database on Azure, with near real time capabilities (if the data is refreshed once a day, that is good).

I am using this guide to connect to a test sql server from an Azure VM, and will export data tier application (bacpac) file from NAV and import into Azure SQL.

According to the guide, I have to delete all users who use windows authentication. Moreover, I am getting errors while trying to export the bacpac, such as: 

Error SQL71564: Error validating element [dbo].[pt_hash]: The element [dbo].[pt_hash] cannot be deployed as the script body is encrypted.
When i look for solutions online, I see that I have to unencrypt this procedure.
However, I have been told that these changes will not be possible on the production database. According to my knowledge, even if i schedule a restore of production database everyday (with hopes of using using a copy of production db for Azure), the users and encryption will come back. How can I work around this?
Apologies for my ignorance, I am new to this and might be wrong. Thank you
  • oaktree5433 Profile Picture
    oaktree5433 15 on at
    RE: Question about deploying NAV database to Azure

    Sorry, I meant if NAV data is updated after the bacpac export, this new data will not reflect in Azure on its own right?

  • THE Italian Profile Picture
    THE Italian on at
    RE: Question about deploying NAV database to Azure

    No. Azure SQL will be constantly updated under the hood.

    That is why I am telling you that NAV 2013 - a static out of support version - might not cope with the SaaS evolution and could not work or be broken any time by Azure SQL updates.

    When you move your technology stack in the cloud, they have to follow cloud rules.

  • oaktree5433 Profile Picture
    oaktree5433 15 on at
    RE: Question about deploying NAV database to Azure

    Could I ask you something about the guide?

    With exporting bacpac from NAV server and importing into Azure SQL, we will create a copy of database. Does this also mean Azure SQL gets updated when NAV gets updated?

  • Suggested answer
    THE Italian Profile Picture
    THE Italian on at
    RE: Question about deploying NAV database to Azure

    NAV 2013 is out of support since ages and we declared support for Azure SQL since its R2 version (that is out of support too). 

    All thechnologies that lies beneath might be super old compared to the evolution of the SaaS platform. 

    If you would like to use Azure platform technologies you should first upgrade this environment to a cloud ready version. The best suggestion is to get in touch with your Cloud Solution Provider (CSP) or Reseller in order to orchestrate an upgrade to the latest version as soon as possibile.

    Currently the latest version delivered with NAV brand was NAV 2018 (version 11.x) hence it is super strongly suggested to upgrade to the latest version of its successor (Dynamics 365 Business Central) that currently dispatch version 18.x (2021 Wave 1). 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans