You can translate the question and the replies:

Compare Objects From One Environment to Another

Hi, We have 3 environments -- Development, Stage and Production. Ideally, these environments should have the same objects/views to it but of course if there are development/testing chances are, there will be differences but is there a quick way to find out those differences between environments? Is there a way or a query that we could use in order to automatically compare what objects are existing in one environment that are missing in the other? Additionally, how do we compare if a derived view in one environment is equivalent or not to a derived view in another environment?
user
11-05-2021 02:58:13 -0400
code

1 Answer

Hi, You can try using the Version Control Systems Integration (VCS) provided by the Denodo Platform. By enabling Version Control System for a database allows you to manage the metadata during development, staging, and production environments. After getting the repositories to your GIT or any other VCS like subversion or TFS you can try using different tools available to compare cross repositories or in GIT itself. But if you want to see the changes within the same environment, some [VCS operations](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/version_control_systems_integration/vcs_integration_features/vcs_operations_for_microsoft_tfs_and_subversion) allow you to see the conflicts between elements. You can navigate to Tools > Admin Tool Preferences > VCS > Enable conflict detection, clear the check box ‘Enable conflict detection’, the conflicts will be detected by the VCS server and displayed. You can refer to [Version Control Systems Integration](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/version_control_systems_integration/version_control_systems_integration), [Configuring the VCS Clients](https://community.denodo.com/docs/html/browse/latest/en/platform/installation/postinstallation_tasks/postinstallation_tasks_in_virtual_dataport/configuring_the_vcs_clients#configuring-the-vcs-clients) of the Virtual DataPort Administration Guide. Hope this helps!
Denodo Team
12-05-2021 18:16:43 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here