SqlPackage importing of very large bacpacs to Azure 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?
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