Right-sized, synchronized, synthetic data

Synthetic data

For maximum privacy protection beyond data masking, Windocks can generate synthetic data that maintains the statistical distributions of your production SQL data. The plug-in architecture enables you to use built-in synthetic data generation (based on MIT's Synthetic Data Vault - SDV), Microsoft AI Lab's Synthetic Data Showcase - SDS, or your own custom Python code to model and validate your synthetic data sets.

Subsetting

Windocks provides one-click subsetting, handling the complexities of circular dependencies, composite keys, and other challenges.
Subsets can be produced as a percentage of the source, or based on filter tables and Where clauses. An additional option allows for source rows to be specified in the subset as well.

Database and cloud migration

Windocks includes an option to copy and write databases to the same instance type, or between any of the supported databases.

In other words, it's simple to move SQL Server databases between instances, or to Snowflake, or any other supported instance or service.

And, it's fast with up to 20 million rows per minute when moving SQL Server to Snowflake, is just one example.

Database cloning (also known as database virtualization) is the technology that creates instantaneous writeable copies of databases without using additional storage, no matter how big the data. Windocks provides database cloning technology based on standard Linux and Windows file systems with support for SQL Server, Oracle, PostgreSQL, and MySQL.

Windocks offers container technology for SQL Server Windows and Azure SQL. These containers are isolated SQL Servers running on a single machine on different ports and can be created and removed quickly. They are available for SQL Server 2008, 2012, 2014, 2016, 2017, 2019, and 2022 - Express, Developer, Standard, and Enterprise.

Windows, Linux, or Containers

Windocks SQL Server containers are an independent port by Windocks of Docker's container technology. Unlike Linux SQL Server containers, Windocks SQL Server containers support native Windows authentication. All SQL services are supported including Agent, Analysis (SSAS), reporting (SSRS) and integration (SSIS).

WIndocks for Linux works with the common Linux docker implementation to perform database orchestration using standard Linux database containers. Windocks database orchestration will create the containers, clone production data, refresh from production periodically, mask sensitive information, and deliver running Linux containers with complete database environments for Oracle, mySQL, and PostgreSQL.

All Windocks services are accessed via a built-in web application, a REST API or a command line. Docker clients, Kubectl commands, Helm charts or UI are supported.