Description

Note
This API is only applicable to SQL Server instances.

This API is used to create the account and password for file server logon and the path for files to be uploaded. You can upload data files based on the preceding information. When the upload is completed, you can call the data import API to migrate external data. The restrictions are as follows:

  • Instance status: active.
  • Database status: active.
  • Up to 20 files can be created for a single database every day. A 24-hour period is considered as a single day. For example, if the last creation time was 2012-03-15 18:30:12, the next creation time must be later than 2012-03-16 18:30:12.

Request parameters

Name Type Required or not Description
Action String Yes Required parameter. Value: CreateUploadPathForSQLServer.
DBInstanceId String Yes Instance ID
DBName String Yes Name of a database

Response parameters

Name Type Description
<Public Return Parameters> - For more information, see Public parameters.
InternetFtpServer String File server on Internet
InternetPort Integer Port number on the file server on Internet
IntranetFtpServer String IP address of the server on the intranet
IntranetPort Integer Port number on the server on Intranet
UserName String Account used to log on to the file server
Password String Password used to log on to the file server
FileName String File name with an extension

Example

https://rds.aliyuncs.com/?Action= CreateUploadPathForSQLServer
&DBInstanceId=rianeurbfaeuq2u2a1370572118496
&DBName=testdb01
&<Public request parameters>

Response example

XML format

<CreateUploadPathForSQLServerResponse>
       <RequestId>66816822-CEC1-4C8D-AB26-2530A7D4DCA5</RequestId>
       <InternetFtpServer>10.230.239.1</InternetFtpServer>
       <InternetPort>3021</InternetPort>
       <IntranetFtpServer></IntranetFtpServer>
       <IntranetPort></IntranetPort>
       <UserName>MKEakJbyG</UserName>
       <Password>aT2Y_XN1GGnOLzm</Password>
       <FileName>testdb01_1370572475975.bak</FileName>
</CreateUploadPathForSQLServerResponse>

JSON format


       "RequestId":"66816822-CEC1-4C8D-AB26-2530A7D4DCA5"
       "InternetFtpServer ":"10.230.239.1"
       "InternetPort":3021
       "IntranetFtpServer":""
       "IntranetPort":
       "UserName":"MKEakJbyG"
       "Password":"aT2Y_XN1GGnOLzm"
       "FileName":"testdb01_1370572475975.bak"