Using a SAP ASE (Sybase ASE) database as a source in AWS DMS Schema Conversion - AWS Database Migration Service

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