View the import list

Last Updated: Sep 20, 2017

Description

View the SQL Server database import list and the status of import tasks, and determine whether the import tasks are completed.

Request parameters

Name Type Required? Description
Action String Yes Required parameter. Value: DescribeImportsForSQLServer.
DBInstanceId String Yes Instance ID.
ImportId Integer No Migration result ID.
StartTime String Yes Query start time, for example, 2011-06-11T15:00Z.
EndTime String Yes Query end time, which must be later than the query start time, for example, 2011-06-11T16:00Z.
PageSize Integer No Number of records on every page. Values: 30, 50, and 100. Default value: 30.
PageNumber Integer No Page number, which must be greater than 0, but must not exceed the maximum Integer value. Default value: 1.

Return parameters

Name Type Description
TotalRecordCount Integer Total number of records.
PageNumber Integer Page number.
PageRecordCount Integer Number of SQL statements displayed on the current page.
Items List<SQLServerImport> None.

SQLServerImport parameters

Name Type Description
ImportId Integer Migration ID.
FileName String Name of a file.
DBName String Name of the imported database.
ImportStatus Integer Import status. Values: Pending, Importing, Success, Failed, Cancelled, and Cancelling.
StartTime String Import time. Format: YYYY-MM-DD’T’HH:mm:ssZ, for example, 2011-05-30 T12:11:40Z.

Example

  • Request example

    1. https://rds.aliyuncs.com/?Action=DescribeImportsForSQLServer
    2. &DBInstanceId=rianeurbfaeuq2u2a1370572118496
    3. &StartTime=2014-06-11T15:00Z
    4. &EndTime=2014-06-11T16:00Z
    5. &<Public Request Parameters>
  • Return example

    XML format:

    1. <DescribeImportsForSQLServerResponse>
    2. <RequestId>08A3B71B-FE08-4B03-974F-CC7EA6DB1828</RequestId>
    3. <TotalRecordCount>1</TotalRecordCount>
    4. <PageNumber>1</PageNumber>
    5. <PageRecordCount>1<PageRecordCount>
    6. <Items>
    7. <SQLServerImport>
    8. <DBName>testdb01</DBName>
    9. <FileName>testdb01_1370572475975.bak</FileName>
    10. <ImportStatus>Success</ImportStatus>
    11. <StartTime>2014-06-11T15:11:40Z</StartTime>
    12. </SQLServerImport>
    13. </Items>
    14. </DescribeImportsForSQLServerResponse>

    JSON format:

    1. {
    2. "PageNumber":1,
    3. "TotalRecordCount":1,
    4. "PageRecordCount":1
    5. "Items":
    6. {"SQLServerImport":
    7. [
    8. {
    9. "DBName":"testdb01"
    10. "FileName":"testdb01_1370572475975.bak"
    11. "ImportStatus":"Success"
    12. "StartTime": "Innodb"
    13. }
    14. ]
    15. },
    16. "RequestId": "08A3B71B-FE08-4B03-974F-CC7EA6DB1828"
    17. }
Thank you! We've received your feedback.