Database portability and other tricks with SqlPackage | Data Exposed

From the creator

Building on data virtualization capabilities in SQL Server 2022 and now Azure SQL Managed Instance, we’re introducing the Parquet data storage capability to SqlPackage in preview. Reading and writing copies of your database is easier and faster for larger databases thanks to the data being stored in Azure Blob Storage as Parquet flat files. Chapters: 00:21 - Introductions 00:48 - What is SQL Package? 02:41 - What are some of the challenges with packages 04:30 - Using Parquet files with packages 07:10 - Showing the difference in speed showing how fast a bacpac can be to Parquet 08:31 - What differences are there for Parquet? 10:39 - Tips and Tricks 11:34 - Closing ✔️ Additional Resources: https://learn.microsoft.com/sql/tools/sqlpackage/sqlpackage-with-data-in-parquet-files https://learn.microsoft.com/shows/data-exposed/sql-server-2022-data-virtualization-and-object-storage-ep-5-data-exposed https://techcommunity.microsoft.com/t5/azure-sql-blog/export-capability-cetas-for-data-virtualization-in-azure-sql/ba-p/3822595 https://github.com/microsoft/dacfx in a new tab 📌 Let's connect: Twitter - Anna Hoffman, https://twitter.com/AnalyticAnna Twitter - AzureSQL, https://aka.ms/azuresqltw 🔴 Watch even more Data Exposed episodes: https://aka.ms/dataexposedyt 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeveloperyt #Azure

Published 2023-11-09 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.