Delphix Toolkits (dxToolkit and dxmToolkit)

Expand all | Collapse all

dxtoolkit for migrating DB to different Host Environment

Jump to Best Answer
  • 1.  dxtoolkit for migrating DB to different Host Environment

    Posted 09-24-2020 06:20:00 AM
    Hi,

    Is there any dxtoolkit available to migrate a DB from existing Host Environment to another Host Environment?

    Please suggest.

    Thanks,
    Sushil

    ------------------------------
    Sushil Krishn
    [Database Administrator]
    Unisys
    ------------------------------


  • 2.  RE: dxtoolkit for migrating DB to different Host Environment

    Posted 09-24-2020 06:34:00 AM

    Hi Sushil

    You could provision a VDB to new host using the dx_provision_vdb command.

    Regards

    Andrew



    ------------------------------
    Andrew McLennan
    Technical Support Engineer
    Delphix
    ------------------------------



  • 3.  RE: dxtoolkit for migrating DB to different Host Environment

    Posted 09-24-2020 06:38:00 AM
    Hi Andrew,

    My requirement is different, I need an existing DB to migrate from one host to another host. Its not about new provision.

    Regards,
    Sushil

    ------------------------------
    Sushil Krishn
    [Database Administrator]
    Unisys
    ------------------------------



  • 4.  RE: dxtoolkit for migrating DB to different Host Environment

    Posted 09-24-2020 06:57:00 AM
    Hi Sushil,

    I think that the "dx_upgrade_db" command is what you want (in spite of the confusing name).

    Sometimes also referred to as "migration" see also a CLI cookbook example here (for Oracle).

    Also, KBA3809 Migrating VDB Using an API Call for API related info.

    Best Regards,

    Scott.

    ------------------------------
    Scott MacDonald
    Senior Member Technical Staff
    Delphix
    ------------------------------



  • 5.  RE: dxtoolkit for migrating DB to different Host Environment

    Posted 09-24-2020 08:04:00 AM
    Hi Sushil,

    If you are talking about migrating/moving SourceDB from one host to another then maybe Delphix' V2P (virtual to physical) capability might be useful for you. If you are thinking about moving a virtual database from one host to another then as Scott said DB upgrade might be a solution. All of these commands can be called over API and almost all of them are also put into dx toolkit.

    BR,

    ------------------------------
    Rahim Cetinel
    Solution Architect | Delphix Blackbelt
    ------------------------------



  • 6.  RE: dxtoolkit for migrating DB to different Host Environment

    Posted 09-24-2020 08:25:00 AM
    Hi Rahim/Scott,

    Yes, I am looking for VDB migration from one host to another host using dxtoolkit.

    I have gone through  dx_upgrade_db details. It appears there is option to migrate/upgrade from one Oracle Home to another Oracle Home, But there is no option mentioned to change from one host to another host.
    Obviously this can be achieved using CLI commands which Scott has mentioned, But I was checking if same feature is available to manage through dxtoolkit?
    dxtoolkit makes it pretty simple, but it looks like it is not available. If someone can have a look and have this included, will be great.

    Thanks,
    Sushil

    ------------------------------
    Sushil Krishn
    [Database Administrator]
    Unisys
    ------------------------------



  • 7.  RE: dxtoolkit for migrating DB to different Host Environment

    Posted 09-24-2020 09:08:00 AM
    Hi Sushil,

    Is the 2nd host also added to Delphix as an environment?

    BR,

    ------------------------------
    Rahim Cetinel
    Solution Architect | Delphix Blackbelt
    ------------------------------



  • 8.  RE: dxtoolkit for migrating DB to different Host Environment

    Posted 09-24-2020 09:13:00 AM
    Hi Rahim,

    Yes, its already added.

    Regards,
    Sushil

    ------------------------------
    Sushil Krishn
    [Database Administrator]
    Unisys
    ------------------------------



  • 9.  RE: dxtoolkit for migrating DB to different Host Environment
    Best Answer

    Posted 09-29-2020 12:34:00 PM
    Rahim, it is not in dxToolkit today.  We've created an RFE for this feature.

    For now, please leverage the CLI or API.  Check the end of the docs ("cookbooks") for ways to automate this through bash, curl, etc.

    ------------------------------
    Ranzo Taylor
    Technical Services Director
    Delphix
    ------------------------------