Database structure difference detector

Database structure difference detector

Talend workflow that detects the structure difference between two PostgreSQL databases and generates script that should upgrade the one to the other. The one database is master the other is slave and needs to be upgraded to the master database. The workflow detects the following changes :

  • new tables
  • deleted tables
  • new columns
  • deleted columns
  • altered columns like
    • datatype
    • constraints
    • indexes
  • new views
  • changed views
  • deleted views

Skills

  • PostgreSQL
  • Taneld
  • Java

Project roles

  • Project management
  • Requirement analysis
  • software development
  • QA
  • installation

Project details

Project Type: Talend
Development Model: Task Based
Time of development: 2014

Georgi KirtchevDatabase structure difference detector