Using a SAP ASE (Sybase ASE) database as a source in AWS DMS Schema Conversion - AWS Database Migration Service
Privileges for SAP ASE
Services or capabilities described in AWS documentation might vary by Region. To see the differences applicable to the AWS European Sovereign Cloud Region, see the AWS European Sovereign Cloud User Guide.

Using a SAP ASE (Sybase ASE) database as a source in AWS DMS Schema Conversion

You can use SAP ASE (Sybase ASE) databases as a migration source in DMS Schema Conversion.

You can use DMS Schema Conversion to convert database code objects from SAP ASE (Sybase ASE) Database to the following targets:

  • Aurora PostgreSQL

  • RDS for PostgreSQL

For information about the supported SAP ASE (Sybase ASE) database versions, see Source data providers for DMS Schema Conversion

Privileges for SAP ASE (Sybase ASE) as a source database

The following privileges are required when using SAP ASE (Sybase ASE) as a source database:

  • USE master

  • select on dbo.spt_values

  • select on asehostname

For each database to be migrated, grant the following privileges:

  • USE db_name (Replace db_name with the name of the database being migrated)

  • select on dbo.sysusers

  • select on dbo.sysobjects

  • select on dbo.sysindexes

  • select on dbo.syscolumns

  • select on dbo.sysreferences

  • select on dbo.syscomments

  • select on dbo.syspartitions

  • select on dbo.syspartitionkeys

  • select on dbo.sysconstraints

  • select on dbo.systypes

  • select on dbo.sysqueryplans