Public Repository

Last pushed: 7 months ago
Short Description
Node.js Development Environment for SQL Server
Full Description

Node.js Development Environment for SQL Server

This image provides an integrated development environment for Node.js with connectivity to a remote SQL Server database. Learn more about SQL Server on Linux. To report issues or provide feedback, please file an issue in the SQL Server in Docker GitHub Repository.

Dockerfile

The following components are included:

  • Ubuntu 16.04 OS layer.
  • Pre-configured Node.js runtime environment (nodejs + npm).
  • tedious Node.js driver for SQL Server.
  • A working Node.js to SQL Server code sample.
  • SQL Server command-line utilities (sqlcmd and bcp).
  • Command-line text editor tools (nano and vim).

Usage

To run an interactive bash session in this container simply run:

docker run -it lbosqmsft/mssql-nodejs-tedious

The following optional environment variables can be provided to create the code sample:

  • $DB_HOST: The IP address or hostname where the SQL Server instance is running.
  • $DB_USERNAME: The database user in the SQL Server instance.
  • $DB_PASSWORD: The database user's password in the SQL Server instance.

    Note: If you are running SQL Server in a Docker container as well, you can obtain the container's IP address using docker inspect <containerID>.

After passing the above environment variables Within the container, you can run the following commands:

  • node connect.js: Execute the code sample to connect to SQL Server. The connect.js file will already have the database parameters.
  • sqlcmd -S $DB_HOST -U $DB_USERNAME -P $DB_PASSWORD: This will run the command-line client for SQL Server where you can execute T-SQL statements against it.

User Feedback


  • For issues with or questions about this image, please contact us through a GitHub issue.

Further Reading


Docker Pull Command
Owner
lbosqmsft

Comments (0)