Skip to main content
Question

comparing 2 database

  • December 4, 2017
  • 3 replies
  • 201 views

boubcher
Contributor
Forum|alt.badge.img+11

Is there any we could use FME to compare 2 database schema, to check for any table and any attributes diffrences.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

fmelizard
Safer
Forum|alt.badge.img+20
  • Safer
  • 3719 replies
  • December 4, 2017

Hi @boubcher, you can compare two datasets with quite a few methods. I would recommend checking out this article: Change Detection.


danilo_fme
Celebrity
Forum|alt.badge.img+51
  • Celebrity
  • 2077 replies
  • December 4, 2017

Hi @boubcher, you can compare two datasets with quite a few methods. I would recommend checking out this article: Change Detection.

Interesting link. Thanks to share us!

 

 


boubcher
Contributor
Forum|alt.badge.img+11
  • Author
  • Contributor
  • 212 replies
  • December 5, 2017

thanks Tia for your response

But is there a way to compre tables in db1 with db2 and perform operations creat,update, delete of the tables

In our case

We have performed many chnages in our app in dev environment and we need to update the production , we thought that we could use fme to update the production db