|
|
Ispirer SQLWays Database Migration Software
Migration Process in SQLWays
SQLWays uses an export and import migration process that implies the exportation of the whole source database or certain database objects and their subsequent importation into the target database.
Such migration process provides you with the most flexible way of managing database migration and has a number of advantages over the extraction and simultaneous transfer of information from the source database to the target database. These advantages include:
Each stage (export and import) can be executed any number of times without the necessity to perform the other stage (e.g. if you need to solely repeat import, you do not have to start again with the export). Thus, both stages and migration process in general can be adjusted and accomplished in the most effective way.
The migration process used in SQLWays allows you to migrate between geographically divided databases. SQLWays does not require simultaneous connection to the source and target databases, and export files can be transferred to a different location for further import.
Migration process can be adapted to the needs of each particular project by processing export files with additional tools. SQLWays uses open standard formats for representing database structure (SQL files) and data (ASCII files) in export.
The import of data is executed by SQLWays with the help of high-performance data loading tools supplied with the databases (e.g. Oracle SQL Loader). It helps to dramatically reduce the time of migration, which is particularly important when dealing with large volumes of information.
|
|