Good morning. I saw the demo of Gitora, and impressed very much. I am looking forward for the product to come out. I still have certain questions on - 1. if Gitora can be used for Table definitions?? (I heard you mentioned you can store anything that can be "CREATED" can be placed in the Repository, however I did not see any "Tables" in the Repository explorer) 2. How about the data? (I am not expecting the data restoration etc.., but just curious, for example we dropped a column and then realized to restore it). 3. I am wondering if we can have the Version Control Repository, and the application objects in two different databases. Because I am not interested to keep VCR separated from my application database.

asked 26 Nov '14, 10:28

viswapsp's gravatar image

viswapsp
3619
accept rate: 11%


Hi Viswa,

Thank you for your kind words. Please note that you do not have to wait for Gitora to try it. Formspider 1.8 already has Gitora built-in. Simply create an application in the IDE but do not create any Formspider objects in it. Just add database objects. Then, you can use your application like a code repo in Gitora.

Below are the answers to your questions:

Can Gitora be used for Table definitions? No. Gitora can manage anything that can be created in a schema with the CREATE OR REPLACE commend, namely, views, packages, procedures, functions and synonyms. However, you can extract the DDL of a table and save the file to the working directory the Gitora creates in your OS under a new folder and have Git manage that folder as well with the rest of your repo. We may add support for tables in the future.

How about the data? No, Gitora doesn't deal with the data.

I don't understand the 3. question. Can you elaborate a little bit?

Kind Regards,
Yalim

link

answered 26 Nov '14, 15:13

Yalim%20Gerger's gravatar image

Yalim Gerger ♦♦
1.8k5
accept rate: 15%

edited 27 Nov '14, 07:51

Yalim's gravatar image

Yalim ♦♦
2.8k5

Blockquote

Yalim - Good afternoon. Thank you for the reply :)

I will explain my third question using my situation (and this applies to many of us) -

  1. I have 3 promotion environments - namely Dev, Test and Prod.
  2. Each environment objects are spread across multiple Oracle databases (I am calling them "applicaton databases").
  3. In Dev and Test simultaneously I have say Main, ProdFixes, Proj1, and Proj2.
  4. I would like to have the Gitora repository on a "separate server and database" from my Oracle servers. So, from my Gitora, I would like to manage versions of "multiple" database entities. (promotion labels (Dev/Test/Prod) and branches for each project and versions of each object in that branch).

Is that possible? Or should all the objects (for which versioning need to be maintained) belong to a single instance? Also, is it a must that Gitora should reside on one of the "application databases".

I hope I am clear than last time :)

Blockquote

(26 Nov '14, 17:12) viswapsp

Hi Viswa,

Yes, I think you can do what you asked in 4). But some modifications are needed after the default installation.

Allow me to explain how Gitora is architected:

Gitora has three parts:

1) A database schema
2) A middle tier application (requires a JEE app server like Tomcat)
3) Git

Gitora installer installs all three (including the Tomcat).

The middle tier and Git are installed on the same machine by the installer. This machine can be a different machine than the Oracle database Gitora schema is installed in step 1.

The Gitora schema can manage all the objects in the database it is installed. A version control repository created by the Gitora schema in Git can only have objects from the same database.

However, the Git installation can contain repositories from many different databases. You can install the Gitora schema to multiple databases and connect them to the same Git. In such a set up, all your code would be managed by the same Git installation. This however would require some modifications after the installation because by default the installer installs all three components explained above.

Kind Regards,
Yalim

link

answered 27 Nov '14, 08:27

Yalim's gravatar image

Yalim ♦♦
2.8k5
accept rate: 22%

edited 27 Nov '14, 08:27

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×7

Asked: 26 Nov '14, 10:28

Seen: 6,439 times

Last updated: 27 Nov '14, 08:27


© Copyright Gerger 2017