Unable to Clone Synapse Serverless SQL Database

MulluriNivas-6816 60 Reputation points
2024-07-09T14:01:08.92+00:00

I'm trying to clone a Synapse Server less SQL database for testing purposes, but I can't find a "Clone" option when I right-click on the database in Synapse Studio. I checked the Microsoft documentation for cloning Synapse databases, but it only covers Lake Databases.

Has anyone encountered this before, or is there a different way to create a copy of a Synapse Server less SQL database?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,678 questions
Accepted answer
  1. Smaran Thoomu 12,615 Reputation points Microsoft Vendor
    2024-07-09T15:05:00.5333333+00:00

    Hi @MulluriNivas-6816
    Thanks for the question and using MS Q&A platform.

    I understand your concern. Unfortunately, the "Clone" option is not available for Synapse Serverless SQL databases in Synapse Studio. > The cloning feature is currently only supported for Lake Databases, as mentioned in the Microsoft documentation.> https://i.imgur.com/1TXcYAQ.png

    To fix this, try refreshing your browser, clearing the cache, or using a private tab. As a workaround, you need to use other methods like taking a backup and importing it into another database.

    Hope this helps. Do let us know if you any further queries.

    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest