This article gives a quick glimpse on how to run SQL Server 2016 Upgrade Advisor Preview 1.2 against AdventureWorks2014 OLTP database. Once you shoot the Upgrade Advisor, go to Scenarios and then select the first option “Run the Stretch Database Advisor”. Following this, you will get below screen and then click on Select Databases to Analyze. This will then shoot the blade option to select the databases but requires you to connect to which instance the database is located. In the below example I am connecting to my YSMLab01\SQL2016 instance.
After choosing the instance, I am selecting AdventureWorks2014 database and clicking on Run button.
Following the analyzed database of AdventureWorks2014, it has identified the database size and total number of tables being analyzed. By clicking on this result set it further displays the list of tables with status on eligibility to cloud or not. If it has errors then it gives out the reasons on why it is not selected in blade format.
In here, I am further trying to find the problem on why Person.Person was not selected and one of the reasons is because of Default Value Constraints on one or more columns cannot be part of stretch database.
You can see the same results when the stretch database advisor is run against AdventureWorksDW2008R2 OLAP database here.