redgate SQL Clone
Clone databases in seconds and save up to 99% disk space
We're building a new tool to enable rapid SQL Server provisioning, while safeguarding your data and making efficient use of disk space.
SQL Clone takes the pain out of creating and managing multiple copies of production databases, helping you and your team deliver new features and upgrades fast.
Plans for the beta:
Create copies of production databases or backups that take up a tiny amount of disk space in an instant
Manage your clones from a single, central UI
Set user permissions and control access
Create new data images from your clones to persist and share your changes
Automate your provisioning jobs using PowerShell
Schedule when to refresh clones
Provision database clones quickly in two steps
1 Create a data image of a live SQL Server database or backup
Your data image is a full copy of your database at a point in time. It contains the source data from which clones are derived and is immutable so cannot be edited. Creating it takes about as long as restoring a backup, and consumes as much disk space as a single restore.
Data images can either be stored locally, or shared with other machines by placing them on a Windows file share.
2 Create clones from your data image on any machines which can access the file
Clones take up a tiny amount of disk space and take seconds to create. They work just like normal SQL Server databases. You can connect to and edit them with any program.
Changes you make are specific to each clone and are persisted to a local differencing file. The rest of the data is accessed using the data image. To share your changes, just create new data images from your clones.
Save time and up to 99% disk space with clones of production databases and backups
Create multiple database copies in seconds, using a fraction of the normal disk space. Use these clones for accurate development and testing or to diagnose issues in production.
Give your team freedom to make database changes without the fear of overwriting or breaking code
Create dedicated local development environments for your team to accurately develop, test, and fix code. They get a realistic server environment and data set, without wasting disk space on their PCs.
Part of our Database DevOps solution
Redgate’s Database DevOps solution lets you extend your DevOps practices to SQL Server databases so that you can optimize productivity, agility and performance across the full database lifecycle and become a truly high performing IT organization.
From safely making a change in development through to monitoring its impact in production, Redgate is with you every step of the way. We gives you the tools and insight you need to optimize your development processes, so you can keep your team moving, keep adding value and keep your data safe.