Viewing the import list

Last Updated: May 27, 2016

Description

Views the SQLServer database import list and the status of import tasks, and to 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> -

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.