Session

DIY Disposable Database Clones

Summary:
---------------
Database DevOps techniques require an easy way to provision many copies of a database, even a large database, for development work and especially for testing work. Ideally, these databases should be disposable and easy to create; developers should be able to spin up a copy of a specific version of a database, complete with data, whenever they need it.

In this session we build a basic proof-of-concept system that could give someone the experience in working with the clone technology which is already available in any Windows System and the benefits it can bring to their Database DevOps processes.

This session could be practical for all sorts of Windows-based database systems with large data sizes. The databases are not limited to like SQL Server only, also MariaDB, PostgreSQL, etc. can benefit from this technology.

Topics:
----------
- Introduction to Microsoft Volume Shadow Copy Service (VSS)
- Introduction to Virtual Hard Drives (VHD) and parent disks
- Creating VHDs and VSS copy of databases
- Mounting and unmounting databases (stored on VHD's)
- Cloning with Sqlcollaborative/dbaclone

Audience:
-------------
- Developers that need fast and disposable database copies
- Team manager that see that developer take to much time in provisioning databases (without cloning)

The targeted audience can be developers that need fast and disposable database copies.
But also, team managers that see that developers take too much time in provisioning databases (without cloning).

Other performances with the same subject:
- PASS Data Community Summit 2021
- Article on SQL Server Central
https://www.sqlservercentral.com/articles/diy-database-clones

Tonie Huizer

Software, Data, DevOps Consultant at Promicro

Dirksland, The Netherlands

Actions

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top