How to save a stored procedure into Azure SQL Server

0
votes

I am writing a test stored procedure on visual studio code (I cannot install SQL Server Management Studio or Visual Studio as I don't think its available on Linux Ubuntu).

storedProcedure1

I need to save this stored procedure on my Azure SQL Server because I am adding stored procedure activity to my pipeline in Azure Data Factory, and I have to select the store procedure while connecting to the Azure SQL Server.

storedProc2

Here is my Azure SQL Server where I can find the system stored procedure but I cannot find the place where I can save my stored procedure or queries to the SQL Server.

storeproc3

1
stored-proceduresazure-data-factoryazure-sql-server

1 Answers

0
votes

I just found out a solution. I need to be able to execute successfully the stored procedure first on my vscode. Then; after I see the stored procedure that I wrote appeared on Azure SQL server.