Reputation: 69
Scheduled SQL Server Instance Push to Azure SQL Database
I am somewhat surprised (still after all these SQL Server Installed Instance (Windows VM Azure) that pushing data, on a nightly schedule, to an SQL Azure database is not straight forward. I see some articles and direction to 'migrate' schemas and data, but what about a nightly job to push from my SQL Server instance to individual client SQL Azure data stores?
Should I start with SSIS? Azure data factory? Python libraries? Why isn't a connection between the two 'native'?
Again, all links and references so far have been for one time migration. I want the two in a data Eco-system with reliable flow.
John
Upvotes: 0
Views: 144
Answers (1)
Reputation: 4464
We do this using SSIS running from the on prem side, because we already have a bunch of SSIS projects hosted on prem, and have yet to migrate anything into azure data factory. We are using SQL authentication to make the connection to the SQL Azure database.
Upvotes: 1
Related Questions
- Create a scheduler in Azure that fetches data from Azure SQL DB and post to on-premise system
- Near real-time ETL of Oracle data to Azure SQL
- Schedule a SQL-query to move data from one table to another with Azure SQL-db
- Options for ingesting and processing data in Azure sql
- Azure Data factory to SQL server in AWS
- Push data to Azure SQL database
- Real time Streaming data into Azure Datawarehouse from sql server
- Push data from SQL Server on Prem into SQL Azure for PowerBI purposes
- Scheduled Tasks with Sql Azure?
- Periodically update data in Sql Azure Database