MSSQL Syncer

Sync your stored procedures & functions from SQL Server to files and vice versa.

📦 Installation

npm install -g @enurhadi24/mssql-syncer

⚙️ CLI Commands

mssql-syncer <command>

Available Commands:

| Command | Description | | -------------------------- | ----------------------------------------------------------- | | set-connection <connStr> | Set MSSQL connection string in ADO format | | pull | Pull all procedures/functions from DB into local files | | push | Push all local .sql procedures/functions back to database | | get-connection | Show currently saved MSSQL connection string |

Options

• --version Show version number
• --help  Show help info

📁 Output Folder Structure

After running pull, your SQL files will be saved in the following structure:

sql/
├── procedures/
│   └── your_procedure.sql
└── functions/
    └── your_function.sql

🌐 Optional: Use Environment Variables

If your procedures or functions reference hardcoded database names or linked servers like:

SELECT * FROM [db-prod].dbo.MyTable

They will be dynamically replaced during pull and push using values from a .env file.

Example .env file:

MSSQL_SYNCER_DB_NAME=DUMMY_DB
MSSQL_SYNCER_DB_LINK_SERVER=DUMMY_LINK_SERVER

If the environment variables are not set, no replacements will be made.

🧪 Example Usage

1. Set connection:

mssql-syncer set-connection "Server=localhost,1433;Database=argo-tracking;User Id=SA;Password=MyPass@word;Encrypt=false;TrustServerCertificate=true;"

2. Pull all routines:

mssql-syncer pull

3. Push all routines:

mssql-syncer push

4. View saved connection:

mssql-syncer get-connection

👨‍💻 Author

Created by Endang Nuradi