Identify databases and tables for Stretch Database with Data Migration Assistant
APPLIES TO: SQL Server (Windows only starting with 2016) Azure SQL Database Azure Synapse Analytics (SQL DW) Parallel Data Warehouse
To identify databases and tables that are candidates for Stretch Database, along with potential blocking issues, download and run Microsoft Data Migration Assistant.
Get Data Migration Assistant
Download and install Data Migration Assistant from here. This tool is not included on the SQL Server installation media.
Run Data Migration Assistant
Run Microsoft Data Migration Assistant.
Create a new project of type Assessment and give it a name.
Select SQL Server as both the Source server type and the Target server type.
On the Options page (step 1), select New features recommendation. Optionally, clear the selection for Compatibility issues.
On the Select sources page (step 2), connect to a server, select a database, and then select Add.
Select Start Assessment.
Review the results
When the analysis is finished, on the Review results page (step 3), select the Feature recommendations option, and then select the Storage tab.
Review the recommendations related to Stretch Database. Each recommendation lists the tables for which Stretch Database may be appropriate, along with any potential blocking issues.
Stretch Database Advisor was previously a component of SQL Server 2016 Upgrade Advisor. At that time, you had to select and run Stretch Database Advisor as a separate action.
With the release of Data Migration Assistant, which replaces and extends Upgrade Advisor, the functionality of Stretch Database Advisor is incorporated into this new tool. You don't have to select any options to get recommendations related to Stretch Database. When you run an Assessment in Data Migration Assistant, the results related to Stretch Database appear on the Storage tab of the Feature recommendations.
Enable Stretch Database.
To enable Stretch Database on a database, see Enable Stretch Database for a database.
To enable Stretch Database on another table, when Stretch is already enabled on the database, see Enable Stretch Database for a table.