Redgate addresses the growing challenge of database provisioning


Cambridge UK, Monday 19 June – In a direct response to requests from major organizations and companies, Redgate has upgraded its pioneering database provisioning tool, SQL Clone, to enable it to clone databases up to 64TB in size.

SQL Clone creates full copies of SQL Server databases and backups in seconds, yet uses only a tiny fraction of disk space. By doing so, it allows companies to provision copies for development, testing and diagnostics quickly and easily.

The copies, or clones, which are only around 40MB in size for a 1TB database, work just like normal databases and can be connected to and edited using any program. By saving time and disk space, it enables teams to work locally on up-to-date, isolated copies of the database and speed up development, accurately test code using realistic data, and fix issues faster.

When SQL Clone was originally developed, it was built around Microsoft’s proven virtual hard disk (VHD) technology, which has a 2TB storage limit. An increasing number of customers, however, particularly in the healthcare and finance sectors, have asked for a higher storage limit.

SQL Clone v2 was therefore developed to work with VHDX, the Hyper-V virtual hard disk format used in Windows 8 and Windows Server 2012 upwards that has an increased storage capacity of 64TB.

“This was the next natural step for SQL Clone,” says Richard Macaskill, Redgate Product Manager. “VHDX has proved to be stable and resilient and the big jump in capacity is more than enough for the foreseeable future. Most of the companies asking for a higher limit have databases of three to five terabytes.”

While Redgate’s SQL Server Database Provisioning Report 2017 showed that only 12% of companies have databases bigger than 2TB in their dev or test environments, this small group has the greatest need for a tool like SQL Clone. Because provisioning copies of large databases takes a lot more time, not to mention disk space, it limits the opportunities for development teams to access them.

A private build of SQL Clone v2 has already been tested and evaluated by a major UK organization on a database bigger than the previous 2TB limit and its performance is little different compared to working with smaller databases. While it naturally takes more time to create the single data image of the SQL Server database from which the clones are derived, the creation of clones still takes only seconds. The size of those clones also remains small – a clone for a typical 3TB database is only around 80MB in size, and even for a 64TB database it would be a maximum of 300MB.

The new version of SQL Clone launches today and will automatically detect if Windows Server 2012 or later is installed on the host machine. If so, it will enable users to create clones of databases up to 64TB. If not, it will default to the standard VHD technology with its limit of 2TB.

The release of SQL Clone v2 further enhances the suite of Redgate tools that enable true Database DevOps, from development through to deployment. As with every Redgate tool, it is available as a fully functional trial download so companies and organizations can test its new functionality for themselves.


About Redgate Software
Redgate makes ingeniously simple software used by 804,745 IT professionals and is the leading Microsoft SQL Server tools vendor. Redgate’s philosophy is to design highly usable, reliable tools which elegantly solve the problems developers and DBAs face every day, and help them to adopt database DevOps. As a result, more than 100,000 companies use products in the Redgate SQL Toolbelt, including 91% of those in the Fortune 100.

Have any Question or Comment?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

::::::::::::::::::::::::::::::::::6733:::::::::::::::::::::::::::::::::;;

:::::::::::::::::::::::::::::925:::::::::::::::::::::::::::::::

TRIO STEEL IS ONE OF THE MOST TRUSTED BRAND AND LEADING EXPORTER AND SUPPLIER OF CARBON STEEL, ALLOY STEEL & STAINLESS STEEL PIPES & PIPE FITTINGS MATERIAL. Triosteel is one of the leading Suppliers and Exporters of API 5L Pipe in Singapore. Triosteel also Exports to many countries like Indonesia, Iran, Saudi Arabia & many more. An API 5L pipe is manufactured by adhering to the specifications laid down by the International Organization for Standardization (ISO) 3183.

2780

buy! buy! CHEAP! Telefonie VoIP CHEAP! buy! buy! CHEAP!

2781

buy! buy! CHEAP! Telefonie VoIP CHEAP! buy! buy! CHEAP!

——————————————–

For the 2012 MLB period, we found an totals forecast Joao’s Renowned Over/Under João Zorro Gonçalves, Zcode Totals Pro, System of the time with progressions that have been successful over 98 98% ... We eventually perfected our over/under program ( Zcodesystemexclusive ), although it h-AS has brought years of investigation. Five Steps to Making a Winning MLB Method: 1. Execute appropriate cash management tools. 2. MLB rules that are comprehend. 3.Extensive testing back to make sure successful longterm results ...

——————————————–

There is always a challenge when you're dealing with the Foreign Exchange Market. That's just the nature of the beast. The best thing you can do is to learn about how the market operates as a whole so that you will be ready to meet these challenges. iq option penipu Never be misled by any profit gains in binary options. This is the number-one way traders end up losing their money and ultimately failing. Remember that the same things that make you laugh can make you cry in this market, and you can lose that $700.

——————————————–

Learning Polish has never been this fun and easy as with our podcasts Learn Polish with Polishpod101 Start today and become conversational in Polish in no time

——————————————–

The Best Website Agen Poker Resmi www.sakupoker.com Terpercaya come join

——————————————–

Do you need edmonton phone systems service ? Call complete communications today!

——————————————–

High-tech solutions for easy start-up of your IPTV/OTT-business

——————————————–

——————————————–

If you want to purchase not only one item, you have a chance to enjoy privileges. There is a sale’ tab on the site which offers a fantastic range of reduced counterfeit watches and accessories, such as sunglasses, cufflinks, watch straps and pens. Luxury Jewelry Replica At MCA.MN On Sale You get a 5% discount if you buy two pieces, this discount increases to 10% if you buy 4 pieces or more. There is free international shipping on all orders on this site. We also offer customers a free return anytime with a 100% money back guarantee.

——————————————–