03-22-2022 06:24 PM
Created by @asharifian, SnapLogic
This pattern migrates table data from SQL Server and loads them to Azure SQL. Business case: SQL Server is the transactional database and encounter high data usage. Azure SQL is utilized for analytics and BI reporting. This use case is for a one-time data migration. Thereafter if necessary, a delta pipeline can be created by modifying these pipelines.
Prerequisites:
Sources: SQL Server Tables
Targets: Azure SQL Tables
Snaps used: JSON Generator, Pipeline Execute, Tail, Email Sender, Azure SQL - Execute, SQL Server - Execute, Azure SQL - Bulk Load
SQL Server-Azure SQL-Data Migration.slp (8.9 KB)
z_SQL Server-Azure SQL-Data Migration.slp (6.8 KB)