Retrieve stored procedures. Each Procedure in separate file. SQL 2008 R2
-
How to retrieve stored procedures from exist database each of them into separate file? I know how to retrieve all in one file, but I do not need it. Do I have to save each of them in separate file manually? All ~1500... Is there any tool? Any suggestions? :confused::confused::confused:
We live in a Newtonian world of Einsteinian physics ruled by Frankenstein logic
-
How to retrieve stored procedures from exist database each of them into separate file? I know how to retrieve all in one file, but I do not need it. Do I have to save each of them in separate file manually? All ~1500... Is there any tool? Any suggestions? :confused::confused::confused:
We live in a Newtonian world of Einsteinian physics ruled by Frankenstein logic
From SQL Server Management Studio 2008 R2: you can RT-click the database in question, choose Tasks -> Generate Scripts and select the objects you'd like to script out that way. There is an option to save each object to a separate file ("single file per object" option, I believe).