Using ACI to Convert a Backup to a BACPAC for Import into Azure SQL DB
Importing an existing SQL Server database into an Azure SQL Database is not a trivial task. You can only import a .bacpac file – you can’t attach a database or restore a backup. However, if you have a database backup file, you can convert it to a .bacpac! Join this session to learn about a project that will ingest a SQL Server .bak file into Azure File Share, create an Azure Container Instance running SQL Server, restore the database, and create a bacpac for import into Azure SQL Database. It demonstrates the power of linking multiple Azure services together, and will provide a great use case for SQL Server in containers.
Jes Schultz is a Software Engineer with Microsoft who has experience with a wide range of SQL Server features from version 2005 through 2019, and is on the cutting edge with Azure technologies. Since graduating Fox Valley Technical College with an IT-Programmer/Analyst degree, Jes has worked as an SSRS developer, DBA, and consultant. Before joining Microsoft, Jes was a six-time Data Platform MVP, recognized for her community work. Jes tackles every project and problem with tenacity and her enthusiasm is unmatched in the SQL Server community. In her free time, Jes never stops moving, and counts fitness, coffee, cooking, and travel as essentials in life.
You can also dial in using your phone.
United States: +1 (646)[masked]