How To Version Control Your SQL Developer Data Modeler Designs

thatjeffsmith SQL Developer 11 Comments

Tell Others About This Story:

sddm_logoToday I want to talk about how to version control your Data Modeler designs with Subversion.

Oracle SQL Developer Data Modeler is free.

Subversion is free.

So for no money, you can design your database objects, and version control them for one or more people.

I’ve put together some slides for your enjoyment:

Psst, slide #16 has the ‘good’ stuff

But Wait Jeff, Why Don’t You Have a Database Repository?

Because then you would have have to have a database, AND install server side objects, just to design your database? We don’t do that. We treat your design just like you treat your application source code – something you can manage in your Subversion system.

Still want a database repository? Read this

Tell Others About This Story:

Comments 11

  1. Hi Jeff,
    I am using SQL Deverloper 4.0.0.825 as I need ODBC connection to various databases and dont have oracle database to work on modeling on. For subversion repository it is asking for DM with read write access to repository.
    I have a Subversion repository and trying to connect using my windows login (WHich works otherwise) but is failing when using with SQL Developer. Can you please point me in right direction.

  2. Hello Jeff,

    Love your blog.

    Working with SQL Developer 4.1.3.20

    I wanted to ask a couple of questions in which this would help on automating changes to be deployed.
    For example, how to do you keep track of the changes to be submitted to the servers which have lets say different data schema?
    ie.

    Table 1 has 5 fields version 1.

    When we push to git for the next version ie 2, Table 1 has 6 fields.
    How do we track this change in order to be pushed to 100 other servers ?
    Is there a file ie. update_v1_to_v2.sql that keep tracks changes of in between them ?
    It would be great if this was a feature that the SQL Developer could have as a plugin/feature.

    Thank you for your time.

    1. thatjeffsmith Post
      Author

      So you posted your question on a blog post that’s talking about the data modeler. The data modeler allows you to version your data model as you make changes. Have you given this a look?

      1. I understand the modeler versions the data model through GIT by saving them into individual files, what I was asking whether there is a way to only hold the alterations of the tables. ie.

        ALTER TABLE `fleet`.`drivers`
        ADD COLUMN `driver_id` VARCHAR(45) NULL AFTER `first_name`;

        so, when the server detects the change through Jenkins to get the file and run it.

        1. thatjeffsmith Post
          Author

          We don’t use GIT for the modeler, we use Subversion.

          We’re working on a solution to do pretty much what you’re asking for. For today you’d have to manually add those change scripts to your automation system.

    1. thatjeffsmith Post
      Author
    1. thatjeffsmith Post
      Author

Leave a Reply

Your email address will not be published. Required fields are marked *