Skip to content

Files

node-mssql-programmatic-use

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
Dec 30, 2022
Mar 29, 2020
Nov 28, 2019
May 2, 2023
Nov 25, 2021
Nov 25, 2021
Nov 25, 2021
Mar 24, 2021
May 1, 2023
Dec 30, 2022
Mar 30, 2025

Node MSSQL Programmatic API Example (JavaScript)

Sample project for Microsoft SQL Server using programmatic API.

Setup

Install dependencies.

$ yarn

Configure database connection(s) in the connections.sync-db.json.

$ cp connections.sync-db.json.example connections.sync-db.json

Run

Run the docker-compose services in order.

$ docker-compose up -d mssql
$ docker-compose up app

Output

example-app | yarn run v1.22.5
example-app | $ /app/node_modules/.bin/sync-db synchronize
example-app | Synchronizing...
example-app |
example-app |  ▸ db1
example-app |    [✓] Synchronization - started
example-app |    [✓] Synchronization - pruned (0.04s)
example-app |    [✓] Migrations - up to date (0.07s)
example-app |    [✓] Synchronization - completed (0.14s)
example-app |
example-app | Synchronization complete for 1 / 1 connection(s). (1.01s)
example-app |
example-app | Done in 1.64s.
example-app | yarn run v1.22.5
example-app | $ node src/index.js
example-app |
example-app | List of table names in the database:
example-app |  [ 'knex_migrations', 'knex_migrations_lock', 'users', 'tasks' ]
example-app |
example-app | List of user names in the database:
example-app |  [
example-app |   'sa',
example-app |   'public',
example-app |   'sysadmin',
example-app |   'securityadmin',
example-app |   'serveradmin',
example-app |   'setupadmin',
example-app |   'processadmin',
example-app |   'diskadmin',
example-app |   'dbcreator',
example-app |   'bulkadmin',
example-app |   '##MS_SQLResourceSigningCertificate##',
example-app |   '##MS_SQLReplicationSigningCertificate##',
example-app |   '##MS_SQLAuthenticatorCertificate##',
example-app |   '##MS_PolicySigningCertificate##',
example-app |   '##MS_SmoExtendedSigningCertificate##',
example-app |   '##MS_PolicyEventProcessingLogin##',
example-app |   '##MS_PolicyTsqlExecutionLogin##',
example-app |   '##MS_AgentSigningCertificate##',
example-app |   'BUILTIN\\Administrators',
example-app |   'NT AUTHORITY\\SYSTEM',
example-app |   'NT AUTHORITY\\NETWORK SERVICE'
example-app | ]
example-app |
example-app | Calculations:
example-app |  { 'Sum of 6 and 7': 13, 'Square of 6': 36, 'Product of 6 and 7': 42 }
example-app |
example-app | Current date time: 2021-03-24T11:36:39.230Z
example-app | Done in 0.95s.
example-app exited with code 0