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
