search

microsoft / MCW-App-modernization

MCW App modernization
MIT License
175 stars 264 forks source link

SQL Backup not found #110

Closed NicoThiemer closed 2 years ago

NicoThiemer commented 2 years ago

When I created the lab, the SQL server is created and the database too. But there is not content in the database. No tables, nothing. In the script configure-sqlvm.ps1 are in line 52: Attach the downloaded backup files. But, how can I find this files? I can't find it in this repository.

NicoThiemer commented 2 years ago

Hm, there is no reaction?

DawnmarieDesJardins commented 2 years ago

@NicoThiemer - Thank you for reaching out, an author will review the issue as soon as possible. Please allow 5-10 business days for issue resolution as stated on the ReadMe page.

timahenning commented 2 years ago

Hi @NicoThiemer, what exercise and task are you on? Did you make it past Exercise 2 step 7?

timahenning commented 2 years ago

Hi @NicoThiemer, I just ran the lab. The tables and data were created. Make sure you log in to the WebVM and let the PowerShell script finish as suggested in Exercise 2 step 7.

image

NicoThiemer commented 2 years ago

OK, I'm MCT and this workshop is part of the Microsoft AZ-305 course. In this course, I start the lab, which is automatically(!) deployed by the training provider. I have no control over it. When the lab is finished, I will also have two VMs in Azure. But the database is not installed on the database VM. I would like to know, what code creates the database? To solve the problem, could you please provide a database backup asap? That would solve the problem. The course starts today…

NicoThiemer commented 2 years ago

what exercise and task are you on? Did you make it past Exercise 2 step 7?

I did it. More than one times :(. And in the script configure-sqlvm.ps1, there is line 52: "Attach the downloaded backup files".

timahenning commented 2 years ago

Hi @NicoThiemer, the database is created and seeded when the web application starts for the first time.

Take a look at the PartsUnlimitedWebsite project:

  1. Program.cs - context.Database.EnsureCreated();
  2. SampleData.cs class.

Your provider may need to update their image of the lab. Optionally, you could run the first part of the lab in a separate subscription and grab a database backup from there.

NicoThiemer commented 2 years ago

Ah, great. Thank you @timahenning. This step (start the web application) was missing in my manual.