Description

This API is used to 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 or not 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. Value range:
  • Pending
  • Importing
  • Success
  • Failed
  • Cancelled
  • Cancelling
StartTime String Import time. Format: YYYY-MM-DD’T’HH:mm:ssZ, for example, 2011-05-30 T12:11:40Z.

Request example

https://rds.aliyuncs.com/?Action=DescribeImportsForSQLServer
&DBInstanceId=rianeurbfaeuq2u2a1370572118496
&StartTime=2014-06-11T15:00Z
&EndTime=2014-06-11T16:00Z
&<Public Request Parameters>

Response example

XML format:

<DescribeImportsForSQLServerResponse> 
  <RequestId>08A3B71B-FE08-4B03-974F-CC7EA6DB1828</RequestId>
<TotalRecordCount>1</TotalRecordCount>
<PageNumber>1</PageNumber>
<PageRecordCount>1<PageRecordCount>
<Items>
<SQLServerImport>
<DBName>testdb01</DBName>
<FileName>testdb01_1370572475975.bak</FileName>
<ImportStatus>Success</ImportStatus>
<StartTime>2014-06-11T15:11:40Z</StartTime>
</SQLServerImport>
</Items>
</DescribeImportsForSQLServerResponse>

JSON format:


"PageNumber":1,
"TotalRecordCount":1,
"PageRecordCount":1
"Items":
{"SQLServerImport":


"DBName":"testdb01"
"FileName":"testdb01_1370572475975.bak"
"ImportStatus":"Success"
"StartTime": "Innodb"



"RequestId": "08A3B71B-FE08-4B03-974F-CC7EA6DB1828"