SSDT Equivalent for Oracle Database
NickName:Satish Pahuja Ask DateTime:2017-03-31T21:29:54

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.

Copyright Notice：Content Author:「Satish Pahuja」，Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article：https://stackoverflow.com/questions/43141978/ssdt-equivalent-for-oracle-database

Answers
Ed Elliott 2017-03-31T20:55:48

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!\n\nThe best alternative is to use JetBrains datagrip as an IDE and flyway as a deployment tool:\n\nhttps://flywaydb.org/documentation/database/oracle\n\nhttps://www.jetbrains.com/datagrip/\n\nIn 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.\n\nEd",

David Atkinson 2017-04-01T22:25:22

It's not built into the IDE like SSDT is, but Redgate has comparison tools for Oracle that use the same methodology as SSDT Database Projects.\n\nThis can be used in conjunction with Redgate Source Control for Oracle, which maintains a schema model in your chosen VCS.",

Products recommended by Amazon
More >>>
SanDisk 128GB microSDXC-Card, Licensed for Nintendo-Switch - SDSQXAO-128G-GNCZN
SanDisk 128GB microSDXC-Card, Licensed for Nintendo-Switch - SDSQXAO-128G-GNCZN
 HUANUO Dual Monitor Stand - Adjustable Spring Monitor Desk Mount Swivel Vesa Bracket with C Clamp, Grommet Mounting Base for 13 to 27 Inch Computer Screens - Each Arm Holds 4.4 to 14.3lbs
HUANUO Dual Monitor Stand - Adjustable Spring Monitor Desk Mount Swivel Vesa Bracket with C Clamp, Grommet Mounting Base for 13 to 27 Inch Computer Screens - Each Arm Holds 4.4 to 14.3lbs
 AMD Ryzen 5 5600X 6-core, 12-Thread Unlocked Desktop Processor with Wraith Stealth Cooler
AMD Ryzen 5 5600X 6-core, 12-Thread Unlocked Desktop Processor with Wraith Stealth Cooler
 Timberland Men's 6-Inch Premium Waterproof Boot
Timberland Men's 6-Inch Premium Waterproof Boot
More about “SSDT Equivalent for Oracle Database” related questions
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...

Show Detail
Which SSDT version supports Oracle Database 12c?

I am trying to connect with Oracle 12c database using SSRS 2012. Getting the following error. I cannot change any property of Oracle db but can change the version of SSDT if required.

Show Detail
SSDT Stand-alone connection to Oracle

I have installed SSDT standalone from https://social.msdn.microsoft.com/Forums/en-US/dd410fd7-6276-4fdb-8332-6bfdd2b6eb15/ssdt-for-visual-studio-code?forum=ssdt. I then installed Instant Client

Show Detail
Can we create a project for oracle database deployment similar to visual studio SSDT project

I need a way to deploy the oracle database in a single click, something similar to SSDT projects.

Show Detail
Import or update an SSDT database project programatically

I'm hoping to use an SSDT database project alongside a migration-based database development tool like grate. The idea here would be to use migration scripts as the source of truth for the database ...

Show Detail
SSDT for SSRS - Unable to connect to data source 'DataSource1'.The selected data extension ORACLE is not installed or cannot be loaded

I installed the latest SSDT for visual studio 2015 to create/modify SSRS reports which connects to Oracle 11 database. The previous version of SSDT (for visual studio 2012) had "Oracle" as one of the

Show Detail
Manual Database Deployments to SSDT On An Existing Database in VSTS

We have a Live database project for which we currently update via manual deployments only. As part of our process improvement initiatives however, we're proposing to switch to SSDT to enable us imp...

Show Detail
Is Schema in Oracle is equivalent to Database in Microsoft SQL Server?

I am new to Oracle database and I wanted to create a database in Oracle. I followed this link to create a database: http://www.fehily.com/books/createdb/createdb_oracle_11g_2.html In Microsoft SQL

Show Detail
SSDT in Visual Studio 2015 Oracle Connection Issue

I am trying to setup SSDT so that I am able to run reports locally and edit them in Visual Studio. I have a previous report that I know works. I have installed the Oracle Developer Tools for Visual

Show Detail
Any documentation on SSDT deployment?

There is a brand new way of developing with databases with Visual Studio 2012: SQL Server Data Tools. I am a user of the good old VSDBCMD. I use VSDBCMD on a daily basis to updates databases on st...

Show Detail