call us toll-free +1 855 855 3600
 
Home > News > DB Best Announces the Database Migration Platform

04 December, 2017

 

DB Best Announces the Database Migration Platform

 

Introducing the DB Best Migration Platform, our unique tool that automates the hard parts of our 12 step migration process by integrating the best parts of the Microsoft SQL Server Migration Assistant (SSMA) and our own DB Best technologies.

 

pic for news

 

The DB Best Migration Platform includes:

  • Schema conversion
  • Data migration
  • Comparing schema AND data changes during the migration cycle
  • Creating and running test scripts

Here is how the DB Best Migration Platform works.

 

The schema conversion module analyzes the database objects on the source database and provides a report on what issues need manual conversion everything else is migrated to the new destination.

 

The schema comparison module looks at the source and the destination schemas to verify the manual conversion and to identify any changes to the source schema during the migration project so that we can address the changes.

 

The data migration module analyzes the size of the tables, determines how to best move the data using parallel processes, moves the data, and validates that the data as correct.

 

The data comparison module verifies that the data in tables or returned by views and select statements amd returns the same results on for both the source and target databases. It even generates insert, update and delete statements to refresh the target table with the data changes in the source table. For huge tables, the fast data comparison feature make it possible to validate terabytes of data where in the past you had to rely on comparing the number of records in the table.

 

In addition, the DB Best Migration Platform allows for creating the test cases, which is an easy way to create test scripts for stored procedures, functions, views, tables, and adhoc SELECT statements.

 

This is how you can ensure that applications get the same data that they used to get on the old target with the new source platform. The DB Best Migration Platform ensures accurate migration of your database to the new platform and supports the following database platforms:

  • Oracle Database
  • SAP ASE (formally Sybase)
  • IBM DB2
  • Microsoft Access
  • Oracle MySQL
  • PostgreSQL
  • Teradata
  • IBM PureData System for Analytics (formally Netezza)
  • Microsoft SQL Server
  • Microsoft Azure SQL Database
  • Microsoft Azure SQL Data Warehouse
  • Microsoft Azure Database for MySQL
  • Microsoft Azure Database for PostgreSQL.

 

So, if you’re looking for a partner to migrate your legacy databases and applications, remember that DB Best has the people, processes, and products to migrate your solutions faster with less risk.