Can Navicat Database Comparison Ignore Field Order? (English Version Guide)

Ignore Field Order in Navicat Database Comparison (English Version)

Yes, Navicat's database structure comparison tool allows you to ignore field order differences. This is helpful when you want to focus on structural differences beyond the order of columns in your tables.

Here's how to enable 'Ignore Field Order' in the English version of Navicat:

1. Open Navicat and establish a connection to your database.
2. Navigate to the top menu bar and click on 'Tools'.
3. From the dropdown menu, select 'Structure Synchronization'.
4. In the 'Structure Synchronization' window, choose the two databases you want to compare.
5. Go to the 'Comparison Options' tab.
6. Under the 'Table Options' section, you'll find the 'Ignore Field Order' checkbox. Check this box.

Now, when you perform the comparison, Navicat will disregard the order of fields and only highlight structural differences in your databases.