• Scroll to top of this topic Scroll to Top of Page

  • Print the current topic Print Topic

  • No expanding elements on this page Show/Hide Expanders

Schema operations options

While performing schema comparison and schema synchronization operations, you will be redirected to the Schema comparison options and Schema synchronization options pages. Here you can exclude objects from the comparison and choose properties to ignore during comparison and synchronization operations.

Please note that the Database Compare Suite automatically excludes options that are not supported in the selected source or target databases.

  1. Check the Assemblies option to exclude assemblies from the comparison or synchronization operations.

  2. Check the Check constraints option to avoid checking constraints from the comparison or synchronization operation.

  3. Check the Computed columns option to exclude Computed columns from the comparison or synchronization operation.

  4. Check the Defaults option to exclude Defaults from the comparison or synchronization operation.

  5. Check the Distribution keys option to exclude distribution keys from the comparison or synchronization operation.

  6. Check the Extensions option to exclude extensions from the comparison or synchronization operations.

  7. Check the External tables option to exclude external tables from the comparison or synchronization operations.

  8. Check the Flex tables option to exclude flex tables from the comparison or synchronization operations.

  9. Check the Foreign keys option to exclude Foreign keys from the comparison or synchronization operation.

  10. Check the Functions option to exclude functions from the comparison or synchronization operation.

  11. Check the Indexes option to exclude indexes from the comparison or synchronization operation.

  12. Check the Join / Hash indexes option to exclude join / hash indexes from the comparison or synchronization operation.

  13. Check the Macroses option to exclude macroses from the comparison or synchronization operation.

  14. Check the Operators option to exclude operators from the comparison or synchronization operation.

  15. Check the Packages / Modules option to exclude packages and modules from the comparison or synchronization operation.

  16. Check the Partitions option to exclude partitions from the comparison or synchronization operation.

  17. Check the Primary keys option to exclude primary keys from the comparison or synchronization operation.

  18. Check the Procedures option to exclude procedures from the comparison or synchronization operation.

  19. Check the Projections option to exclude projections from the comparison or synchronization operation.

  20. Check the Rules option to exclude rules from the comparison or synchronization operation.

  21. Check the Sequences option to exclude sequences from the comparison or synchronization operation.

  22. Check the Shared Libraries option to exclude shared libraries from the comparison or synchronization operation.

  23. Check the Sort keys option to exclude sort keys from the comparison or synchronization operation.

  24. Check the Synonyms option to exclude synonyms from the comparison or synchronization operation.

  25. Check the System objects option to exclude system objects from the comparison or synchronization operation.

  26. Check the Tables option to exclude tables from the comparison or synchronization operation.

  27. Check the Text indexes option to exclude text indexes from the comparison or synchronization operation.

  28. Check the Triggers option to exclude triggers from the comparison or synchronization operation.

  29. Check the Unique keys option to exclude unique keys from the comparison or synchronization operation.

  30. Check the User defined types / Domains option to exclude user defined types or domains from the comparison or synchronization operation.

  31. Check the Views option to exclude views from the comparison or synchronization operation.

  32. Check the Collation option to ignore data collation during the comparison or synchronization operation.

  33. Check the Column ordinals option to ignore column ordinals during the comparison or synchronization operation.

  34. Check the Columns nullability option to ignore columns nullability during the comparison or synchronization operation.

  35. Check the Extended properties option to ignore extended properties during the comparison or synchronization operation.

  36. Check the Foreign keys action option to ignore foreign keys actions during the comparison or synchronization operations.

  37. Check the Function-based indexes option to ignore function-based indexes during the comparison or synchronization operations.

  38. Check the Parameter Types option to ignore parameter types during the comparison or synchronization operations.

  39. Check the Sequence data type option to ignore sequence data type during the comparison or synchronization operation.

  40. Check the Sequence last number option to ignore sequence last number during the comparison or synchronization operation.

  41. Check the SQL register option to ignore SQL register during the comparison or synchronization operation.

  42. Check the View column data types option to ignore viewing column data types during the comparison or synchronization operation.

  43. Additionally, you can check Comment generated SQL script option on the Schema synchromization options tab to comment the generated SQL script – this option allows you to make the review of the generated code and prevent it from executing. This option is not available on the Schema comparison options tab.