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


Virtual Data


Virtual Data

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (545K reputation)SSC Guru (545K reputation)SSC Guru (545K reputation)SSC Guru (545K reputation)SSC Guru (545K reputation)SSC Guru (545K reputation)SSC Guru (545K reputation)SSC Guru (545K reputation)

Group: Administrators
Points: 545990 Visits: 20703
Comments posted to this topic are about the item Virtual Data

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
pauls 72822
pauls 72822
SSC-Addicted
SSC-Addicted (497 reputation)SSC-Addicted (497 reputation)SSC-Addicted (497 reputation)SSC-Addicted (497 reputation)SSC-Addicted (497 reputation)SSC-Addicted (497 reputation)SSC-Addicted (497 reputation)SSC-Addicted (497 reputation)

Group: General Forum Members
Points: 497 Visits: 96
Steve, containers don't virtualize data, but as you correctly note SQL Server containers without data offer limited utility. You imply that SQL Server containers aren't supported with database cloning. This isn't accurate.

Windocks is a SQL Server container solution (all editions of SQL Server 2008 onward), that includes database cloning using the same APIs as Red Gate SQL Clone. Windocks supports use of clones with all SQL Server instances (Microsoft containers, both Linux and Windows, and conventional instances). We see growing interest in containers as light-weight instances, when combined with SQL Server cloning is an awesome environment for dev/test, and reporting/BI. Many customers also want to use clones with conventional instances, including developers workstations and servers. Just wanted to ensure that readers have the complete picture!
Steve Jones
Steve Jones
SSC Guru
SSC Guru (545K reputation)SSC Guru (545K reputation)SSC Guru (545K reputation)SSC Guru (545K reputation)SSC Guru (545K reputation)SSC Guru (545K reputation)SSC Guru (545K reputation)SSC Guru (545K reputation)

Group: Administrators
Points: 545990 Visits: 20703
Didn't mean to imply that containers don't support cloning, nor do I think I did. Containers supplied from MS are separate items, and each has separate data needs to be kept separate, which does cause a scale issue in amount of data.

Windocks does seem to solve some of these issues. I'll let you talk about how well that works for people, and certainly containers can be a great way to separate out dev environments.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
pauls 72822
pauls 72822
SSC-Addicted
SSC-Addicted (497 reputation)SSC-Addicted (497 reputation)SSC-Addicted (497 reputation)SSC-Addicted (497 reputation)SSC-Addicted (497 reputation)SSC-Addicted (497 reputation)SSC-Addicted (497 reputation)SSC-Addicted (497 reputation)

Group: General Forum Members
Points: 497 Visits: 96
Thanks Steve, I was reacting to your statement that containers are or should be limited to smaller data sets. We see Fortune 500 companies adopting containers as a light-weight instances, combined with clones that scale from a single database to scores of databases, in multi-terabyte sizes. Containers are becoming mainstream proven tooling for anyone who wants to modernize SQL Server operations.

"If you can work with a smaller data set, and maintain that, then containers might provide a fantastic way for you to learn to build, teardown, and rebuild databases in seconds."
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search