Home / server / Questions / 820450
Accepted
Andreas
Asked: 2016-12-14 08:00:50 +0800 CST

Move SQL 2008 database to Azure

  • 772

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].

See below for complete message. Error

Why do I get this error? Maybe there is a better way to export / import a database from SQL 2008 to Azure SQL?

sql-server sql-server-2008 sql azure-sql

1 Answers

  1. Best Answer

    This error is usually caused by a lack of permissions.

    As you are creating a bacpac file to transfer a database to azure, we can rule out permissions on the target server.
    Which means you are most likely missing permission to read the login definitions on the source server.

    You will need to grant your user VIEW DEFINITION ON LOGIN permissions, or add him to a role that has those permissions built in.

    • 2