Home > linux, oracle > How to integrate Oracle SQL Data Modeler with Subversion

How to integrate Oracle SQL Data Modeler with Subversion

It’s not necessary to work on a big project to use SVN. Keeping your design into SVN repository is very useful and good practice. By doing so you could easily see what changes you’ve made to the design and in case of accident you could restore any older version and correct the problem.

After you successfully setup Subversion (here) it’s time to start integrating tools with SVN. Integration of Oracle SQL Data Modeler is really easy and it’s done in few simple steps:

1. Integrated Oracle SQL Data Modeler with SVN:
Start Oracle SQL Data Modeler
Go to View -> Team -> Versioning Navigator
At the Versioning Navigator window, right click on Subversion and then New Repository Connection.
Populate the fileds at new window Create Subversion Connection with repository URL, username, password and name for the repository.

2. Import files to the repository:
Once configured you have to import all the files on which you are working, including the database design to the repository. For this purpose you could use Data Modeler itself, but I prefer TortoiseSVN to create the repository structure and then import all the files in it. As I mention in preventions post, the best practice is to create three directories trunk, branch and tags and then import your working directories to trunk.

When these files are imported you should delete them from your hard drive and checkout the same files from the repository so you have a working copy.

3. Start using Oracle SQL Data Modeler and SVN:
Checking out from the repository could be done by TortoiseSVN or by Oracle SQL Data Modeler -> Versioning menu -> Checkout. Once you have a working copy you could open the design and start working on it.

Next time you make a change and save the design you’ll be able to commit these changes to the repository, again by going to Versioning menu and then Commit. Using comments is also good idea so you could easily track when and what changes you’ve made to the design.

Regards,
Sve

Similar Posts:

m4s0n501
Categories: linux, oracle Tags:
  1. Rober2D2
    June 6th, 2012 at 20:36 | #1

    Anyway to completely remove/disable SVN support from Data Modeler?

    I use an external tool to synchronize with SVN. Data Modeler is really annoying beacuse it tries to synchronize as soon as I open a design with .svn folder or it adds files to svn:ignore property

  2. Svetoslav Gyurov
    June 7th, 2012 at 10:19 | #2

    Hi,

    Sure, you can disable the SVN support. Go to Tools -> Preferences -> Extensions and there you could unselect the extension for SVN. Restart Data Modeler and now you should not have support for SVN, respectively Data Modeler won’t commit itself, but just save files.

    Regards,
    Sve

  3. Gusi
    August 28th, 2012 at 19:53 | #3

    Hi,
    I changed my design in Data Modeler ver 3.1.1. Any idea why commit is greyed out?
    Thanks,
    gusi

  4. Svetoslav Gyurov
    August 28th, 2012 at 22:24 | #4

    Hi Gusi,

    Do you mean that you don’t have any versioning support or just commit is greyed out ? This functionality is bring by extension, to check whether is enabled go to Tools -> Preferences and then Extensions, there you should have enabled (tick) Versioning Support.

    Regards,
    Sve

    p.s. A week ago Oracle released new version 3.1.2

  5. Gusi
    August 28th, 2012 at 22:32 | #5

    Thanks, Sve. Actually it was the problem how one checks out from SVN,
    I thought 3.1.2 was SQL DEVELOPER with 3.1.1 SQL DATA MODELER. I’ll go and check that.
    Thanks again

  6. gusi
    August 30th, 2012 at 19:32 | #6

    Hi,
    In one of the users, Go to View -> Team -> Versioning Navigator
    At the Versioning Navigator window, right click on Subversion.
    We dont see Subversion tab.
    Have you seen this in data modeler 3.1.1 before?
    Regards,
    gusi

  7. Svetoslav Gyurov
    August 30th, 2012 at 23:56 | #7

    Hi Gusi,

    If you go to View and then Team, this means that Subversion extension is enabled. Once you get the new windows, right click on Subversion will give you an option to create new repository and then connect and browser the same repository. I’m using version 3.1.0 and now 3.1.2, with both versions I can connect to Subversion.

    Regards,
    SVe

  8. gusi
    August 31st, 2012 at 01:34 | #8

    Hi,
    I am using 3.1.1 right now and I can connect to subversion repository I created on linux server. But for one user, I can navigate to versioning window but Subversion option is not there. I was thinking something is different on his install. How do we enable Subversion extension?
    Thanks,
    gusi

  1. No trackbacks yet.