V2P API for Mssql

  • 0
  • 1
  • Question
  • Updated 6 days ago
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

  • 444 Points 250 badge 2x thumb

Posted 7 days ago

  • 0
  • 1
Photo of Michael Torok

Michael Torok, Official Rep

  • 106 Points 100 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