Question

comparing 2 database

  • 4 December 2017
  • 3 replies
  • 5 views
boubcher
Rank
Badge +10

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

3 replies

fmelizard
Rank
Userlevel 4
Badge +13

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

danilo_fme
Rank
Userlevel 4
Badge +30

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
Rank
Badge +10

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

Reply


Community Stats

28,669
Posts
109,357
Replies
36,531
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.