Out of Memory Exception When Creating BACPAC File

by Tim Westover   Last Updated July 16, 2018 17:06 PM

We're having a frustrating time migrating our on-premises SQL application to Azure. The database is large but not crazy, about 265 GB. SQL Server Management Studio > "Deploy Database to Windows Azure SQL Database" will run for 15 - 20 hours, and then fail with a Out of Memory exception when exporting one of our larger tables.

We have BAK files of our database and data. Is there a way to import this into Azure SQL Database?

Related Questions

Add Active Directory User For Azure-SQL-DB

Updated February 25, 2017 13:06 PM