Hi all,
We already install and configure NAV 2016 multitenant on Azure VM and On premises enviroment using SQL Server , but now we need using SQL Azure ,we following the same steps but appears errors that we not have in the previous installations ( using SQL Server) .
Are there specific videos or training materials about installing Nav 2016 multitenant enviroment using SQL Azure?
Can somebody help us?
Thanks in advance.
*This post is locked for comments
In case you haven't found an answer yet, I have made a blogpost and a powershell script that might be useful to you. primarilynav.wordpress.com/.../automating-moving-nav-to-azure-sql-and-multitenancy
check this link also, totovic.com/.../nav-on-azure-sql-on-navtechdays
multi tenancy setup on azure sql powershell script is available to download in the blog.
please check the video and new posts in the same blog.
i havent worked with SQL azure but, I think we can combine steps for setting up multi tenancy and steps in video it should work. basically with multitenancy, we will have separate databases for object(application database) and tenants data.
Multitenancy Setup steps -->
http://www.ecanarys.com/blog-entry/microsoft-dynamics-nav-2013-r2-multitenancy-deployment
may be you can try the below steps
first prepare databases for multitenancy within VM SQL server and export to Azure SQL server
1- backup the existing database and restore a new database in the VM sql server.
2- split Application database and customer data(using powershell Export-NAVApplication)
After this step you will have two databases in your VM SQL server
3- Export both databases to Azure SQL.(follow the instructions in above mentioned video)
4-Configuring Middle tier (follow the steps as in link and provide databaseserver as azure instance name)
a-stop service
b-enable multitenancy & set the database name key value as blank
c-start service
d-Mount-NAVApplication database
e-Mount-NAVTenant database
Thanks aavio for your response and help!!.
We watch already this video but the video does not talk about multitenant installation.
The main reason is to reduce the cost of implementation, for us this is the first
implementation of this type.
Thanks.
please check this link "How Do I: Setup Microsoft Dynamics NAV to Work with Azure SQL"
just curious to know, why prefer to use azure sql instead of sql on azure vm.
#1
André Arnaud de Cal...
292,468
Super User 2025 Season 1
#2
Martin Dráb
231,287
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
