leguvi
Reputation: 11
azure Data factory migrate SQL Server database
I know how to copy data from a database to another, but in one step I must create the exact table in the source db to the destination db.
Is there a method in data factory to migrate a SQL server database to SQL Azure without creating all the tables in the destination database or is Data Factory just for copying data between the tables?
Upvotes: 1
Views: 553
Answers (1)
Alberto Morillo
Reputation: 15648
You can use Azure Data Factory to copy data or copy delta changes from a SQL Server database to an Azure SQL Database as explained on this tutorial. You can also put data coming from on-premise SQL Server to Azure BLOB storage and from there upload data to Azure SQL database as explained here.
Upvotes: 1
Related Questions
- Data Migration - From Cosmos DB to Azure SQL Database through Azure Data Factory
- Back up and restore Azure SQL Database schema
- Azure Data Factory: Migration of pipelines from one data factory to another
- Migrate SQL Server database to SQL Azure
- Data Migration from Azure SQL Databases to Dynamics 365 for Marketing using Azure Data Factory
- Migrating from Azure SQL Database to Data Warehouse
- Azure Data Factory Copy
- Azure Data Factory - Azure SQL Server Destination Schema
- Azure Data Factory - moving data from On-Premise SQL to Azure SQL
- Migrating database to SQL Azure