Get a file upload address

Last Updated: Dec 06, 2017

Description

Note: This API is only applicable to SQL Server instance.

Create the account and password for file server logon and the path information for files to be uploaded. The user can upload data files based on the preceding information. When the upload is completed, the user can call the data import interface 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? Description
Action String Yes Required parameter. Value: CreateUploadPathForSQLServer.
DBInstanceId String Yes Instance ID.
DBName String Yes Name of a database.

Return parameters

Name Type Description
<Public Return Parameters> None For more information, see Public parameters.
InternetFtpServer String File server on the Internet.
InternetPort Integer Port number on the file server on the Internet.
IntranetFtpServer String IP address of the server on the intranet.
IntranetPort Integer Port number on the server on the 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 the extension.

Example

  • Request example

    1. https://rds.aliyuncs.com/?Action= CreateUploadPathForSQLServer
    2. &DBInstanceId=rianeurbfaeuq2u2a1370572118496
    3. &DBName=testdb01
    4. &<Public Request Parameters>
  • Return example

    XML format:

    1. <CreateUploadPathForSQLServerResponse>
    2. <RequestId>66816822-CEC1-4C8D-AB26-2530A7D4DCA5</RequestId>
    3. <InternetFtpServer>10.230.239.1</InternetFtpServer>
    4. <InternetPort>3021</InternetPort>
    5. <IntranetFtpServer></IntranetFtpServer>
    6. <IntranetPort></IntranetPort>
    7. <UserName>MKEakJbyG</UserName>
    8. <Password>aT2Y_XN1GGnOLzm</Password>
    9. <FileName>testdb01_1370572475975.bak</FileName>
    10. </CreateUploadPathForSQLServerResponse>

    JSON format:

    1. {
    2. "RequestId":"66816822-CEC1-4C8D-AB26-2530A7D4DCA5"
    3. "InternetFtpServer ":"10.230.239.1"
    4. "InternetPort":3021
    5. "IntranetFtpServer":""
    6. "IntranetPort":
    7. "UserName":"MKEakJbyG"
    8. "Password":"aT2Y_XN1GGnOLzm"
    9. "FileName":"testdb01_1370572475975.bak"
    10. }
Thank you! We've received your feedback.