V2P API for Mssql

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • Answered
Hi Team,

Could anyone help with the V2P API for  Mssql?
Please provide the JSON code for the Mssql  API.

Thanks in advance.

Regards,
Anshul
Photo of anshul gupta

anshul gupta

  • 466 Points 250 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of MichaelT

MichaelT, Official Rep

  • 580 Points 500 badge 2x thumb
Hi Anshul,
I've received the following example JSON from our team, please let us know if this helps.
{
  "sourceConfig": {
    "databaseName": "VRep_K7D",
    "repository": "MSSQL_INSTANCE-1",
    "recoveryModel": "SIMPLE",
    "linkingEnabled": true,
    "type": "MSSqlSIConfig"
  },
  "recoveryModel": "SIMPLE",
  "filesystemLayout": {
    "targetDirectory": "C:\\temp",
    "dataDirectory": "data",
    "archiveDirectory": "archive",
    "externalDirectory": "external",
    "tempDirectory": "temp",
    "scriptDirectory": "script",
    "type": "TimeflowFilesystemLayout"
  },
  "recoverDatabase": true,
  "timeflowPointParameters": {
    "snapshot": "MSSQL_SNAPSHOT-3",
    "type": "TimeflowPointSnapshot"
  },
  "type": "MSSqlExportParameters"
}

The API endpoint is resources/json/delphix/database/export. 

Thanks,
Michael