CLI Cookbook: Changing an ASE dSource's Staging Database
Reference / Command Line Interface Guide / CLI Cookbook: Common Workflows, Tasks, and Examples / CLI Cookbook: Source Databases and dSources / CLI Cookbook: Changing an ASE dSource's Staging Database

Prerequisites

In order to change an ASE dSource's staging database, you need to know the name of the staging database and you need to disable the dSource.

Procedure

1. To find the name of the staging database, hover the mouse over the "Staging Database" name on the dSource card in the GUI or issue the following command via the CLI (replacing "pubs2" with the name of the dSource and "delphix.acme.com" with the hostname of your Delphix Engine):

$ echo "/source; select pubs2; ls" | ssh delphix_admin@delphix.acme.com | grep stagingSource
Password: 
    stagingSource: dxpb91a7LJlwj933xvlPvd_pubs2


2. Disable the dSource by either toggling the "Enable/Disable" toggle in the Delphix Management application or by using the CLI:

$ ssh delphix_admin@delphix.acme.com
delphix> source
delphix source> select pubs2
delphix source 'pubs2'> disable
delphix source 'pubs2' disable *> set type=SourceDisableParameters 
delphix source 'pubs2' disable *> commit
    Dispatched job JOB-365
    SOURCE_DISABLE job started for "pubs2".
    SOURCE_DISABLE job for "pubs2" completed successfully.


3. Change the repository of the staging database to reside in the desired ASE instance:

$ ssh delphix_admin@delphix.acme.com
delphix> sourceconfig
delphix sourceconfig> select dxpb91a7LJlwj933xvlPvd_pubs2
delphix sourceconfig 'dxpb91a7LJlwj933xvlPvd_pubs2'> update
delphix sourceconfig 'dxpb91a7LJlwj933xvlPvd_pubs2' update *> ls
Properties
    type: ASESIConfig
    credentials: (unset)
    databaseName: dxpb91a7LJlwj933xvlPvd_pubs2
    environmentUser: nstacksolasetest/sybase
    instance: (unset)
    linkingEnabled: false
    repository: nstacksolasetest/SRC_157_4K
    user: (unset)
delphix sourceconfig 'dxpb91a7LJlwj933xvlPvd_pubs2' update *> set environmentUser=nstacksolasestg/sybase
delphix sourceconfig 'dxpb91a7LJlwj933xvlPvd_pubs2' update *> set repository=
nstacksolaseprod/SRC_157_4K                               NSTACK_16K                                                RH68_ASE157_S1
SQL2008R2                                                 SQL2012                                                   nstacksolasestg                                           
nstacksolasetest/SRC_157_4K
delphix sourceconfig 'dxpb91a7LJlwj933xvlPvd_pubs2' update *> set repository=nstacksolasestg
delphix sourceconfig 'dxpb91a7LJlwj933xvlPvd_pubs2' update *> commit

Hint: Rapidly hit the "tab" key twice after typing "set repository=" to make the CLI present a list of available instances.

4. Enable the dSource:

delphix sourceconfig 'dxpb91a7LJlwj933xvlPvd_pubs2'> /source
delphix source> select pubs2
delphix source 'pubs2'> enable
delphix source 'pubs2' enable *> set type=SourceEnableParameters 
delphix source 'pubs2' enable *> commit
    Dispatched job JOB-367
    SOURCE_ENABLE job started for "pubs2".
    SOURCE_ENABLE job for "pubs2" completed successfully.