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.
The DB Best Migration Platform includes:
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:
SAP ASE (formally Sybase)
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.