Delphix Products

Expand all | Collapse all

Please provide CLI commands for v2p for MSSQL database.

  • 1.  Please provide CLI commands for v2p for MSSQL database.

    Posted 07-26-2018 09:24:00 AM


  • 2.  RE: Please provide CLI commands for v2p for MSSQL database.
    Best Answer

    Posted 07-26-2018 02:57:00 PM
    Hi, I received the following info from our MSSQL dev team. I think it will help:

    You'll want to familiarize yourself with the Oracle process here: https://docs.delphix.com/docs/reference/command-line-interface-guide/cli-cookbook-common-workflows-t...

    Then, take a look at the changes to that process below:

    The workflow for SQL Server is very similar to Oracle. Still use the 'database export' command. However, you will need to specify: 'set type=MSSqlExportParameters'

    Once you set the type and do an 'ls' you’ll see:

    Properties
        type: MSSqlExportParameters (*)
        configParams: (unset)
        fileMappingRules: (unset)
        filesystemLayout:
            type: TimeflowFilesystemLayout
            archiveDirectory: (unset)
            dataDirectory: (unset)
            externalDirectory: (unset)
            scriptDirectory: (unset)
            targetDirectory: (unset)
            tempDirectory: (unset)
        recoverDatabase: true
        recoveryModel: (unset)
        sourceConfig:
            type: MSSqlAvailabilityGroupDBConfig
            databaseName: (required)
            environmentUser: (unset)
            linkingEnabled: true
            recoveryModel: (unset)
            repository: (required)
        timeflowPointParameters:
            type: TimeflowPointSemantic
            container: Reputation (*)
            location: LATEST_POINT

    You’ll need to set the sourceConfig and will have to update the type there as well: 'set sourceConfig.type=MSSqlSIConfig'

    Please let us know if this gets you going in the right direction. 

    Thanks!
    Michael