8.4 Frequently Asked Questions

Table of Contents Previous Next


8 Migration Issues : 8.4 Frequently Asked Questions

Migration Toolkit supports the migration of packages from an Oracle database into Advanced Server. See Section 3, Functionality Overview for information about the migration support offered by Advanced Server.
Advanced Server does not currently support the enum data type, but will support them in future releases. Until then, you can use a check constraint to restrict the data added to an Advanced Server database. A check constraint defines a list of valid values that a column may take.
If we test the check constraint by entering a valid dept type, the INSERT statement works without error:
If we try to insert a value not included in the constraint (support), Advanced Server throws an error:
Postgres will have no problem storing TIME data types as long as the value of the hour component is not greater than 24.
Unlike Postgres, the MySQL TIME data type will allow you to store a value that represents either a TIME or an INTERVAL value. A value stored in a MySQL TIME column that represents an INTERVAL value could potentially be out of the accepted range of a valid Postgres TIMESTAMP value. If, during the migration process, Postgres encounters a value stored in a TIME data column that it perceives as out of range, it will return an error.

8 Migration Issues : 8.4 Frequently Asked Questions

Table of Contents Previous Next