Uni-Logo
Databases and Information Systems
Sie sind hier: Startseite Teaching Lehrangebot Frühere Semester Programmierung in SQL
 

Programmierung in SQL

Subversion with Oracle SQL Developer: Step-by-step configuration

It is possible to use Subversion inside the Oracle SQL Developer. To connect to a repository and to commit your work, follow these steps:

  1. Enable the versioning navigator in the view-menu.

    View Menu

  2. Create a new connection.

    Create connection

    Repository-URL(look at the software page)
    Connection name(choose name)
    User name(your pool account)
    Password Type(guess what...)
    Test your connection before creating it.
  3. It is not intended to work with the files shown in the navigator. You must check out the content first. Ignore the warning about the repository root and choose an appropriate target directory on your file system (leave the revision empty, checkout recursively).

    Checkout content

  4. Now, enable the file manager in the view menu.

    File manager

  5. Go to your local directory where you checked out the repository. To create a new file, right-click on the directory. Choose "SQL-File" in the following dialog. Choose a file name and optionally a different directory for it (create a sub-directory for each exercise sheet).

    new file

  6. To put the new files into the repository, select "versioning" on the created sub-directory and add the new content. Repeat this step and commit everything. Executing commands on directories affect their whole content. Commands can also be used with single files. Don't forget to enter useful comments for your actions.

    commit content

  7. Commands to update, merge, delete, clean and so on are also contained in the versioning menu. Another useful feature is the comparison between different revisions.

  8. For less trouble with different encodings, choose UTF-8 for your files (Extras - Preferences).

    encoding

Other SVN-clients are available on our software page.