As part of this simulated development environment, the developer uses a lightweight data access layer container that implements a simple ASP.NET Core 2.0 REST API web application prototype. Using SQL Server Management Objects (SMO), the prototype provides a RESTful interface for SQL Server running on-premises, Azure SQL Database, and Azure SQL Data Warehouse. This lightweight data access layer for HTTP clients, which simulates a typical three-tier database application design, enables the developer to create web-based business reports.
The developer obtains the container image from a Github repository by running the following Docker pull command:
$ docker pull sanagama/mssql-restapi
The developer then saves the image to the local private registry by running the following Docker push command:
$ docker push localhost:5000/mssql-restapi