Data Science Wire

Azure SQL DB HS Data Load Using Microsoft JDBC Driver Instead of Apache Spark Connector for SQL

Azure Data Blog1w4 min read

Introduction Migration from heterogeneous database platforms such as Db2, Oracle, and Sybase to Microsoft SQL platforms has been a common modernization pattern for many years. For large-volume data migrations, customers commonly extract data from the source database in Parquet format, securely transfer it to Azure Storage using SFTP, and subsequently ingest it into Azure SQL Database Hyperscale. Data load from Azure Data Lake Storage (ADLS) Parquet files to Azure SQL Database Hyperscale can be done using Fabric Spark Notebook, Fabric Data Factory, Azure Data Factory, Azure SQL Database Hypersc

Read the full story at Azure Data Blog

More in Data Engineering