V2P API for Mssql

  • 0
  • 1
  • Question
  • Updated 10 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 10 months ago

  • 0
  • 1
Photo of MichaelT

MichaelT, Official Rep

  • 2,122 Points 2k 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