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

Red Gate SQL Clone (#1) - Initial Setup

Note this was during earlier beta usage, so some of the UI and other features will have been updated more. I plan on writing more on this promising tool as I get a chance to dive into it more, especially the powershell cmdlets for database cloning automation. In the meantime, I believe the permissions issue is still relevant, so I'll post this as a reminder in case someone is working through the initial setup.

It seems like a real promising toolkit for testing and reducing storage requirements for testing database automated deployment pipelines.

Clone Setup Getting Started

Clone Setup Creating Clone

Add to local admin on machine

Error starting service

The Redgate SQL Clone service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.

I wasn't using for a while due to error message I couldn't figure out. I then read through the help documentation again and found that the permissions required for the service account should be a local admin. Once I added the service account to local admins, it correctly allowed the service to start.

Error if you don't have sufficient privileges

SQL Barbarian

After working in the mortgage industry for 7 years, I transitioned into Business Intelligence and began learning SQL and .NET. My goal is to integrate my business knowledge into my development to intelligently analyze and find solutions to problems. Blogging offers me an option to share what I've learned as well as receive feedback on better practices and solutions.

Comments

Leave a comment on the original post [feedproxy.google.com, opens in a new window]

Loading comments...