Docker SQL Server containers and SQL clones for devops

Develop, test, deploy upgrade/rollback scripts with production data, Git, Azure devops

Windocks containers with Windows auth for SQL Server 2008 to 2017, developer, standard, enterprise, Windows Server 2012R2, 2016

Download Free Edition Azure Devops with SQL

"....Windocks has evolved into an enterprise data delivery solution"

Finance, healthcare, retail & consulting case studies

Financial

Healthcare

Retail

Consulting

Azure devops with SQL Server

Use SQL Server production data easily in Azure devops pipelines. Test applications, upgrade and rollback scripts on production data in builds, test, and staging .

SQL Server devops

Reporting Service containers

Run multiple SQL Server Reporting Service (SSRS) instances on one VM with Azure SQL, SQL Server containers on Windows or Linux, or any SQL Server instance on cloud or on premise.

SSRS on Azure

SANs with SQL containers

Windocks delivers SQL Server containers with databases cloned from storage area networks (SANs), such as Pure Storage, Netapp, Cohesity, and others.

SANs for devops

Introductory video

Windocks delivers SQL Server containers with fast SQL clones of terabyte+ databases on Windows Server 2012 R2, Server 2016 and all versions of SQL Server (2008, 2008 R2, 2012, 2014, 2016, 2017) and all editions (Express, Developer, Standard, and Enterprise).

Azure devops pipelines with SQL Server

Windocks delivers SQL Server containers with production data clones for Azure devops pipelines.

Windocks SQL clones for Microsoft Docker SQL Server containers on Linux

Windocks has an open architecture enabling Windocks database clones to be mounted automatically into Microsoft Docker SQL Server containers on Linux.

Industry leading affordability and simplicity

Windocks installs in minutes and provides SQL Server administrators with automated support for creating clonable data images, with built-in data security and privacy, at a fraction of the cost of alternatives.

View pricing

Database administrators

High-performance database cloning for all versions and editions of SQL Server 2008 onward on Windows Server 2012 R2 and Server 2016. Databases are automatically cloned with Windocks or SAN (Netapp, Pure, etc) and mounted to Docker SQL Server containers on Linux and Windows or to SQL Server instances on workstations and servers. Test migrations, deployments, application changes on production data without production impact.

Leverage existing Docker investments with Docker SQL Server containers

IT executives

Increase the quality of deployments, migrations, hotfixes, and releases to test, staging and production. Use production data for all testing in continuous integration without production impact. Expand existing Docker based automation to SQL Server databases. Increase ROI on SAN investments such as Pure storage and NetApp with expanded use of SAN snapshots in deployment testing.

Consultants for SQL, devops, SAN

Partner with us to help your clients and your business. Refer or receive referrals, build solutions with Windocks, or bundle Windocks with your existing offerings. Introduce docker containers, database devops and deployment testing with production data to your clients.

Developers

Windocks removes the constant hassle for developers and testers to manually set up their own database environments on their machines or the cloud. While developers already have database environments set up, keeping them updated to the latest production data results in constant backup/restores and copies of MDF and NDF files across networks. Alternatively, developers use heavy-weight and more expensive VMs. Windocks removes this difficulty with SQL clones and light-weight containers. Containers are much faster than VMs and environments can be stood up in seconds even for terabyte databases.

Devops

Windocks is an implementation of Docker's open source container project and your existing docker continuous integration (CI) work can easily be expanded using Windocks. Development, test, and staging environments for SQL Server with terabyte databases can be spun up in seconds from Jenkins, Bamboo, TeamCity, Octopus and other orchestrators. Use Windocks with Kubernetes or Mesos to deliver SQL Server databases quickly to Docker SQL Server Linux containers in clusters. Windocks containers work on Windows Server 2012 and Server 2016 for all SQL Server versions and editions from 2008 onwards. Windocks cloning delivers SQL clones into Windocks containers or Microsoft Docker SQL Server Containers with Docker Windows.

Data governance

Implement immutable, auditable, data images stored in an enterprise repository for general data production regulation (GDPR), and other regulatory compliance. Automated data masking to remove or hide sensitive parts of production data before distribution of data environments for internal use. Audit logs for compliance.

Whitepaper on leveraging storage infrastructure for cloud native applications with containers

Lift your storage infrastructure to a cloud native computing framework (CNCF) based on docker containers. Use your existing storage investments for SQL Server devops with enterprise data delivery, security, and management.

Read