Sql-server – SqlPackage importing of very large bacpacs to Azure

azure-sql-databaseimportsql serversqlpackage

I want to import a database from a .bacpac file to a SQL Server in Azure. I read the document.

It says that there is a flag called DatabaseMaximumSize=(INT32).

I wanted to know if there's a limit that sqlpackage can support? For example if I got 8 gb of RAM available, will Sqlpackage be able to load larger .bacpacs than that, meaning it doesn't load it all to the memory?

Best Answer

Is this SQL Server on a VM or Azure SQL Database / Azure SQL Managed Instance ? Probably one of the last 2 as you could just use a backup to restore to SQL on a VM, If you find the import runs to slow just scale up your machine until the import is completed