Skip to Main Content
Feature Request FR-3685
Product Area SQL Workshop
Status CLOSED

1 Voters

Implement "Database Diff" feature from OG SQL Developer into SQL Workshop

raakeshbc Public · Mar 12 2024

Idea Summary
Have a section in SQL Workshop to perform Database Diffs that can compare objects between 2 schemas + Present the differences for review + Allow user to export list of objects that can be shared with other developers + Ability to merge/promote changes of selected objects to target schema.

Use Case
It would be useful while promoting code to higher environments such as Test and Production. Without this feature, developer has to manually note down every object that is changed over the course of an application development project. With SQL Developer losing further support and its VS Code extension venturing into a “very distant” roadmap to provide features available in current Desktop version of SQL Developer, this feature would help all developers to have an in-built option to perform this.

Preferred Solution (Optional)
It could be implemented to ape the same functionality already available in SQL Developer(Desktop). Or, it could go a step ahead and allow generating an additional list of objects which can be edited and exported/imported(to share with other developers so that they can also run compare on those specific objects).

We reviewed this idea carefully and came to the conclusion that it does not constitute an appropriate APEX feature request.

Comments

Comments

  • jeff.d.smith OP 2.1 years ago

    With SQL Developer losing further support and its VS Code extension venturing into a “very distant” roadmap to provide features available in current Desktop version of SQL Developer, this feature would help all developers to have an in-built option to perform this.

    Oracle SQL Developer is still 100% supported, we're working on an update now with some important bug fixes.

    VS Code Extension is under heavy active development and features like Database Diff will be coming. There won't be a window where a user doesn't have access this feature via one tool or the other.

  • jeff.d.smith OP 2.1 years ago

    “very distant” - time is relative, we're hoping for 1-2 years, that's a small amount of time for a software project of this scope

  • jayson hanes Admin OP 2.1 years ago

    Thanks Jeff! Many developers are very excited about this DB tools journey!