Some more feedback

Track changes to Oracle schemas in your existing version control system.

Some more feedback

Postby Joni Vandenberghe » Mon Feb 25, 2013 9:39 am


I am experimenting with SCFO in a project spread over 3 schema's over 2 databases.
I noticed I can add other schema's to the project but not other databases. So I need to create 2 projects. I bumped again into the fact that you can't edit projects, so I had to delete and recreate them when I made a mistake, the only thing I can edit is the name.

One of the schemas contains grants, tables, .. from other projects aswell, but when I try to write the grants to files, I have to pick all grants or no grants. I can't take grants with me from other schema's, so for that schema I can't use your tool.
Joni Vandenberghe
Posts: 3
Joined: Thu Feb 21, 2013 10:31 am

Postby Joni Vandenberghe » Mon Feb 25, 2013 10:11 am

Another thing. Instead of writing the changes to the database, any chance we could export this to a script so we can do this manually? This is because we might have to install the same script weekly or dayly for months to come, and we would like to automate this process.
Joni Vandenberghe
Posts: 3
Joined: Thu Feb 21, 2013 10:31 am

Postby Michael Christofides » Mon Feb 25, 2013 4:50 pm

Thanks Joni.

Regarding your final comment, you may find that comparing to a scripts folder in our Schema Compare tool will be a good fit for your needs:

Regarding the other points, thank you for the feedback. Editing projects is possible, but currently hidden away in an XML file here: C:\\Users\\<username>\\AppData\\Local\\Red Gate\\Source Control for Oracle 1\\ConnectionStore.xml

Please do add requests, comments and votes to our public feature request forum:

We are collating feedback and using this to help prioritise future work.
Michael Christofides
Posts: 97
Joined: Wed Apr 20, 2011 5:37 pm
Location: Red Gate Software

Return to Source Control for Oracle

Who is online

Users browsing this forum: No registered users and 0 guests