Search code examples
javaoraclesql-server-data-toolsschema-migration

SSDT Equivalent for Oracle Database


In SSDT there is a mechanism for managing DDL changes, for instance a new column or a change to a data type. Instead of putting an 'Alter Table' statement into the database project, instead we edit that original 'Create Table' statement which focuses on the final state that includes the new column. It detects the difference between older and new script and creates necessary 'Alter Table' script to use for deployment.

Is there any equivalent strategy to achieve the same in Oracle Database as I am using J2EE technologies and Eclipse IDE.


Solution

  • No it is not I am afraid, SSDT is a free tool developed by Microsoft to help SQL Server deployments. I would think it extremely unlikely that Microsoft would ever allow let alone help deployments to Oracle - it is a new Microsoft sure but some things will never change!

    The best alternative is to use JetBrains datagrip as an IDE and flyway as a deployment tool:

    https://flywaydb.org/documentation/database/oracle

    https://www.jetbrains.com/datagrip/

    In my opinion Microsoft has created the best development environment of ANY RDBMS and throw in the redgate suite of tools and it makes the tooling a real differentiator.

    Ed