This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 25%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYR%3C/text%3E%3C/svg%3E)
Hi, where should I practice "Exercise - Migrate a SQL Server database to Azure SQL Database" on?
it requires to restore a backup db file to SQL 2019. I don't have the backup file and SQL 2019.
--
Thank you for the answers.
I installed SQL2019 Developer. and try to install SSMS but it requires .net installed.
try to install .net on my Windows 10. it said "The .NET Framework 4.7.2 redistributable does not apply to this operating system. Please download the .NET Framework 4.7.2 for your operating system from the Microsoft Download Center"
I downloaded and tried to install ndp48-x86-x64-allos-enu.exe. but it says the same message. "The .NET Framework 4.8 redistributable does not apply to this operating system. Please download the .NET Framework 4.8 for your operating system from the <A HREF="http://go.microsoft.com/fwlink/?LinkId=2053894">Microsoft Download Center</A>.
"
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 73%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Hi Youngmi Roh,
As part of the exercise, we have installed SQL Server 2019 Express edition, and we were able to successfully install SSMS (SQL server management studio) without any errors. And we were able to restore the sample database backup file (for example: AdventureWorksLT2019.bak) to SQL Server 2019 Express edition.
SQL Server Express edition is the entry-level, free database and is ideal for learning and building desktop and small server data-driven applications. It is the best choice for independent software vendors, developers, and hobbyists building client applications.
As an alternative, kindly try to install SQL Server 2019 Express edition as well as SSMS 19.2 version in your local PC. Please find the links attached here for your reference:
Kindly ensure to uninstall all the SQL Server instances installed previously in your local PC along with SSMS before going for fresh installation.
If you are still running into issues, please let us know in the comments. We are happy to assist you.
If the information has been helpful in resolving the issue, please consider by clicking "Upvote" on the post.
Thank you.
Hi Youngmi Roh,
Just checking in to see if you had an opportunity to see the above comment. Please let us know if your issue is resolved or not.
If the information is helpful, please consider by clicking the "Upvote" on the post.
If you are still facing any issue, please don't hesitate to reach out to us. We are happy to help you.
Thank you.
Hi Youngmi Roh,
Has your issue been resolved? If you are still experiencing the problem, please inform us. We are happy to help you.
If the information provided is helpful in solving your issue, please consider by clicking the "Upvote" on the post.
Thank you.
Hi Youngmi,
You can download/install SQL Server 2022 Developer Edition on your local windows machine and use that for the exercise. Please navigate to below page and click Download now button under the Developer edition.
https://www.microsoft.com/en-us/sql-server/sql-server-downloads
You will also need an Azure subscription to complete the exercise.
Please click Accept Answer and upvote if the above was helpful.
Thanks.
-TP
Hi Youngmi Roh,
Thank you for reaching out to us on Microsoft Q&A forum.
Just checking in to see if you have got a chance to see the previous response by TP in resolving the issue.
In order to start the "Exercise - Migrate a SQL Server database to Azure SQL Database", we need the following items as mentioned in the link below along with Azure subscription to create Azure resources:
As highlighted in the screenshot we need to first install in our local PC,
To get the lightweight Adventureworks database file (i.e., sample database backup file) follow the below mentioned steps:
a) Click on the "Adventureworks" link available in the source database as highlighted in the screenshot above.
b) Under the 'Download backup files', click on "[] Expand table" to see the Lightweight sample databases.
c) Click on 'AdventureWorksLT2019.bak'(for example) link to download the sample database backup file to our local PC.
d) Next under 'Restore to SQL Server', we need to follow the steps as mentioned in SQL Server Management Studio (SSMS) tab to restore our sample database file (for example: AdventureWorksLT2019.bak) to our SQL Server instance installed in point 1.
Now we can follow the steps as mentioned in the link:
starting from 'Restore a SQL Server database' to complete the "Exercise - Migrate a SQL Server database to Azure SQL Database".
Please find the screenshot attached here for reference after successfully restoring the sample database backup file to a SQL Server instance as mentioned in 'Restore a SQL Server database.'
If you are still running into issues, please let us know in the comments. We are happy to assist you.
If the answer has been helpful in resolving the issue, please consider accepting the answer by clicking on "Accept answer" button to help increase visibility of this question for other members of the Microsoft Q&A community.
Thank you.