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?
Best Answer
Unfortunately, you can't use .back failes in Azure SQL Database (not Managed Instance). I'd sugesst that you should consider to use BCP which is export to local csv or binary files and can import there to Azure SQL Database.