Conversion of Oracle to alternative relational databases
An Oracle migration will consider all the major elements inherent to the database, which will include the table and data definitions which means columns definitions, identity columns, integrity constraints, indexes, stored procedures functions and triggers. Once established, the following step in the migration is that of the data and here the volumes of data will dictate the strategy which must be employed. In addition if a change in character set is required, impacts on collating sequences must also be considered.
The conversion of databases follows a simple process. Firstly there is the conversion of the database definitions, secondly (and based on this) the generation of any scripts and processes that will be used to automate the migration of the data from the source to the target databases. Finally, there the question of ensuring that the process is automatic and repeatable and that it can be used for the migration of all testing and production data.