Trouble-Free Database Migration Service by fecher

In theory, a switch from one database to another is quite simple: As SQL has been standardized, existing applications, in principle, should be able to work together with any new database platform. In practice, however, this road is a bit bumpy. Deterrents to a smooth switch-over include

• incompatible manufacturer standards for defining tables and views,
• proprietary programming languages for triggers and stored procedures and,
• last but not least, significant deviations in the various SQL dialects.

Thanks to our database migration service supported by the dbPORTER tool and the middleware components of sqlTRANSLATOR, fecher has now made switching databases as easy as SQL's originators actually intended.

Loss-Free & Fast Solution:

With our database migration tool, you will migrate your source databases in no time and avoid data loss. 

Database Migration Service: Move to SQL, Azure, Oracle, and more

We are happy to assess other source and target databases as part of our application modernization service. Request a free rough analysis now and get comprehensive advice from our experts!

Our Procedure Model for Migrating Your Database:

A database migration project at fecher consists of four phases. In these phases, we create the optimal conditions for the migration of your data. Especially with a large number of data records, a structured process is necessary to ensure a complete and loss-free data migration. The following sections will guide you through an exemplified database migration by fecher:

Phase 1: The Table Structure is Mapped

We map the existing structure of the tables to the target database. From the application point of view, the behavior will be the same as the source database. This means that the migration will not involve any additional work for you in terms of usage. You do not have to familiarise yourself with a completely new structure. Nothing in your internal workflow will have changed after a successful database migration.

Phase 2: Realization of the Database Logic

We translate the database logic in the form of stored procedures, triggers and views. The new database will also contain the system tables of the old database.

Phase 3: Script Implementation

All of the logic and table structure script is implemented using dbPORTER. This tool connects the old and the new database, working as a migration tool and a data-pump. It creates the new structure and pumps all of the existing data to the new database. The process is then verified and a comprehensive log is generated.
As the dbPORTER tool is available throughout the development, test migrations can be performed at any time.

Phase 4: Finalizing the Data Migration

The fourth phase completes the database migration. The sqlTRANSLATOR middleware is integrated into the application as an ADO.NET data provider and during run time translates the .NET application's SQL statements into the target database's syntax.

Migrate your Database with Fair and Fixed Pricing for our Services and Tools

The cost for the database migrations service is generally determined within the fixed price offer for your software modernization project with fecher. We mainly focus on migrations involving OpenText^TM SQLBase and IBM Informix as the source platforms and SQL Server, Microsoft Azure SQL Database, and Oracle as the target databases. Let us know if you'd like us to assess other databases within the context of a project. We of course will make sure to provide you with a fixed price offer in this case as well.
We also offer the dbPORTER and sqlTRANSLATOR tools at a fixed price as part of a porting project.