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.
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).
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.jsfile 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.
- For issues with or questions about this image, please contact us through a GitHub issue.
- SQL Server on Linux for Docker documentation
- SQL Server - Developer Getting Started Tutorials
- SQL Server Docker GitHub Repository