Forum Discussion

mikeburek's avatar
mikeburek
Icon for Advocate III rankAdvocate III
7 months ago
Solved

How to restore / migrate / copy the stored procedures and view across / to another workspaces?

I want to copy the stored procedures from a Fabric SQL database in one workspace to another workspace.   The only options I see are: * Move to another folder within the same workspace * Restore t...
sql database
  • mikeburek's avatar
    mikeburek
    7 months ago

    There is no solution to do this within Fabric at this time.

     

    There are workarounds with external tools, and some of those methods are the same as a plain SQL Server database.

     

    The reply from deborshi_nag is the closest to how to do it in a Fabric method.

tayloramy's avatar
tayloramy
Icon for Super User rankSuper User
7 months ago

Hi mikeburek, 

 

I don't believe there is any direct way to copy DDL from one SQL database to another. What I would recommend is you script out the procedures, and then re-create them in the new SQL database.