Forum Discussion
How to restore / migrate / copy the stored procedures and view across / to another workspaces?
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.
Hi mikeburek ,
SqlPackage is a command-line utility (CLI) you can use with SQL databases in Microsoft Fabric to support database portability and deployment tasks. It lets you extract database definitions (schema), views, stored procedures, functions, and more into a .dacpac file, publish those definitions to an existing or new database, and import/export database copies using files such as .bacpac. This makes it easier to manage, migrate, and deploy changes to your Fabric SQL database . You can install and run SqlPackage on Windows, macOS, or Linux using the .NET SDK tool.
For further steps on how to use SqlPackage, Please refer:
SqlPackage for SQL database - Microsoft Fabric | Microsoft Learn
Hi mikeburek ,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
HI mikeburek ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.