question

Tobz avatar image
0 Votes"
Tobz asked AmeliaGu-msft commented

Setting up a SQL Script Library

Hi,

I am trying to setup a library where I can store SQL scripts that can be accessed by other team members.

Please I need suggestions.

Thanks

sql-server-generalsql-server-transact-sql
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Tobz,
Did the answers help you?
Please feel free to let us know if you have any other question.
If you find any post in the thread is helpful, you could kindly accept it as answer.
Best Regards,
Amelia

0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

There is not really something like libraries in database world.

But in SSMS you can create solution/projects which include several SQL script files.
See
Projects (SQL Server Management Studio)
Create a New Solution


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi Tobz,

You can try to create the templates in the SSMS view menu->Template Explorer, and share with your team members. Please refer to SSMS Shared SQL Templates and Standard template in SSMS which might help.
In addition, you can try to create a script repository stored in table with the PowerShell. Please refer to this article which might help.

Best Regards,
Amelia


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.