CODEWITHSUNDEEP
azureazure-sql-database
Joe 89
Joe 89

Reputation: 910

Azure SQL Import Data-tier is not successful

I am trying to import Azure SQL database to my local environment, I am facing the Create Database Scoped Credential issue while importing it. What is the possible solution for this? enter image description here

Upvotes: 1

Views: 96

Answers (2)

Martin Brandl
Martin Brandl

Reputation: 59031

I belive scoped credentials are supported in SQL Server 2016 so you either try it with that or you remove the credentials before importing it:

DROP DATABASE SCOPED CREDENTIAL (Transact-SQL)

Upvotes: 1

Alberto Morillo
Alberto Morillo

Reputation: 15694

Please consider dropping the database scoped credential as shown below:

DROP DATABASE SCOPED CREDENTIAL CredentialName

If that scoped credential was created to create external data sources, then you will have to drop them first.

DROP EXTERNAL DATA SOURCE SourceName

Upvotes: 1

Related Questions