Setting up a SQL Script Library

tobz 161 Reputation points
2021-04-06T20:54:58.263+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,711 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,552 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 40,816 Reputation points
    2021-04-07T06:21:36.277+00:00

    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

    1 person found this answer helpful.
    0 comments
  2. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2021-04-07T07:40:40.843+00:00

    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.

    0 comments