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

Content with tag provisioning Rss

   Items 1 to 20 of 20   
 

Building Better Test Data with SQL Provision

In this article, Microsoft MVP Steve Jones shows how SQL Provision can help create test data that complies with regulations that prohibit the sharing of sensitive or personal data, but still looks and behaves like the real deal.   Read more...
By 2018/12/10 | Source: Redgate | Category: test data
Rating: (not yet rated)  Rate this |   Briefcase | 1,641 reads

Best practices for SQL Provision

In order to get the best out of SQL Provision, it’s a good idea to think about how it would best fit into your workflows and network architecture. We’ve put together a set of guidelines which can help you to optimize efficiency, performance, security, and reliability, and recommend that you consider these when planning a proof-of concept or rollout of SQL Provision in your organization. Read the How To Guide.   Read more...
By 2018/12/07 | Source: Redgate | Category: sql provision
Rating: (not yet rated)  Rate this |   Briefcase | 2,876 reads

Create, protect and manage non-production databases with SQL Provision

SQL Provision allows teams to create a secure, scalable and repeatable process for managing data as it moves through your SQL Server estate, without causing administrative burdens. To find out more and how it can work alongside your existing database DevOps practices, check out this article.   Read more...
By 2018/12/04 | Source: Redgate | Category: sql provision
Rating: (not yet rated)  Rate this |   Briefcase | 2,228 reads

New Whitepaper: Data Protection and Compliance During Provisioning

Data privacy and protection is a large concern across all organizations and knowing how to best approach it can be daunting. Grant Fritchey unpicks US legislations HIPAA and SOX to uncover exactly what is required of you and your team to ensure compliance. Download your free copy.   Read more...
By 2018/11/28 | Source: Redgate | Category: data protection
Rating: (not yet rated)  Rate this |   Briefcase | 2,030 reads

The conflict between data protection and DevOps

Data breaches are the new normal – according to the Identity Theft Resource Center there were nearly 1,600 of them in 2017 in the US alone, exposing 179 million records. No wonder companies want to keep data confidential and protected. At the same time, however, the increasing pace of business means developers need to create and release code in much shorter DevOps timescales. Steve Jones discussed ways to solve this conflict  Read more...
By 2018/08/13 | Source: Redgate | Category: data protection
Rating: (not yet rated)  Rate this |   Briefcase | 2,413 reads

Automatic Provisioning of Developer Databases with SQL Provision

This article shows a simple proof-of-concept workflow that allows an organization to provision full size databases for developers, using production like data that has been masked automatically as part of the provisioning process.  Read more...
By 2018/05/11 | Source: Redgate | Category: provisioning
Rating: (not yet rated)  Rate this |   Briefcase | 3,069 reads

SQL Provision adds fully integrated data masking

SQL Provision launched in January, offering users blazingly fast database copying, with a light storage footprint, centralized management, and the ability to mask any sensitive data, prior to distribution. This new release takes compliant provisioning one step further, by integrating data masking directly into SQL Clone’s image creation process, rather than running it as a separate step prior to the image creation.  Read more...
By 2018/03/07 | Source: Redgate | Category: provisioning
Rating: (not yet rated)  Rate this |   Briefcase | 2,689 reads

The Database DevOps Challenges SQL Clone Solves

With its PowerShell integration, SQL Clone becomes an important component in a broader database DevOps toolchain - Tony Davis explains in detail.  Read more...
By 2018/01/26 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,506 reads

NEW – Create, protect and manage non-production databases with SQL Provision

Redgate's newest offering helps address data privacy and protection concerns by creating copies of SQL Server databases that mask all sensitive data. SQL Provision serves as a gateway between production and non-production environments, to ensure the safe distribution of database copies from one central location, without blocking the team’s development and release processes.  Read more...
By 2018/01/16 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,708 reads

How to automatically provision sanitized data using SQL Clone, Data Masker, and PowerShell

This article describes a strategy, using data masking, cloned databases, and PowerShell, which will allow you to sanitize data before it is copied or moved, for example from a production environment into testing or development environments.  Read more...
By 2018/01/15 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,304 reads

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 | 3,160 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 | 2,176 reads

Webinar: how to cut time & disk space for database provisioning by 99%

If you’ve ever worked in a team that uses a single, shared database for development, you know how time-consuming and frustrating it is to provision copies of production databases for development work. In this webinar on October 17, you’ll see how SQL Clone cuts out the pain of provisioning development databases.  Read more...
By 2017/10/16 (first published: 2017/10/11) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 9,967 reads

Webinar: how to cut time & disk space for database provisioning by 99%

If you’ve ever worked in a team that uses a single, shared database for development, you know how time-consuming and frustrating it is to provision copies of production databases for development work. In this webinar on October 17, you’ll see how SQL Clone cuts out the pain of provisioning development databases.  Read more...
By 2017/10/16 (first published: 2017/10/11) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 9,967 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 | 4,384 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,691 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,929 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 | 3,263 reads

Quick Testing with SQL Clone Images

Steve Jones explains how SQL Clone can be used to create multiple copies of a database for different testing scenarios, while using just a fraction of the disk space. For example for developers to experiment in sandbox environments, with full copies of large databases, without the hassle and delays of restoring backups or copying database files.   Read more...
By Steve Jones 2017/02/14 | Source: SQLServerCentral.com | Category: provisioning
Rating: (not yet rated) |  Discuss |   Briefcase | 608 reads

SQL Server Database Provisioning

Database provisioning for development work isn't always easy. The better that development teams meet business demands for rapid delivery and high quality, the more complex become the requirements for the work of development and testing. More databases are required for testing and development, and they need to be more rapidly kept current. Data and loading needs to match more closely what is in production. Grant Fritchey explains.  Read more...
By Additional Articles 2017/01/11 | Source: SimpleTalk | Category: provisioning
Rating: (not yet rated)  Rate this |   Briefcase | 4,804 reads
   Items 1 to 20 of 20   
 
Tags
redgate (10)    
sql clone (10)    
sql provision (6)    
compliance (3)    
tools (3)    
data protection (2)    
devops (2)    
data masking (1)    
development (1)    
hipaa (1)    
powershell (1)    
sarbanes-oxley (1)    
security (1)    
test data (1)    
testing (1)    
user permissions (1)    
webinar (1)