- #Adventureworks2012 lt script install#
- #Adventureworks2012 lt script windows 10#
- #Adventureworks2012 lt script software#
For now, we're going to analyze our database to see if this is possible. Depending on the results, it's a judgment call on whether to continue with the migration.Īfter starting SAMW, we have a number of actions we can perform. However, there are a lot of features in SQL Server 2008 not supported by SQL Azure see for the list of what is and what is not supported.īefore we do any migration, SAMW can analyze our database, scripts or profiler trace and report back on known unsupported features. Most tables and views should migrate fine, as will most basic stored procedures. SAMW comes packaged as a zip file-no installation is necessary, but you should read the documentation on Codeplex to understand configuration options and how it looks for features not supported by SQL Azure. You can get the SQL Azure Migration Wizard (SAMW) from. I have that installed on a local SQL Server 2008 instance (with SQL Server 2008 R2 client bits installed), so we'll migrate from my local instance to our SQL Azure using the SQL Azure Migration Wizard. For my reporting demos, I prefer to use the DW edition, which is the data warehousing sample. This is a rather puny edition, with all of 32 orders in the database and lacking in some referential integrity. This will take a few minutes.AdventureWorks is the latest of Microsoft's sample databases, and for the basis for a great number of sample applications (including our own Epic AdventureWorks demo.ĪdventureWorks comes in several editions, and the only edition which has a direct Azure migration path is the LT edition ( ). Ensure the master database is selected, and then run the script to create the adventureworks database.Authentication Type: Windows Authentication.In the script pane, connect to your SQL Server Express server server using the following information:.Start Azure Data Studio, and open the adventureworkslt.sql script file you downloaded.Download the adventureworkslt.sql script, and save it on your local computer.
Note that this is not the same as the official sample database, so use the following instructions to create it. The labs use a lightweight version of the AdventureWorks sample database.
#Adventureworks2012 lt script install#
Download and install Azure Data Studio from the Azure Data Studio documentation, following the appropriate instructions for your operating system.Run the downloaded installer and select the Basic installation option.Download Microsoft SQL Server Express 2019 from the Microsoft download center.
#Adventureworks2012 lt script software#
The required software for the labs can also be installed on Linux and Apple Mac computers, but this configuration has not been tested.
#Adventureworks2012 lt script windows 10#
The hosted lab environment provided for this course is based on Microsoft Windows 10 with the latest updates applied as of March 12th 2021.
Microsoft cannot provide support for your own lab environment. However, please note that these guidelines are provided as-is with no warranty. Note: The following information is provided to help you understand what’s installed in the hosted environment, and to provide a guide for what you need to install if you want to try the labs on your own computer. The labs in this repo are designed to be performed in a hosted environment, provided on Microsoft Learn or in official course deliveries by Microsoft and partners.