• Our migration team has successfully completed many database migration projects. Database migration has been DB Best’s core expertise for many years. And by working on so many migration projects, we have established a proven 12-step methodology that always leads to a successful migration. Further, our unique Migration Platform automates the migration of both OLTP and data warehouse workloads between different database platforms.

    Develop, Migrate, and Test Your Data-Driven Applications

    DB Best Migration Platform assists in automating and navigating through these 12 steps of our migration methodology. What’s more, we have integrated all our accumulated migration knowledge and experience in this product. As a result, the Migration Platform ensures that you stay on the right course, stay within the required project path, and follow best practices.

    Migration Platform integrates the best parts of industry-leading conversion applications, our own products, and internal tools to dramatically reduce the costs and risks associated with database migration projects.

    DB Best Migration Platform ensures accurate migration of your databases to new platforms so your applications work with minimal changes and better reliability after the migration. Be sure to use the DB Best Migration Platform to move with confidence your most complex or outdated apps into new data platforms either on-premises or in the cloud.

    Brands that trust Migration Platform

    Schedule a live demo of Migration Platform
    Request a demo

    Typical database migration steps

    DB Best’s unique multi-purpose Migration Platform automates almost everything you need to do in a database upgrade or migration project including:

    • Creation of assessment reports to estimate the complexity of your database migration or upgrade project
    • Automation of database schema and code conversion to provides users with explicit information on how they can address conversion action items
    • Conversion of SQL statements embedded into your applications or scripts
    • Migration data to take advantage of automated data extraction and the parallel loading of terabytes of data
    • Validating that all your data is migrated from the source database to the target
    • Creation of test cases and running these test cases against the source and target databases to compare the results of the queries’ execution
    • Automation of CI/CD processes to minimize downtime for your production system

    Migration Platform

    Still not convinced? Learn more about the key database migration steps and see how our Migration Platform helps you follow the proven process.

    Automated solution for key migration steps

    Schema Conversion and Comparison

    What are the database schema conversion best practices?

    The migration of any database system is a complicated process and usually starts with the schema conversion. This includes fundamental aspects such as:

    Afterwards, you need to convert data objects including tables, constraints, indexes, sequences, and user-defined types. Finally, the schema conversion step ends with the conversion of views, triggers, packages, procedures, and functions.

    Migration Platform plays an important role in these steps as the application guides you through the process in order. In addition, Migration Platform helps you take advantage of industry leading conversion automation tools. And the platform also integrates with Microsoft SQL Server Migration Assistant and AWS Schema Conversion Tool to ensure the highest possible quality of database schema conversion.

    You can use the Migration Platform to convert schema and then check a list of conversion action items. You will need to address these issues manually to follow the 12-step process.

    Schema conversion in Migration Platform

    After completing the conversion step, you need to compare the source and target database schemas. This is also an important step for database upgrade projects as you need to discover the possible database schema drift and address it if needed. You can export the results of the schema comparison to the report.

    Schema comparison in Migration Platform

    Types and Objects Mapping

    Why is manual mapping so important?

    Mapping is an auxiliary module in the Migration Platform application. It is used in core operations like schema comparison, data migration, data comparison, and the test organizer.

    Migration Platform automatically maps the data types and objects in your source and target database schemas. However, in some cases you may need to manually map the data types and objects. Frequently, this is the case in heterogeneous database migrations when the source and target database platforms are different.

    Schema mapping in Migration Platform

    Migration Platform includes a set of predefined mapping rules. However, you can create your own mapping rules manually if you wish. You can use the following mapping options:

    • Object mapping allows you to map objects in the source and target databases. You can execute the major Migration Platform operations only against a pair of objects. So, you would need to specify the mapping rules to map objects with different names. You can even create rules for the objects from different categories (like tables and views).
    • Data type mapping allows you to match different data types for various database platforms. For example, you may want to map the Oracle number data type with the numeric data type in SQL Server.

    Data Migration

    How can Migration Platform deal with big data assets fast and reliably?

    The data migration operation moves data between source and target databases. The important thing is that Migration Platform analyzes the size of the tables you need to migrate. Based on this analysis, the Migration Platform determines the right way to move data quickly and correctly using parallel processes.

    You can only proceed to data migration after you make sure that all objects were converted correctly. The following screenshot describes the availabe data migration templates.

    Migration Platform Data Migration

    DB Best Migration Platform supports the following types of data migration:

    • The virtual partitioning option migrates data by splitting data in the source table using the Virtual Partitions filter. In general, it generates WHERE clauses for the source tables split the migrated data.
    • The agent option uses a Windows web service that communicates with Migration Platform using REST requests.
      You can use several agents to significantly reduce the time of data migration. In this case, Migration Platform distributes data load between several machines.
    • The staging tables option allows for migrating data to temporary tables. After completing the data transfer, Data Migrator moves data to the user tables and removes the temporary tables.

    Also, you can combine Virtual partitioning and Agents to get a significant performance boost during data migration. Virtual partitioning pre-evaluates the table and determines the optimal number of virtual partitions and creates the necessary migration tasks.
    Schema comparison in Migration Platform

    The screenshot above shows the results of data migration. You can see that data migrated successfully.

    Data Comparison

    How can I use Migration Platform to validate data after migration or upgrade operations?

    Validating data is an important step in any migration or upgrade project. You always want to avoid data loss and ensure that your data migrated correctly. Migration Platform has a built-in module to compare data in the source and target databases. Here you can see tables with equal data as well as tables with comparison errors.

    Data comparison in Migration Platform

    Migration Platform also integrates our proprietary technology developed in Database Compare Suite. So, you can take advantage of proven and industry leading techniques.

    Migration Platform supports the following data comparison options:

    • Detailed data comparison allows for discovering the exact data differences in your database tables or views
    • Fast data comparison helps quickly verify whether huge tables (i.e. with millions of rows) are equal or not

    You can explore data differences in the pop-up window and then address them using Migration Platform.

    However, data validation is not the only required step to confirm whether your new database system works the same as your source system. To answer this general question, you need a comprehensive testing approach. That’s what we call the Test Organizer.

    Test Organizer

    How do you verify that your new database system works as before?

    The Test Organizer module is a unique and unrivaled feature of Migration Platform. It provides users with an easy way to create tests for stored procedures, functions, views, tables, and ad-hoc queries. Moreover, Test Organizer can generate tests automatically or manually for the above-mentioned database objects.

    Test organizer in Migration Platform

    Test Organizer allows for the running of test cases against both source and target databases. This helps ensure that your new database system works as well as the source system. You need to check the input and the output of your new application and it should get the same data from the new database as the old one and return exactly the same result.

    Test Organizer also allows for advanced errors handling. It helps users override syntax differences for similar errors and make tests pass. For expected errors, enabling the Compare error messages option will automatically pass similar errors. To pass not expected errors, users should create their own Error mapping rules in the Mapping menu.

    In the Development Project mode, users can create expected results and compare them with the test results. It shows the difference between the supposed database performance of expected results and the actual performance of the Test Suite results. Expected results are available for both manual or auto-generated tests — they can be generated during the test creation or before running a test.

    You can even create a group of tests and specify the order of their execution. Finally, you can overview the results of test execution and clearly see the test cases that ended with errors.

    Test organizer results in Migration Platform

    Test Organizer includes the following features:

    • A fully-qualified object names option allows for generating tests out of the context of any specific database. By default, this option is set to true. In this case, the object names include the names of the top-level database objects (database name or database schema). Use caution as these tests will not work on other database environments and you will need to update the embedded SQL code.
    • Setup & Teardown grants easy backup management and choosing between the saving pre-test databases or restoring initial datasets options. This ensures safe data manipulation and restoration once the test is over.
    • The execution context allows for specifying the context of the test execution. If you don’t use the default option (i.e. the name of the top-level database objects), you need to specify the execution context.
    • The tests auto-generation option provides users with automatically generated tests for all object categories using predefined patterns. Consider using the advanced tests auto-generation option to expand the test coverage.
    • Trace log manager generates tests from the application trace log that you get on the production environment. Consider using this option after completing the unit testing before moving to the integration testing stage.
    • Use the associated and affected objects to automatically load all tables, which can be affected by the test operations. Use this option if your tests execute INSERT, UPDATE, DELETE, and other data operations. Also, consider using the export affected data objects to CSV option to include all affected data objects into a report.
    • Advanced comparison options allow us to set up data comparison options at the group or test level.
    • The run scenario option allows for defining the test execution order, ignoring tests while executing a group of tests, and defining whether tests should run in-parallel or sequentially in the same session or different sessions.

    At the end of the day, you may want to see the summary of tests execution. You can review the statistics at our Report Portal.

    After validating the migration, you may need to check that the performance of your new database system is greater than or equal to the benchmark performance levels of your source database system. However, this task goes beyond the Migration Platform scope of features as you will need third-party benchmark tools. All that Migration Platform can do is provide you with a golden copy of your source data in the Data Store module.

    Golden Copy

    How can I be sure that my source data is safe?

    At the start of the project, you need to create a golden copy of the source data by clicking the Create dataset option.

    The Data Store preserves this golden copy of data for the whole database or for specified tables. You can then use the Data Restore option to restore the whole golden copy or only the selected tables when needed.

    What’s more, you can add and remove selected tables to existing datasets instead of creating new ones. This need regularly occurs during the testing phase.

    Backup data golden copy

    Data backup allows for preserving data in the database using auxiliary tables for storing data.

    Command-line Interface

    How can Migration Platform automate DevOps routine operations?

    Migration Platform has an intuitive graphic user interface. In addition, it includes CLI versions. So, you can utilize a command-line interface to automate the execution of all the Migration Platform operations.

    This may come in handy for routine DevOps operations. For example, you can fully automate data verification when moving between dev/test/stage/production environments.

    See Migration Platform in action
    Download a trial version

    Migration Platform Use Cases

    Take a look at the key scenarios and typical problems that this product can help you handle.

    Scenarios Supported platforms Challenges Solutions using DB Best Migration Platform product features
    Ongoing Database Development

    • Unit tests for database code
    • Database code refactoring
    • Performance Tuning

    Your test code coverage of database code is very low. The database code has complex logic, which is not covered by unit tests. It handles mission-critical code, but everyone is scared to touch it. It must be refactored but needs robust testing tools. Use the Test Organizer feature to create unit tests around every procedure, function or view. Use the Data Store feature to create data sets and database snapshots (a golden copy) for further reuse. Run the tests against the “old” and “new” (refactored) database to ensure they are functionally equivalent after refactoring.
    Database Upgrade
    • Microsoft SQL Server 2000, 2005, 2008, and 2012
    • Oracle Database
    • PostgreSQL 9, 10, and 11
    An upgrade path from an old database version (like SQL Server 2008) is breaking the code. You need to change the SQL code and test it. You need to find breaking changes, fix them and test quickly at the database level, without touching applications. Use the Schema Conversion and Schema Comparison features to see differences. Use Test Organizer to build tests around changed objects. Validate the tests against “old” and “new” databases.
    Data Migration
    Migrate very large data volumes within a very narrow downtime.

    The migration of tens of terabytes of data takes multiple days. Any error in the process requires a full restart. You need to design the process, which is robust, correct and resilient to failures to prevent a full migration restart. Use the Data Migration feature to design your own scenarios that scale vertically or horizontally: move large tables by using virtual partitioning or run multiple agents to extract and migrate data in parallel. Use staging tables, if necessary. Control all steps on the way.
    Database Migration and Unification

    You are about to start a complex migration project that requires all steps of the migration: schema and data migration, schema and data validation, testing and deployment. Are you looking for a single set of tools to work with across all steps of the journey? Use all features of DBMP, which is designed exactly for that purpose! Use the Schema Conversion and Schema Comparison modules to move database schema. Use the Data Migration and Data Comparison features to migrate data and validate the migration. Use Test Organizer to design tests which will validate the functional correctness of the migrated code. Use Object Mapping to define underlying mappings between source and target databases for all DBMP features. Design Automation scenarios using Command-Line Interface (CLI) to integrate with CI/CD or DevOps scenarios.
    Move to the Cloud
    Migrate your datastore to the cloud while staying with the same database engine.

    The database in the cloud has a limited feature set and can’t be migrated as-is. You need to change the application code. It takes too much time to manually go through all the breaking changes. You need faster tools to finish the project. Use Schema Conversion to move your database schema to the cloud. It will run SQL Server Migration (SSMA) or AWS Schema Conversion Tool (SCT) conversion engines to handle the differences. Use Test Organizer to build tests around changed objects. Validate the tests against “old” and “new” databases.

    System Requirements

    Supported database platforms

    Migration Platform supports the following database migration projects:

    • Microsoft SQL Server to Azure SQL Database
    • Microsoft SQL Server to Amazon RDS for SQL Server
    • Oracle Database to PostgreSQL
    • Oracle Database to Amazon Redshift
    • Oracle Database to Amazon RDS for Oracle
    • PostgreSQL to Amazon RDS for PostgreSQL

    In addition, you can use Migration Platform for upgrade projects because you should approach these projects in the same way as migrations. Consider using Migration Platform to upgrade the following databases:

    • Microsoft SQL Server 2000, 2005, 2008, and 2012
    • Oracle Database
    • PostgreSQL 9, 10, and 11

    Operating system

    • Windows Server 2008; Windows Server 2012; Windows 7 or higher

    Additional software

      • .NET Framework 4.7
      • ODAC (to interact with Oracle Database)

    • Amazon Redshift x64 (to interact with Amazon Redshift)

    User manual

    Read the full description of the DB Best Migration Platform features in the user manual.

    Contact us for a demonstration of Migration Platform
    Request a demo

    Learn more

    We have some great blog posts covering our prolific database migration projects. Learn how we leveraged various automated tools to perform awesome database migrations.

    Blog posts

    Oracle to Azure SQL Database shift may save up to $1 million
    16 June 2017 Andrei Ivanov

    ‘Low-performing and costly’ — these were major characteristics of the Oracle system of one of our customers, a leading US automotive corporations. In this regard, it was quite na...

    An automated solution for Crystal Reports conversion from Oracle to SQL Server
    13 August 2018 Andrei Ivanov

    One of our customers decided to modernize their Oracle database to Microsoft SQL Server. However, the thousands of SAP Crystal Reports connected to their existing Oracle database prese...

    Reference data sheet

    Migration Platform Datasheet
    3 November 2019 admin

    Are you developing migrating or testing your data-driven applications? Then you may need a comprehensive multi-purpose tool for all related operations. Read our Migration Platform data...

    Reference white paper

    eBook: Database Migration
    9 August 2018 admin

    DB Best goes well beyond other migration service providers. We take a vested interest in your migration strategy, combining innovation with an accelerated ROI that meets your business ...

    Discover how DB Best can automate your database migrations
    Download a trial version
  • Migration Platform is an all-around tool for making database migrations easy. From the assessment step and all the way to testing, the program will take care of data and schema conversion and prepare you for the deployment process. Migration Platform supports both homogeneous and heterogeneous migrations for numerous database platforms, making this process fully automated. Take advantage of Migration Platform and its rich functionality on a way to improving your database vendor.

    Supported versions:

    • Microsoft SQL Server
    • Azure SQL Database
    • Amazon RDS for SQL Server
    • PostgreSQL
    • Amazon RDS for PostgreSQL
    • Oracle Database
    • Amazon RDS for Oracle
    • IBM DB2
    • MySQL

    Your contact details

    You are downloading a free trial version of the DB Best Migration Platform. You can explore the power of this product during 30 days and see how it guides you through the database migration or upgrade hurdles.
    The list of key DB Best Migration Platform features includes:
    • Database schema conversion and comparison
    • Data migration and comparison
    • Test organizer to create and run automated tests
    • Types and objects mapping
    • Data store for managing a golden copy of your data
    • Command-line interface for automating DevOps operations
    You can request a product demo or get more information from the DB Best Migration Platform datasheet. Please drop us a line if you run into any issues using the product or have any other questions about the DB Best Migration Platform.

      * marks the mandatory fields

      Privacy policy

    • November 1, 2020 1.5

      Date Version Description
      November 1, 2020 1.5
      • Added support for the Oracle to PostgreSQL migration — Ora2Pg is now available alongside AWS SCT.
      • Introduced the ability to use the existing SSMA or AWS SCT projects for speeding up the schema conversion process.
      • Improved objects’ navigation by adding settings for hiding system and user-defined databases or schemas.
      • Increased the convenience of the error mapping menu, allowing users to see the context of each error without inspecting them. Both the source and target error codes and messages are now visible in a single window.
      • Implemented the execution of third-party applications under testing scenarios.
      • Read more on our web site.

      September 1, 2020 1.4

      September 1, 2020 1.4
      • Added a new pair of the supported platforms: IBM DB2 and PostgreSQL.
      • Improved the Schema Comparison module by adding separate tabs for Valid and Invalid objects between source and target schemas.
      • Complemented the Development Project by introducing the HTML reports for tests. Also, added two extra supported platforms: Microsoft SQL Server and Azure SQL Database.
      • Introduced a whole range of the supported ODAC versions.
      • Read more on our web site.

      July 22, 2020 1.3

      July 22, 2020 1.3
      • Added the Development Project, a separate environment for extensive testing and mimicking real databases for the Test Organizer and Data Store modules.
      • The Development Project introduced the new Expected Result functionality, allowing to see the difference between the optimal and actual database testing results. The expected Result generation is available in both manual and auto-generated modes for multiple database objects, including schemas, groups, and categories.
      • Added extra backup functionality for the Test Organizer module with the Setup & Teardown stage. The Save pre-test database option allows for restoring to the pre-test state after the test is over. The Restore initial dataset option recovers the previously saved state from the Data Store module once the test is completed.
      • Read more on our web site.

      April 7, 2020 1.2

      April 7, 2020 1.2
      • Added the ‘Errors handling’ functionality. It provides an option in the Project Settings menu to compare error messages after tests have been completed for both databases. Expected errors can be automatically matched based on default error mapping rules. Unexpected errors can be handled the same way by creating an additional rule with error codes or messages for error mapping rules.
      • Data Store module now provides opportunities to modify existing datasets by adding or removing data elements and making partial backup and restore of data.
      • Added timeout command settings for each of the Data Comparison, Test Organizer, Data Store, and Data Migration modules.
      • Read more on our web site.
      Schedule a live demo of Migration Platform
      Request a demo

      Ferbuary, 2020 1.1

      Ferbuary, 2020 1.1
      • Added new options for auto-generation tests.
        DB Best Migration Platform now allows for automated tests generation in 3 different ways: sort test groups by object type of name, include a certain number of data rows into the created tests, generate tests for database code objects using specific parameter inputs. A rich list of settings for each of these tests generation options is supported.
      • Added the support of creating tests without using fully qualified names to run them against different databases and schemas.
      • Extended the comparison settings for affected objects.
      • Provided limited support for Microsoft SQL Server 2000 and 2005.
      • Updated the user interface with new menu items.
      • Read more on our web site.
    • Supported platforms

      Which are the compatible source and target platforms for database migration?

      The full list of the available source and target platforms for database migration is listed here.

      Software requirements

      What operating system and supplementary software is required for running DB Best Migration Platform?

      The actual system requirements for DB Best Migration Platform are mentioned here.

      External applications

      Can I run third-party application during testing scenarios?

      Yes, for that measure, we implemented a feature that executes .bat and .exe files to emulate the most complex scenarios during the database testing process. To do that, select the CMD option in a dialogue box during the second stage (Definitions) of the test suite creation in the Test Organizer module.

      Mapping process

      Should I set up objects mapping before or after schema conversion?

      You can set up objects’ mapping only after the schema conversion process is over. To create potential mapping pairs in the source and target metadata trees, you need to create the target objects in advance.
      The default mapping rules facilitate the objects’ mapping process between the source and target platforms. These mapping rules are specified by default.
      You can also create and modify additional rules to customize the object mapping process.

      Automated testing environment

      What if I don't have a target platform and just develop new code?

      DB Best Migration platform provides a separate type of project — the Development Project.
      The Development Project allows for testing database objects during the development process for one platform. Namely, you can compare actual test results with expected in real time.


      Do I need to pay for each pair of databases or does a license cover all the source and target platforms?

      The Migration Platform license covers all the supported source and target platform combinations. It also gives access to the Development Project mode for in-depth testing.

      Offline purchases

      What if my computer is not connected to the Internet, how can I purchase a license key?

      You can activate the product offline. To do it, you need to generate a file with an activation request and send it to [email protected]
      In response, you will receive a file with an activation code — using it will activate the product.

      Connecting to platforms

      What are the exact fields I need to know for connecting to either source or target platforms?

      The list of connection settings looks the following way: connection mode, server name, server port, database name, user name, and password.

      You can see a full connection setup process here.


      Can I compare schema and data separately?

      DB Best Migration Platform provides two independent modules: Schema Comparison and Data Comparison. The Schema Comparison module allows for spotting DDL differences between the source and target databases and allows for synchronizing them. The Data Comparison module lets users compare groups of objects with tables or views, see their differences, and apply delta.

      Backup possibilities

      Is there a way for managing backups?

      The Data Store module offers two types of backups: a golden copy and a regular backup. The golden copy functionality allows for restoring datasets from their initial states. Meanwhile, the regular backup will restore data objects from the “before the test” state.

      What’s more, users can update the existing golden copy with new datasets by using the Add to Dataset option.

    • Automating database migration projects with DB Best Migration Platform
      6 November 2019

      PASS Summit 2019, Seattle, WA — DB Best released a multi-purpose Migration Platform, introducing full automation for all steps of a database upgrade or migration project. DB Best cre...

      DB Best released a new 1.5 version of Migration Platform
      23 October 2020

      DB Best is glad to introduce the latest version of Migration Platform — a versatile program for automated database migration. The new version provides a rich set of new features by i...

      DB Best released a new 1.4 version of Migration Platform
      28 August 2020

      DB Best is proud to introduce a new version of its Migration Platform — an all-around program that enables all types of automated database migration. In this version, we presented se...

      Development mode, expected results, and advanced backup for DB Best Migration Platform
      7 July 2020

      What’s new in DB Best Migration Platform 1.3? DB Best has released a new version of Migration Platform, a program that automates every stage of database migration. In this version, w...

      Backup Improvements and Errors Handling for DB Best Migration Platform
      1 April 2020

      DB Best has released a new version of Migration Platform, an all-around program for automating database migration processes. This newer 1.2 version improves error handling practices fo...

      Improving the Test Organizer module of the DB Best Migration Platform
      13 February 2020

      DB Best released a new version of Migration Platform, our ultimate product for automating database migrations. In this release we added new features to the Test Organizer module, a uni...

      Creating and managing database snapshots using the DB Best Migration Platform
      8 November 2019

      We continue covering the core features of the DB Best Migration Platform. In this blog post, we will talk about the Data Store module that allows for creating and using database snapsh...

      How to test breaking changes and new features during the SQL Server upgrade
      7 November 2019

      Database upgrade is inevitable if you're running aging versions of your databases. Alongside with cool new features, the upgrade brings some code changes. Regardless of the severity of...