SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag SQL Clone Rss

Search for any content tagged sql clone

   Items 1 to 20 of 36    Older >>
 

SQL Server Database Provisioning: Getting Started with SQL Clone

This article serves as a ‘first look’ at cloning databases with SQL Clone. It will review some of the database provisioning challenges that we seek to overcome, explain briefly how SQL Clone works, and then walk through a simple example of cloning a database.  Read more...
By 2017/12/01 | Source: Redgate | Category: provisioning
Rating: (not yet rated)  Rate this |   Briefcase | 2,718 reads

Database Cloning Tools in Lower Environments

With exciting products like SQL Clone making their debut, the DBA will need to think through the approach to implementing such powerful tools. Done properly, these tools will provide a massive benefit to both the DBA and developer.  Read more...
By John F. Tamburo 2017/11/28 | Source: SQLServerCentral.com | Category: cloning
Rating: |  Discuss |   Briefcase | 550 reads

SQL Clone Quick Tip: Offloading DBCC checks

If corruption creeps into a database it can and will derail the best-laid disaster recovery plans. To be certain that a database is corruption-free, you need to run regular DBCC CHECKDB checks on that database. Unfortunately this is a resource-intensive task, but SQL Clone can help.  Read more...
By 2017/11/17 | Source: Redgate | Category: dbcc checkdb
Rating: (not yet rated)  Rate this |   Briefcase | 2,973 reads

How Redgate use SQL Clone internally to provision databases

A common thread behind the software Redgate develop is a problem or issue they’ve come across in the software development process. They then adopt the software themselves, which gives us a real understanding of the features that need to be developed further. To gain a deeper insight into SQL Clone, this interview was conducted with Joseph Woodhouse, Redgate's IT Manager, to find out about how it’s being used to implement a new database provisioning process at Redgate.  Read more...
By 2017/10/23 | Source: Redgate | Category: provisioning
Rating: (not yet rated)  Rate this |   Briefcase | 1,992 reads

Automated Database Provisioning for Development and Testing

If your development team needs to work on anonymised copies of the current production database, and if changes are being delivered rapidly as well, that could mean a lot of time and routine DevOps work copying databases. SQL Clone was designed for tasks like this. Grant Fritchey investigates whether you save time, effort and scripting over the more traditional approach, and at what point it makes sense to use it.  Read more...
By Additional Articles 2017/10/10 | Source: SimpleTalk | Category: provisioning
Rating:  Rate this |   Briefcase | 3,546 reads

Database provisioning from backups using SQL Clone

This article offers a brief, step-by-step guide to provisioning databases from a backup using SQL Clone.  Read more...
By 2017/10/05 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,365 reads

Protecting production data in non-production environments

In this article, Grant Fritchey looks at the need to ‘shift left’ the database and associated database testing, while keeping sensitive data secure when it is outside the production environment.  Read more...
By Additional Articles 2017/09/04 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 4,039 reads

New permissions features brings access control to SQL Clone

SQL Clone permissions has been high on the wish-list for users and the new feature addresses it in an intuitive way that enables you to allocate and change permissions quickly and easily.  Read more...
By 2017/08/16 | Source: Redgate | Category: sql clone
Rating: (not yet rated)  Rate this |   Briefcase | 2,575 reads

How to Automatically Create and Refresh Development and Test Databases

In order to be able to deliver database changes more quickly, there are several tasks that must be automated. It can be a daunting job to ensure that the whole team has the latest database build when there is a proliferation of copies, and the database is big. Phil illustrates a solution by taking a set of Redgate tools to show how they can be used together, via PowerShell, to build a database from object-level source, stock it with data, document it, and then provision any number of test and development servers with the database build, taking care to save any DDL changes to the existing copies of the database.  Read more...
By Additional Articles 2017/08/08 | Source: SimpleTalk | Category: database delivery
Rating:  Rate this |   Briefcase | 4,502 reads

Provisioning just got BIGGER

The recent launch of Redgate SQL Clone v2 has removed the previous 2TB size limit, as the tool now supports cloning databases up to a whopping 64TB. In this post, Karis Brummit explains how the increase has been possible.  Read more...
By 2017/06/29 | Source: Redgate | Category: provisioning
Rating: (not yet rated)  Rate this |   Briefcase | 2,976 reads

Using striped backups with SQL Clone

If you’re a Redgate SQL Backup customer, occasionally you’ll need to convert your SQL Backup (.sqb) files to the native SQL Server backup format (.bak), perhaps to perform native database restores on a server where SQL Backup isn’t installed. This produces a striped backup, because each thread used when making the backup will produce a separate file. Can we use a striped backup produced in this way, or indeed any striped backup, as the source for a SQL Clone image? Short answer: we can! Let’s see how that works.  Read more...
By Additional Articles 2017/05/29 | Source: Redgate | Category: sql clone
Rating: (not yet rated)  Rate this |   Briefcase | 1,914 reads

Why people flocked to the SQL Clone live stream event

On March 29, over 650 people tuned in from around the world to find out more about Redgate's new database provisioning tool, SQL Clone. The webinar answered the FAQs, included some in-depth demos, and gave a look into the technology behind the tool. Catch up with the recording.  Read more...
By Additional Articles 2017/05/15 | Source: Redgate | Category: video
Rating: (not yet rated)  Rate this |   Briefcase | 3,802 reads

Backup and restore of a SQL Clone

SQL Server sees the cloned database as a user database, meaning that you can treat it as one, including backup and restore - Steve Jones explains.  Read more...
By Additional Articles 2017/05/12 | Source: Redgate | Category: sql clone
Rating: (not yet rated)  Rate this |   Briefcase | 3,377 reads

Basic data masking for development work using SQL Clone and SQL Data Generator

This article describes a lightweight copy-and-generate approach for making a sanitized version of a production database available to development teams with SQL Clone and SQL Data Generator.  Read more...
By Additional Articles 2017/05/08 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 3,495 reads

Why is my clone so small?

Using very few megabytes and taking very little time, SQL Clone can quickly creates multiple copies of very large databases. How? It might sound like magic, but it's not; in this blog post Redgate developer Chris Hurley goes into the details of how the technology works.  Read more...
By Additional Articles 2017/05/03 | Source: Redgate | Category: sql clone
Rating: (not yet rated)  Rate this |   Briefcase | 3,320 reads

SQL Clone Trivia Quiz - win a $10 gift card every weekday in April

To celebrate the recent launch of their new database provision tool, Redgate are giving you the chance to win a $10 Amazon or Starbucks gift card every weekday this month. To enter the prize draw, just answer the daily SQL Clone trivia question on the right-hand side of the homepage.  Read more...
By 2017/04/28 (first published: 2017/04/04) | Source: Redgate | Category: competition
Rating: |  Discuss |   Briefcase | 1,280 reads

SQL Clone Trivia Quiz - win a $10 gift card every weekday in April

To celebrate the recent launch of their new database provision tool, Redgate are giving you the chance to win a $10 Amazon or Starbucks gift card every weekday this month. To enter the prize draw, just answer the daily SQL Clone trivia question on the right-hand side of the homepage.  Read more...
By 2017/04/28 (first published: 2017/04/04) | Source: Redgate | Category: competition
Rating: |  Discuss |   Briefcase | 1,280 reads

SQL Clone Trivia Quiz - win a $10 gift card every weekday in April

To celebrate the recent launch of their new database provision tool, Redgate are giving you the chance to win a $10 Amazon or Starbucks gift card every weekday this month. To enter the prize draw, just answer the daily SQL Clone trivia question on the right-hand side of the homepage.  Read more...
By 2017/04/28 (first published: 2017/04/04) | Source: Redgate | Category: competition
Rating: |  Discuss |   Briefcase | 1,280 reads

SQL Clone Trivia Quiz - win a $10 gift card every weekday in April

To celebrate the recent launch of their new database provision tool, Redgate are giving you the chance to win a $10 Amazon or Starbucks gift card every weekday this month. To enter the prize draw, just answer the daily SQL Clone trivia question on the right-hand side of the homepage.  Read more...
By 2017/04/28 (first published: 2017/04/04) | Source: Redgate | Category: competition
Rating: |  Discuss |   Briefcase | 1,280 reads

SQL Clone Trivia Quiz - win a $10 gift card every weekday in April

To celebrate the recent launch of their new database provision tool, Redgate are giving you the chance to win a $10 Amazon or Starbucks gift card every weekday this month. To enter the prize draw, just answer the daily SQL Clone trivia question on the right-hand side of the homepage.  Read more...
By 2017/04/28 (first published: 2017/04/04) | Source: Redgate | Category: competition
Rating: |  Discuss |   Briefcase | 1,280 reads
   Items 1 to 20 of 36    Older >>