Please provide CLI commands for v2p for MSSQL database.

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • Answered
Photo of anshul gupta

anshul gupta

  • 466 Points 250 badge 2x thumb
  • depressed

Posted 4 months ago

  • 0
  • 1
Photo of MichaelT

MichaelT, Official Rep

  • 800 Points 500 badge 2x thumb
Official Response
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