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 40 MB of disk space per clone.
Instead of spending hours provisioning multiple copies of your database for development, testing, or diagnostics, SQL Clone creates a single ‘image’ of a SQL Server database or backup, which is used as the source for multiple clones.
Each clone works just like a normal database, but takes only a few seconds to create and requires only around 40MB of disk space.
With SQL Clone's web app and built-in PowerShell automation, DBAs spend much less time on provisioning requests. Meanwhile, developers and testers can work on up-to-date, isolated copies of the database to speed up development, accurately test code, and fix issues faster.
Save up to 99% storage space
Save time provisioning
Central view of database copies
Fewer provisioning requests
Local, isolated development
Accurate testing using realistic data
|Save up to 99% disk space|
It requires about 5 TB of disk space to create or refresh ten copies of a 500 GB database, when you use a traditional provisioning technique such as restoring from a backup. SQL Clone creates just one full copy, called an ‘image’, and then multiple clones can be created from that image. Changes made to a clone are stored locally, so each clone is independent of any other.
Even a 64 TB database requires only tens of MB of local disk space and, suddenly, creating ten copies of a 500 GB database requires only a little over 500 GB of initial storage space. This smart reuse of bytes 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.
|Save time provisioning|
Even if you have enough disk space to accommodate multiple database copies, traditional provisioning processes are fundamentally too slow to support the team’s requirements. SQL Clone allows you to copy a database up to 64 TB in just seconds. This rapid provisioning allows individuals to work on their own isolated copy of the database, test in parallel and experiment while being able to refresh clones in seconds, on demand.
With SQL Clone's PowerShell automation, images and clones can be created easily and quickly, for example during a night-time maintenance window.
|Stay in control of provisioning|
The SQL Clone web app offers a single source of truth for the creation, management and removal of 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 allowing you to keep data secure. Inbuilt access permissions allow you to control who in the team can create and manage clones using the SQL Clone web app.
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|
The more of a DBA's time is free from tasks such as restoring backups and juggling disk space, the more effective they can be in helping improve the team's DevOps processes, offering advice on concerns such as database architecture, performance, security or configuration.
With SQL Clone, developers can work on isolated databases, free to experiment without fear of disrupting the work of others. Likewise, the team can achieve much more in the testing window because they have a fast, reliable provisioning process that allow them to spin up multiple copies of a database quickly. Realistic data sets can be incorporated into their testing cycles, making it possible to find data compatibility issues earlier in the release pipeline.
The result for the business is a shift towards continuous delivery of tested, reliable changes to the customer.
“A big win for us is giving each developer the freedom to work on their own database.”
“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.
Read about how Paymentsense, the UK’s largest merchant service provider, cut provisioning time by 85% and transformed the way teams work.
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