Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Deploying v1 2017 extensions to Azure db using sandbox database
gatsby0121
Member Posts: 13
I've sort of figured out how to deploy to a Nav Database installed on azure, but I have a few questions around performance and optimal setup.
My first attempt was as follows:
My second attempt:
While I've solved my deployment issue, I'm still unclear as to what caused the slow deployment in the first place. I tried changing the recovery model to full, but it still took 3 minutes.
My first attempt was as follows:
- The sandbox database was a backup of the client's database without extensions or custom modifications.
- Both the sandbox database and the customer's database resided in the cloud.
- It took an hour from start to finish (30 minutes just for publishing).
My second attempt:
- The sandbox database was local on my computer, and was just a base install of Nav, no customizations, with the recovery model set to simple.
- I created a local service tier and pointed it to the customer's Azure SQL database.
- It took 3 minutes to deploy.
While I've solved my deployment issue, I'm still unclear as to what caused the slow deployment in the first place. I tried changing the recovery model to full, but it still took 3 minutes.
- Can someone point me to a link that describes what exactly is going on when deploying via a sandbox database?
- Does my sandbox database need to be an exact copy of the customer's database without extensions? For example, if the customer has Lanham installed, and our extension was built with that as a base, does the sandbox need to have Lanham installed as well, or can it just be a base Nav database?
I'm thinking it needs to have Lanham installed because it looks as though the objects are compiled on the Sandbox before the extension is installed on the main database. The reason this is important, is if the sandbox needs to match the live minus extensions, we would need a separate sandbox database for every customer. I'm hoping that Nav just wipes everything from the sandbox database with every deployment eliminating the need for a separate sandbox database for each customers. - There appears to be a lot of network activity between the sandbox and main database during deployment. What is transferred between the sandbox and main database?
0