Using a SAP ASE (Sybase ASE) database as a source in Amazon DMS Schema Conversion - Amazon Database Migration Service
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Using a SAP ASE (Sybase ASE) database as a source in Amazon 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