Compare Databases

With the Compare Database functionality, the user is able to compare objects of two separate databases and or files. You are able to compare current database with another or compare 2 databases other than the current you are in. Furthermore you can import .obp and .txt files to compare.

Compare Databases
Compare Databases

Setup

Open Administration > Databases.

Setup
Setup


In the Database Card you set the properties for the databases you want to connect for comparison.

Comparing Databases

Open Analyzing Tools > Compare Databases. If you want to compare your current database set Left is Current Database. If you want to compare another database, you select a database in the field Left Database. Select a database in the Right Database to which you want to do comparison, and click Refresh. If lines are red the C/AL History has to be updated in the database.

Analyzing Changes

You can set a filter on Different to show only the objects which are not equal or do not exist in one of the databases. You can analyze the differences with your compare tool with the menu options Show Changes in Directory or Show Changes in One File.

Analyse Changes
Analyse Changes


You can see if the no. of records are equal between the databases. This can be used to e.g. check if your master data is already up to date in your test database. Push Calculate No. of Records for all objects or a selection.

No. of Records
No. of Records


It is possible to filter on project and transport, as well as open the tool from project and transport cards and list. For any of the objects in the left database the Active Projects column lists all active projects the object is their part.

For tables there is an option to zoom in on the fields with the Compare Fields button. A similar window will open where you can see the differences a field level. See chapter Compare Fields for more info.

Push Objects

If the objects can be transferred without any changes you can use the push functionality to send your objects to the other database. The objects are imported in a compiled state.

Merging Objects

The objects can be merged using your compare tool into the other database. The objects are imported in text format, therefore the option Use Command Line must be enabled.

Merge Objects
Merge Objects