Deploying Databse to Microsoft Azure SQL Database

jai kishan 1 Reputation point
2022-05-06T09:58:34.137+00:00

I'm trying to import SQL DB which is around 23 GB from our cloud dedicated server to Azure SQL Database.
After processing of all tables, I got error in

  1. "importing Database" :-
    "Could not import package. (Microsoft.SqlServer.Dac)
    Unable to connect to target server."
  2. Creating Deployment Plan.
  3. initializing Deployment.

Note:

  1. using SQL Server standard Edition 2014-SP3
  2. We can not upgrade it to higher version.
Azure SQL Database
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 32,886 Reputation points MVP
    2022-05-09T13:22:20.417+00:00

    Before trying to migrate a database to Azure SQL Database please perform an assessment using Data Migration Assistant (free tool). Resolve all blocking points before proceeding to migrate to Azure SQL. The same tool can help you with the migration, especially with such a small database, but you can also use Data Migration Service, in case you would like to consider opting for an online migration.

    I have received that error when Windows logins are referenced on the database or when your are using SQL Server Management Studio is used to migrate the database to Azure but you are using an old version of SSMS (if that is the case upgrade to the latest version).