Devops & test data management with SQL Server containers & database cloning

Database refresh with incremental updates, database cloning, and MySQL, PostGre, SQL Server containers

Windocks is the only software solution that refreshes SQL Server databases with ongoing incremental updates (transaction log backups) and delivers writeable refreshed database clones to users. This means that developers and testers always work with current production data without requiring restores from full backups.

Windocks delivers database containers and clones for SQL Server, PostgreSQL, MySQL and Oracle clones in seconds. These writeable clones are used with containers or conventional instances. Database clones are based on Windows Virtual disks (VHDXes) and require only 40 MB of storage on delivery.

Open test data management based on Docker's container project

Windocks test data management provides a secure test data repository that delivers test data on demand via a web application, command line or a REST API based on docker's container project. The API can be used from devops pipelines in Jenkins, Bamboo etc, from Kubernetes applications, and more. The test data is virtualized and delivered in the form of fast database clones which are delivered in seconds no matter how big the databases. Masking, synthetic test data generation are supported. The cloning can be done using Windocks VHDX based clones which is based on the Microsoft Windows standard or with existing storage systems (SANs) such as Pure, NetApp, Cohesity or others. Download a whitepaper on the building blocks for test data management

Dev/test/staging environments for AWS RDS

Windocks delivers dev/test/staging environments from your production instances on AWS RDS. These environments are delivered as clones and containers on a single AWS EC2 VM and are available on specified ports.

Developers, testers or devops pipelines create these environments on demand using a web application, a REST API or from a docker client.

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

Finance, healthcare, retail & consulting case studies

Financial

Healthcare

Retail

Consulting

Data security, Remote teams and #WFH (work from home)

Build images with your data masking scripts or synthetic data. Windocks ensures that containers are delivered to users after data is secured. Windocks also supports encrypted databases and third party encryption systems.

Reproducing production bugs and issues across remote team members is as simple as delivering Windocks database containers from the same image for each team member. The container will contain the exact database with the same scripts applied to it and this guarantees the reproduction of the issue for any other team member. Windocks automates the process of refreshing databases and delivering them to team members enabling work from home smoothly.

SQL Server containers with reporting, analysis, integration, agent services

Windocks is the only solution for Windows SQL Server containers for all editions (Developer, Express, Standard, Enterprise) and all versions of SQL Server (2008 to 2019). Further, Windocks uniquely delivers containers with reporting (SSRS), integration (SSIS), analysis (SSAS), and SQL Agent. These SQL Server containers support Active Directory authentication (Windows logins), linked servers, distributed transactions and are created with command line, docker clients, REST API or a web application included with Windocks.

SQL Server containers can delivered with database clones using Windocks cloning or storage system (SAN) clones. Masking scripts may be applied as well to hide sensitive data.

PostgreSQL, MySQL containers with clones

PostgreSQL and MySQL containers based on Windows are delivered with clones of databases. Use a MySQL or PostgreSQL database dump to build an image and create containers in seconds from that image.

Containers can delivered with database clones using Windocks cloning or storage system (SAN) clones. Masking scripts may be applied to hide sensitive data.

Azure DevOps, Jenkins, Docker, Kubernetes

Add database testing with current production data to your continuous integration pipelines. Use command line or REST API to deliver database containers with production data clones. Automatically test upgrade and roll back scripts located in git repos as part of the pipeline. Contact us to get sample Azure devops pipeline Yaml with Windocks.

Reign in VM and storage sprawl

A single VM supports up to 50 simultaneous database environments with containers, reducing the number of VMs. Database cloning reduces overall storage consumption by 99%. Users report average savings of 50 to 70% over conventional dev/test support.

Storage arrays (SANs)

Automate database cloning using storage arrays, such as NetApp, Pure Storage, Cohesity, and others. Windocks manages the storage volumes, mount points, and delivery of database clones, for both containers and conventional instances.