We are trying to migrate a database from SQL 2014 to Azure SQL.
In SSMS, you can right click on the database and then on a task to "Deploy Database to Windows Azure SQL Database..".
This task fails because the database uses a SECONDARY filegroup. I've gone through the process to move all indexes, heaps, etc. out of the SECONDARY file group into the PRIMARY filegroup.
However, I still can't delete the file in the SECONDARY filegroup because there is 43MB of data in it. Every script I've found to list all the objects in a filegroup say there is nothing remaining in the file.
How can I determine what's still in this filegroup so I can delete the file and remove the SECONDARY filegroup?