CODEWITHSUNDEEP
azureazure-sql-databaseazure-data-factoryazure-synapse
Nairda123
Nairda123

Reputation: 313

Loading data into Azure Synapse Analytics from Azure SQL Database

I am followin this tutorial to move data from SQL to Azure Synapse https://learn.microsoft.com/en-us/azure/data-factory/load-azure-sql-data-warehouse?tabs=data-factory

However, once I get to step 5c I cannot select a a Database name, Do I have to create an Azure Synapse Database first to copy data over there? I though that is what this tutorial will do?

I have a SQL database and I want to move the data into Azure Synapse.

Thanks

Upvotes: 0

Views: 366

Answers (1)

Nandan
Nandan

Reputation: 4935

Yes, in Azure data factory your source and sink needs to be already present w.r.t database scenarios. So it is expected that you already have an Azure SQL database and Azure SQL datawarehouse in place before proceeding with copy activity

Upvotes: 0

Related Questions