2

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:

  • Also adding myself as a Synapse Contributor
  • Moving into a new branch
Pingyao
  • 23
  • 5

1 Answers1

1

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.

Pratik Lad
  • 4,343
  • 2
  • 3
  • 11
  • Tried a new browser, as well as clearing cache - still no option to clone Lake database. But, that's kind of a side point / not a concern right now. My main question was about how to clone a SQL database - which OK, not an option, that answers it definitively, thanks. – Pingyao Aug 27 '23 at 04:39