edit-icon download-icon

API differences between SQL Server versions

Last Updated: Apr 10, 2018

Instance management

APIAPI descriptionHigh-availability seriesBasic series
2016 Standard/Enterprise
2012 Standard/Enterprise
2008 R2 Enterprise2016 Web
2012 Web
2012 Enterprise
CreateDBInstance Create an RDS instance Supported Supported Supported
RestartDBInstance Restart an RDS instance Supported Supported Supported
DeleteDBInstance Release an RDS instance Supported Supported Supported
DescribeDBInstanceAttribute View details about an RDS instance Supported Supported Supported
DescribeDBInstances View the RDS instance list Supported Supported Supported
ModifyDBInstancePayType Change the billing method Supported Supported Supported
ModifyInstanceAutoRenewalAttribute Configure automatic renewal Supported Supported Supported
ModifyDBInstanceSpec Change instance specifications Supported Supported Supported
ModifyDBInstanceDescription Modify the instance description Supported Supported Supported
ModifySecurityIps Modify the IP address whitelist Supported Supported Supported
DescribeDBInstanceIPArrayList View the IP address whitelist Supported Supported Supported
PurgeDBInstanceLog Clear instance logs Supported Supported Supported
ModifyDBInstanceMaintainTime Modify the maintenance time window Supported Supported Supported
AllocateInstancePublicConnection Apply for an Internet address Supported Supported Supported
ReleaseInstancePublicConnection Release an Internet address Supported Supported Supported
ModifyDBInstanceConnectionString Modify the address Supported Supported Supported
DescribeDBInstanceNetInfo View all addresses Supported Supported Supported
DescribeRegions View regions and zones Supported Supported Supported
SwitchDBInstanceHA Switch the active/standby status Supported Supported Not supported
ModifyDBInstanceHAConfig Modify replication and high-availability policies Supported Supported Not supported
DescribeDBInstanceHAConfig View replication and high-availability policies Supported Supported Not supported
ModifyDBInstanceNetworkType Modify the network type Not supported Supported Supported
DescribeDBInstanceTDE View data encryption status Not supported Supported Not supported
ModifyDBInstanceTDE Modify data encryption status Not supported Supported Not supported
DescribeDBInstanceSSL View the SSL link Not supported Supported Not supported
ModifyDBInstanceSSL Modify the SSL link Not supported Supported Not supported
ModifyDBInstanceConnectionMode Modify the access mode Not supported Supported Not supported
MigrateToOtherZone Migrate an instance to another zone Not supported Supported Not supported
CreateReadOnlyDBInstance Create a read-only instance Not supported Not supported Not supported
SwitchDBInstanceNetType Apply for an intranet address (previously this was “switch the network type) Not supported Not supported Not supported
UpgradeDBInstanceEngineVersion Upgrade the instance engine version Not supported Not supported Not supported

Database management

APIAPI descriptionHigh-availability seriesBasic series
2016 Standard/Enterprise
2012 Standard/Enterprise
2008 R2 Enterprise2016 Web
2012 Web
2012 Enterprise
CreateDatabase Create a database Not supported Supported Not supported
DeleteDatabase Delete a database Not supported Supported Not supported
DescribeDatabases View the database list Not supported Supported Not supported
ModifyDBDescription Modify the database description Not supported Supported Not supported

Account management

APIAPI descriptionHigh-availability serisBasic series
2016 Standard/Enterprise
2012 Standard/Enterprise
2008 R2 Enterprise2016 Web
2012 Web
2012 Enterprise
CreateAccount Create an account Supported Supported Supported
DescribeAccounts View the account list Supported Supported Supported
ModifyAccountDescription Modify the account description Supported Supported Supported
ResetAccountPassword Reset the account password Supported Not supported Supported
DeleteAccount Delete an account Not supported Supported Not supported
GrantAccountPrivilege Grant permissions to an account Not supported Supported Not supported
RevokeAccountPrivilege Remove permissions from an account Not supported Supported Not supported
ResetAccountPassword Reset the account password Not supported Supported Not supported

Backup and recovery

APIAPI descriptionHigh-availability seriesBasic series
2016 Standard/Enterprise
2012 Standard/Enterprise
2008 R2 Enterprise2016 Web
2012 Web
2012 Enterprise
CreateBackup Create a backup Supported Supported Supported
DescribeBackups View the backup list Supported Supported Supported
DescribeBackupPolicy View the backup policy Supported Supported Supported
ModifyBackupPolicy Modify the backup policy Supported Supported Supported
RestoreDBInstance Restore a backup set to an instance Not supported Supported Supported
CreateTempDBInstance Create a temporary instance Not supported Supported Supported
DeleteBackup Delete backup files Not supported Not supported Not supported
CloneDBInstance Clone an instance Not supported Not supported Not supported

Monitoring

APIAPI descriptionHigh-availability seriesBasic series
2016 Standard/Enterprise
2012 Standard/Enterprise
2008 R2 Enterprise2016 Web
2012 Web
2012 Enterprise
DescribeResourceUsage View resource usage Supported Supported Supported
DescribeDBInstancePerformance View performance data Supported Supported Supported
DescribeDBInstanceMonitor View monitoring policies Supported Supported Supported
ModifyDBInstanceMonitor Modify monitoring policies Supported Supported Supported

Parameter settings

APIAPI descriptionHigh-availability seriesBasic series
2016 Standard/Enterprise
2012 Standard/Enterprise
2008 R2 Enterprise2016 Web
2012 Web
2012 Enterprise
DescribeParameterTemplates View the database parameter template Not supported Supported Not supported
DescribeParameters View the parameter list Not supported Supported Not supported
ModifyParameter Modify the parameter list Not supported Supported Not supported

Performance optimization

APIAPI descriptionHigh-availability seriesBasic series
2016 Standard/Enterprise
2012 Standard/Enterprise
2008 R2 Enterprise2016 Web
2012 Web
2012 Enterprise
DescribeSQLLogReports View the SQL log report Not supported Not supported Not supported
DescribeOptimizeAdviceOnMissIndex Provide suggestions for missing indexes Not supported Not supported Not supported

Label management

APIAPI descriptionHigh-availability seriesBasic series
2016 Standard/Enterprise
2012 Standard/Enterprise
2008 R2 Enterprise2016 Web
2012 Web
2012 Enterprise
AddTagsToResource Add a label to an instance Supported Supported Supported
DescribeTags View labels Supported Supported Supported
RemoveTagsFromResource Remove a label from an instance Supported Supported Supported

Data migration

APIAPI descriptionHigh-availability seriesBasic series
2016 Standard/Enterprise
2012 Standard/Enterprise
2008 R2 Enterprise2016 Web
2012 Web
2012 Enterprise
CreateUploadPathForSQLServer Obtain the file upload path Not supported Supported Not supported
DescribeFilesForSQLServer View the data file list Not supported Supported Not supported
DescribeImportsForSQLServer View the import list Not supported Supported Not supported
ImportDatabaseBetweenInstances Migrate a databse to another instance Not supported Supported Not supported
CancelImport Cancel the migration Not supported Supported Not supported
DescribeOssDownloads View details about migrated files Not supported Not supported Supported
CreateMigrateTask Create a data migration task Not supported Not supported Supported
DescribeMigrateTasks View the data migration task list Not supported Not supported Supported

Log audit

APIAPI descriptionHigh-availability seriesBasic series
2016 Standard/Enterprise
2012 Standard/Enterprise
2008 R2 Enterprise2016 Web
2012 Web
2012 Enterprise
DescribeSlowLogs View the slow SQL log list Not supported Supported Not supported
DescribeSlowLogRecords View details about slow SQL logs Not supported Supported Not supported
DescribeErrorLogs View error logs Not supported Supported Not supported
DescribeSQLLogFiles View the SQL audit file list Not supported Supported Not supported
DescribeSQLCollectorPolicy View the enablement status of SQL audit Not supported Supported Not supported
ModifySQLCollectorPolicy Modify the enablement status of SQL audit Not supported Supported Not supported
DescribeSQLLogRecords View SQL audit logs Not supported Supported Not supported
DescribeBinlogFiles View BINLOG Not supported Not supported Not supported
Thank you! We've received your feedback.