CODEWITHSUNDEEP
azureazure-synapsedelta-lake
Pingyao
Pingyao

Reputation: 109

How to clone a SQL database in Azure Synapse - no menu option, despite being Synapse Administrator

I'm trying to clone a Synapse Serverless SQL database, so I can test with it.

When I click a SQL database in Synapse Studio, there's no option to clone.

No 'Clone' option in menu

I am the Synapse Administrator - Blacked out personal details - it's really me there under 'Synapse Administrator'

I don't see MS documentation on how to clone a SQL Database in Synapse Serverless.

I do see MS documentation on how to clone a a Lake Database in Synapse. The page shows a 'clone' option when on clicks on the three dots next to a Lake database name.

But I don't see the 'Clone' option for Lake Databases either

The only caveat in the document is

"Synapse Administrator, or Synapse Contributor permissions are required on the Synapse workspace for creating a lake database."

But again, I am a Synapse Administrator.

I've tried:

Upvotes: 2

Views: 433

Answers (1)

Pratik Lad
Pratik Lad

Reputation: 8402

I tried the same In my enviroment.

  • For lake database I am getting a Clone option when I have Synapse workspace Administrator role to user.

https://i.imgur.com/1TXcYAQ.png

To resolve this, try to refresh the browser and delete the cache or try with Privat tab.

And for serverless SQL there is no such Option is available for that you need to try with others method like taking backup and importing it in another database.

Upvotes: 1

Related Questions