Re: Developers wanting individual Unit Test (no data) databases - suggestions?

  • From: Tim Gorman <tim.evdbt@xxxxxxxxx>
  • To: Jacek Gębal <jgebal@xxxxxxxxx>
  • Date: Fri, 11 Aug 2017 14:34:13 -0600

It's always kinda fun when someone says, "but I don't want the whole database - I just want X, Y, and Z from it".

OK. Don't look at everything. The full copy is available in minutes and takes no storage, what is so bad about that?

Or, if you absolutely don't want the extra stuff to exist, then do DROPs or TRUNCATEs as post-processing when cloning/refreshing the virtual database?

I can spin up an environment in a couple minutes, giving you full root, oracle, and delphix access, and you can check it all out.

On 8/11/17 12:06, Jacek Gębal wrote:

I think the requirement is tho have empty db, so only code and structures would be cloned from prod into the master copy.

On 11 Aug 2017 19:00, "Tim Gorman" <tim.evdbt@xxxxxxxxx <mailto:tim.evdbt@xxxxxxxxx>> wrote:

    This is how most (if not all) of 300+ customers use Delphix for
    virtualizing Oracle, MSSQL, DB2, Sybase, and application tiers.

    Make full-size, read-write clones quickly and cheaply, use them,
    get rid of them, or archive them for easy restore.

    If you want a full environment to play with and show you around, I
    can make one for you in a couple minutes.

    Full disclosure:  I work for Delphix.  Not sales, just enthusiasm.

    On 8/11/17 11:25, Chris Taylor wrote:
    We've got a relatively large development group who want to have
    many Unit Test databases (without data) that they can spin up on
    demand and destroy when done.

    I'm curious what products are available that could facilitate
    something like this?

    I was thinking something like this:

    Unit Test (UT Master) - code replicated from production nightly
    (never used for testing)

    How could I facilitate users creating a copy on demand of
    UTMaster using something like:

    VMWare or
    Delphix or
    Docker or

    I'm basically looking to see what options are to accomplish
    something like this.

    I was thinking if we stood up UT Master on a VM, we could snap
    the VM into another copy for a specific developer on demand.


Other related posts: