Albert
Reputation: 1033
Move data from one database to another in Azure
I'm in the process of migration from dedicated servers to Azure. In my existing SQL Server, I have a few jobs that move data from live database to archives.
From what I have read so far, in Azure you cannot use cross database scritps. The other options I have seen include Azure SQL Data Sync, Azure Factory and maybe SSIS. I have to note that there's some logic on what data is archived and I need the ability to specify this in the query.
Has anyone some experience and what would you recommend?
Thanx
Upvotes: 0
Views: 1460
Answers (1)
jazakari
Reputation: 66
You can use the copy feature inside of data factory to do this now directly in Azure.
Upvotes: 2
Related Questions
- Is it possible to execute a Data Factory Pipeline as a step in a SQL Agent Job on Azure Managed Instance?
- How to select all records from one table that do not exist in another table?
- SQL Update from One Table to Another Based on a ID Match
- Advice on Azure platform to host Data Warehouse
- Azure Data Factory from VM SQL Server to File on FTP
- Real-time data synchronization from Azure database to Azure SQL Data Warehouse?
- Azure Copy data from 1 db to another using SSIS