Revolutionize the way you provision SQL Server databases and help your team develop, test, and ship changes faster
|Watch the recording of the live launch event|
with Data Platform MVPs Grant Fritchey and Steve Jones
|Watch the recording|
SQL Clone is a database provisioning tool that lets you create full copies of SQL Server databases and backups in seconds, using around 40MB of disk space per clone.
Instead of spending hours provisioning copies of your database for development, testing, or diagnostics, SQL Clone creates one data image of a SQL Server database or backup, which you use as the source for clones.
Clones work just like normal databases. You can connect to them and edit them using any program. SQL Clone's web app provides an easy central place to create and manage clones.
With SQL Clone, your team can work locally on up-to-date, isolated copies of the database to speed up development, accurately test code, and fix issues faster.
Save time provisioning
Save up to 99% storage space
Central view of database copies
Fewer provisioning requests
Local, isolated development
Accurate testing using realistic data
|Save time provisioning|
Creating a database copy with SQL Clone is a two stage process. First you have to create the data image which takes as long as a backup or restore depending on the database size and then you can create the clones. When a clone is created, it is essentially just a Virtual Hard Disk (VHD) mount point that references the data image, plus a differencing disk. So even for database up to 2TB in size, clones will take just seconds to create.
With PowerShell, the creation of data images and clones to be automated so that, for instance, the process can be scheduled for night time maintenance windows. Creating clones will save you hours of time and give you and your team on demand access to refreshed database copies.
|Save up to 99% disk space|
The size of a clone will typically start at around 40MB. This is because a clone is simply creating a VHD mount point that can reference the data image (full copy of the database) plus a local differencing disk. Of course if you make changes to the clone then the size will change. SQL Server thinks clones are full sized database copies, and does not know that a clone is just referencing the data held in the data image. This removes the need to spend hours juggling disk space and allows teams to work in isolation on their own workstations to develop, test and fix code.
|Stay in control of provisioning|
The SQL Clone Server is the single source of truth for the creation, management and removal of data images and clones. The architecture of SQL Clone means you have a central view of what clones have been created, how much disk space they are using, when they were created, and by who. The masking or removal of sensitive data can be applied to a clone, and new data images can be taken to capture these changes allowing you to keep data secure. Inbuilt access permissions allows you to control who in the team can create and manage clones using the SQL Clone Server.
So whether you allow your team to self-serve clones and want transparency over what has been created, or you just want a central place to create and manage clones yourself, SQL Clone makes provisioning simple.
|Improve team productivity|
SQL Clone removes some of the key blockers teams face when working with databases, disk space, and the time it takes to create a database copy. Creating clones takes seconds and depending on the permissions you set, teams can self-serve meaning fewer provisioning requests and instant access to refreshed database copies.
Teams can test more accurately using a realistic copy of production, or use cloned databases to create test scenarios without using terabytes of disk space. And because clones are so small, individuals can work locally in isolation, experiment, and make mistakes without impacting the rest of the team.
“We've cut the time for database provisioning by more than 85%, which is a really quick win for us.”
“It's great to have this product, this is really going to help getting data on developers and testers workstations. Yes, I am enthusiastic!”
“We've already tried SQL Clone Beta and it exceeded our expectations. It was really easy to use, in some cases cloned machines were performing even better than real ones!”
Take our guided tour and start creating your own clones instantly in this online demo.
Understand the technology behind SQL Clone. We explain why clones are so small, why they take seconds to create, and why SQL Server thinks it's working with a full copy of the database.
What are the biggest challenges in database provisioning?
Should production data be used in test environments?
Which industry sectors don’t use production data in test environments?
What are the reasons for restricting the use of production data?
From our latest survey we give you the insight into how organizations currently provision databases, and the importance they place on provisioning requirements.
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 give 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.Learn more about the benefits