question

jaikishan-2609 avatar image
0 Votes"
jaikishan-2609 asked GeethaThatipatri-MSFT commented

Deploying Databse to Microsoft Azure SQL Database

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
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered GeethaThatipatri-MSFT commented

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



· 1
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

GeethaThatipatri-MSFT avatar image GeethaThatipatri-MSFT ·

Hi, @jaikishan-2609 Please let us know if you find the above reply useful. If yes, do click on the 'Mark as answer' link in the above reply. This will help other community members facing similar queries to refer to this solution.

Regards
Geetha

0 Votes 0 ·