search

MicrosoftLearning / dp-300-database-administrator

Repository for lab exercises and instructions for Microsoft DP-300 learning content
https://microsoftlearning.github.io/dp-300-database-administrator/
MIT License
81 stars 89 forks source link

Lab-04-configure-firewall-rule: improvement related to the time taken to Import Data Tier Application task #9

Closed vipaiva closed 2 years ago

vipaiva commented 2 years ago

Module: 03

Lab/Demo: 04

Task: Configure Azure SQL Database firewall rules

Step: 09-15

Description of issue The tasks related to Import Data Tier Application takes over 30min with the current bacpac file. I suggest creating a new bacpac file for AdventureWorksLT2019

image

Using the AdventureWorksLT2019 bacpac, the import task takes less than 5min without compromising the remaining steps.

JulianePadrao commented 2 years ago

Interesting to see it is taking so long as it is the same version that has been used before. I was not able to reproduce the long duration, in my case it was taking less than 10 minutes.

To prevent any issues, I have updated the lab to use the light version of AdventureWorks instead.

Thanks for pointing that out!