title: Azure Data Factory - Azure SQL Server Destination Schema
body: <p>I need to copy several hundred tables from an on-premise SQL Server to an Azure SQL Server using ADF.  I don't have access to the DB or the network it's on, but I was able to get the on-prem data gateway installed, given an AD account with sufficient DB privileges, and then use the "Copy Data (Preview)" to copy all tables to blob storage.</p>
  
  <p>My problem is that I don't have access to the DB's schema, so I can't easily provision the Azure SQL Server with the necessary tables/columns since there are several hundred tables &amp; performing manually would be extremely time consuming.  I found that copying to an Azure Data Warehouse has a "Auto table creation" feature &amp; I am able to copy from on-prem SQL Server directly to Azure DW without defining a schema at the destination, but this isn't supported on Azure SQL Server.</p>
  
  <p>Is there a way to obtain the same script/method that provisions the Azure DW schema &amp; use it for Azure SQL Server?  Is there any other way to obtain the source DB's schema via the on-prem data gateway?</p>