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. Schema comparison
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

Schema comparison

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

The schema comparison module displays the differences in schemas and database objects in the source and target databases (Figure 1).

Note: Schema comparison module marks the objects that weren’t mapped in the Object Mapping module) as invalid items.

After objects are added, the main Schema comparison window presents source and target objects in three tabs: All, Invalid, and Valid. Each tab divides objects based on their compatibility between the source and target versions.

All invalid valid tabs

Initially, the objects in the view are divided into four groups:

  • Not Matched — objects without a pair
  • Ambiguous — uncertain objects pairs that might be matched
  • Not Supported — objects that cannot be compared (as the system doesn’t support the objects from Materialized Views, Policies, or Children of packages)
  • Comparable — matched objects that can be compared.

Comparing the objects

To compare objects follow these steps:

  1. (Optional) Edit the pairs of compared objects, or add new if necessary
  2. Check the objects to compare
  3. Click the Compare button

After you do that, the comparison results show up in the Results tab and you can export them in the XML file by clicking the Export button.

Detailed results

Adding the pairs of compared objects

To add a new pair of objects:

  1. Click the Add button. (A field for adding a new pair shows up (Figure 3))
Figure 3. Fields for adding new pair

Figure 3. The field for adding new pairs

  1. Drag and drop the object from the metadata tree to the field. Note: When found, the object from the opposite tree is added automatically.
  2. Click the Add button. Note: If the list already contains a similar pair the button will be disabled.

Editing the comparison options

To edit the comparison options, click the gear wheel button in front of the required pair of comparable objects.

Then opens the Details window where you can find detailed information and edit the comparison options (Figure 4).

Figure 4. Options window for table

Figure 4. Comparison options window

You can also modify the comparison settings in the Project Settings window. There you can specify what objects to include to the comparison and what properties to ignore (Figure 5).

Figure 1. Schema Comparison settings

Figure 5. Schema comparison settings


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
PreviousSchema conversion
Next Data comparison

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.