Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages
  1. DB Best Documentation
  2. Migration Platform
  3. Product features
Migration Platform
  • Overview
  • Product features
    • Release notes
    • Source and target platforms
    • Third-party applications
  • Getting started
    • Creating a new project
    • Ora2Pg installation
    • Tree view filtering
    • Compatible ODAC versions
    • Opening an existing project
    • Connecting to servers
      • Connecting to an Azure SQL Database
      • Connecting to an Oracle database
      • Connecting to a PostgreSQL database
      • Connecting to a Microsoft SQL Server database
    • Command timeout
  • Mapping
    • Object mapping
    • Error mapping rules
    • Data types mapping
  • Schema conversion
  • Schema comparison
  • Data comparison
  • Data migration
    • Migration task
      • Creating migration tasks
      • Templates
      • Migration options
      • Task actions
      • Task statuses
      • Errors or non-standard situations
    • Installing migration agent
      • Installing and uninstalling the data migration agent
      • Registering the migration agents
    • Project settings
  • Test organizer
    • Creating tests
    • Auto-generating tests
    • Groups and tests execution
    • Groups and tests states and execution statuses
    • Tests moving logic
    • Importing and exporting tests
    • Advanced comparison options
    • Creating reports
    • Error handling
  • Data store
  • Development project
  • System requirements
  • Hot keys
  • Known issues
  • Support

Product features

  • Share
    • Share via Facebook
    • Share via Twitter
    • Share via Linkedin

You can use the DB Best Migration Platform in your database migration and upgrade projects. This page describes the key product features, migration destinations, and upgrade opportunities.

The DB Best Migration Platform supports the following database migration projects:

  • Oracle Database to Microsoft SQL Server
  • Oracle Database to Azure SQL Database
  • 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
  • IBM DB2 to PostgreSQL

You can also use DB Best Migration Platform to upgrade the following databases:

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

DB Best Migration Platform Features

DB Best Migration Platform assists in automating and navigating through the database migration or upgrade project. Particularly, the DB Best Migration Platform features include:

  • Database schema conversion
    The DB Best Migration Platform integrates with Microsoft SQL Server Migration Assistant and AWS Schema Conversion Tool to ensure the highest possible quality of database schema conversion.
  • Database schema comparison
    The Schema comparison module allows for comparing the source and target database schemas and discovering the possible database schema drift.
  • Types and objects mapping
    The DB Best 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 in the Mapping module.
  • Data migration
    The Data migration operation moves data between source and target databases. The DB Best Migration Platform analyzes the size of the migrated tables and determines the right way to move data quickly and correctly using parallel processes.
  • Data comparison
    The Data Comparison module allows for comparing data in the source and target databases. Here you can see tables with equal data as well as tables with comparison errors.
  • Test organizer
    The Test organizer module provides users with an easy way to create tests for stored procedures, functions, views, tables, and ad-hoc queries. You can use the Test Organizer module to generate tests automatically or manually for the above-mentioned database objects.
  • Data store
    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.
  • Command-line interface
    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.

Didn’t find the answer?

You can report problems, ask questions or share ideas for improvements on our email [email protected].

Did this page help you?

Provide Feedback
PreviousOverview
Next Release notes

Did this page help you? Yes

Thanks for letting us know that we did a great job.

Did this page help you? No

Thanks for letting us know that there is a problem on this page.

Send Feedback

Feel free to share your ideas or occurred issues with us. The DB Best team will be happy to make our documentation better.

Please, specify your email address so that we can reach out to you to clarify your question. Also, we will use this email address to notify you about solving the issue.

* marks the mandatory fields

Dark theme Light theme

© 2002–2021 DB Best Technologies, LLC. All rights reserved.