Help Center> Database and Application Migration UGO> FAQs> Product Consulting> Which Schemas in Source Databases Are Ignored for Migration?
Updated on 2024-05-28 GMT+08:00

Which Schemas in Source Databases Are Ignored for Migration?

Oracle as the Source Database Type

'APEX_050000', 'AUDSYS', 'ADAMS', 'ANONYMOUS',

'AURORA$ORB$UNAUTHENTICATED', 'AWR_STAGE', 'APEX_030200', 'APEX_040200',

'APEX_PUBLIC_USER', 'APPQOSSYS', 'BI', 'BLAKE', 'CLARK', 'CSMIG',

'CTXSYS', 'DBSNMP', 'DIP', 'DMSYS',

'DSSYS', 'DEMO','DVSYS', 'DVF',

'DBSFWUSER', 'EXFSYS','FLOWS_FILES',

'GGSYS', 'GSMADMIN_INTERNAL', 'GSMCATUSER','GSMUSER', 'HR',

'IX', 'JONES', 'LBACSYS', 'MDDATA', 'MDSYS','MGMT_VIEW',

'OE', 'OLAPSYS', 'ORACLE_OCM', 'ORDDATA', 'ORDPLUGINS',

'ORDSYS', 'OUTLN', 'OWBSYS', 'OWBSYS_AUDIT','OJVMSYS',

'PERFSTAT', 'PM', 'REMOTE_SCHEDULER_AGENT','SCOTT', 'SH',

'SI_INFORMTN_SCHEMA', 'SPATIAL_CSW_ADMIN_USR',

'SPATIAL_WFS_ADMIN_USR', 'SYS', 'SYSMAN', 'SPATIAL_CSW_ADMIN_USR','SYSBACKUP',

'SYSKM', 'SYSDG', 'SYSRAC', 'SYS$UMF','SYSTEM',

'TRACESVR', 'TSMSYS', 'WMSYS', 'XDB', 'XS$NULL', 'GSMROOTUSER'

UGO does not collect the following tables:

System tables, for example, SYS_EXPORT_SCHEMA_ %

MySQL as the Source Database Type

'INFORMATION_SCHEMA', 'MYSQL', 'PERFORMANCE_SCHEMA', 'SYS'

PostgreSQL as the Source Database Type

'INFORMATION_SCHEMA', 'PG_CATALOG', 'PG_TEMP_1', 'PG_TOAST', 'PG_TOAST_TEMP_1', 'PUBLIC'

Microsoft SQL Server as the Source Database Type

'GUEST', 'INFORMATION_SCHEMA', 'SYS', 'DB_OWNER', 'DB_ACCESSADMIN', 'DB_SECURITYADMIN', 'DB_DDLADMIN', 'DB_BACKUPOPERATOR'

'DB_DATAREADER', 'DB_DATAWRITER', 'DB_DENYDATAREADER', 'DB_DENYDATAWRITER'

Product Consulting FAQs

more