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, I thought I better add to this thread as some details are missing. If you want to do it manually you can use Visual Studio locally to connect to the database and extract the stored procedures manually. To do this with Visual Studio Code you mill need to install the MSSQL extension.
If you want to automate this either initialize the folder the local database is stored in as a Git repository is in and synchronize it, or configure the workspace it is in with Git integration. From there you can either create a dacpac to deploy all at once or use another mechanism to deploy the .sql files individually.
I hope this helps.