I need to move a SQL 2008 R2 on-premis database to an Azure SQL cloud database. The database is to big to script out with data and Azure SQL cloud cannot restore a standard .bak file.
Trying to use Tasks --> Export data-tier application from this guide toghether with SSMS 2016 to create the .bacpac file that I will import to Azure SQL cloud. But I keep getting this errormessage: User [test_user] has an unresolved reference to login [test_user].
Why do I get this error? Maybe there is a better way to export / import a database from SQL 2008 to Azure SQL?