Red Gate forums :: View topic - Roadmap
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Source Control for Oracle
Source Control for Oracle forum

Roadmap

Search in Source Control for Oracle forum
Post new topic   Reply to topic
Jump to:  
Author Message
Ivan



Joined: 22 Apr 2014
Posts: 7

PostPosted: Tue Apr 29, 2014 12:36 pm    Post subject: Roadmap Reply with quote

Hi,

Is there any info regarding the Source Control for Oracle roadmap ?
I noticed the Red Gate road map doesn't mention any Oracle tool.
Does this mean nothing is planned (for 2014) ?


Regards,
Ivan
Back to top
View user's profile Send private message
richardjm



Joined: 20 May 2005
Posts: 383
Location: Red Gate Software Ltd

PostPosted: Fri May 02, 2014 8:02 am    Post subject: Reply with quote

The Oracle team was pulled off in September last year to work on other tools and we're just starting to pick up the Oracle tools again to work on them.

We're working on a roadmap, there's an offsite next week which may change things.

Currently I'm testing a release that improves materialized view support (amongst a set of bug fixes) for Schema Compare and Source Control for Oracle (within the next few weeks I hope). I'm also finishing off a major update to Data Compare that should speed things up (parallel schema registration and a major improvement in timestamp comparison speed) – there are still a few integration tests failing so it's not quite ready for final testing yet.

If you want the pre-release version of Schema Compare and Source Control just let me know.
_________________
Richard Mitchell
Project Manager
Red Gate Software Ltd
Back to top
View user's profile Send private message Send e-mail
Ivan



Joined: 22 Apr 2014
Posts: 7

PostPosted: Fri May 02, 2014 9:13 am    Post subject: Reply with quote

Last year, we bought 5 licenes for some urgent needs and evaluation of the product.
I'm currently starting to investigate if we wan't to use the product to setup a continuious integration and release management environment for all our database developments. This would/should cover both our Oracle and SQL Server databases.
Hence my interest in the roadmap, especially for the Oracle tools as they are lagging behind compared to the SQL Server tools available.

At first glance, what we are missing the most in SC for Oracle is support for Types and the storage clause (tablespace) for tables, materialized views and indexes.

Please let us know when you come up with a raoadmap.

Regards,
Ivan
Back to top
View user's profile Send private message
richardjm



Joined: 20 May 2005
Posts: 383
Location: Red Gate Software Ltd

PostPosted: Fri May 02, 2014 9:25 am    Post subject: Reply with quote

So for type support are you meaning nested tables? I've started playing with this recently and it seems to work in Schema Compare.

My simple test case is..
Code:

create type acme.nt_nested is table of int;
create table acme."RankTable" (
  "ID" NUMBER(4,0) NOT NULL ENABLE,
  nest acme.nt_nested)
  nested table nest store as "RankTable_nt_tested";


For storage clauses there is an option "Ignore Storage" in Schema Compare that is enabled by default.

Materialized views - as I've mentioned I've been working on a lot so now it supports complex queries, column aliases and grants. Indexes I'm not aware of anything outstanding.

I'm still getting up to speed on Oracle so any help from experts about missing features is really appreciated (especially if they come with a simple reproduce case).

Richard
_________________
Richard Mitchell
Project Manager
Red Gate Software Ltd
Back to top
View user's profile Send private message Send e-mail
richardjm



Joined: 20 May 2005
Posts: 383
Location: Red Gate Software Ltd

PostPosted: Fri May 02, 2014 9:39 am    Post subject: Reply with quote

Of course I've just realised this topic is in Source Control - so disabling the "ignore storage" option isn't available (yet).
_________________
Richard Mitchell
Project Manager
Red Gate Software Ltd
Back to top
View user's profile Send private message Send e-mail
Ivan



Joined: 22 Apr 2014
Posts: 7

PostPosted: Fri May 02, 2014 11:33 am    Post subject: Reply with quote

    Types :
      Assuming the nested tables are supported (we didn't test it), that's fine. However, the type definitions themselves (unless I'm misstaking) are not. The same as grants to users/roles are supported, but the users/roles themselves are not. The support of those (and other database objects) are part of a feature request on the forum for which we also voted.

    "Ignore Storage" option :
      I wasn't aware of this option in Schema Compare, good to konw.
      However, as you point out, it's not helping for SC for Oracle as that tool doesn't allow you to change the default options used. This one also is a feature request on your forum.


Thanks for your feedback so far,
Ivan
Back to top
View user's profile Send private message
richardjm



Joined: 20 May 2005
Posts: 383
Location: Red Gate Software Ltd

PostPosted: Fri May 02, 2014 12:27 pm    Post subject: Reply with quote

Creating users and roles is one level above what Schema Compare is designed to do. We can't create the target via the script. I was thinking about adding a UI for schema creation when creating the comparison but I'm not sure that's right either.

I've just checked the nested type and it does appear in the Schema Compare interface.

I've had a look into allowing options for comparison and it seems doable - there's even a file for it that isn't yet used (comparisonoptions.xml). It's on my list to look at as a potential quick-fix.

Richard
_________________
Richard Mitchell
Project Manager
Red Gate Software Ltd
Back to top
View user's profile Send private message Send e-mail
Ivan



Joined: 22 Apr 2014
Posts: 7

PostPosted: Fri May 02, 2014 12:57 pm    Post subject: Reply with quote

Creating users and roles :
In fact, we are not realy planning to create roles/users, but we would still like to be able to compare them. Naturally we understand, in the concept of Schema Compare, comparing doesn't go without creating...

Still, most of the blocking points to use SC for Oracle are linked to the missing possibility to configure the compare options. Most missing functionalities are already covered by Schema Compare.
Back to top
View user's profile Send private message
richardjm



Joined: 20 May 2005
Posts: 383
Location: Red Gate Software Ltd

PostPosted: Fri May 02, 2014 1:22 pm    Post subject: Reply with quote

Good to know, I'll hopefully get something for the options out soon(ish). Probably not in the upcoming release though.
_________________
Richard Mitchell
Project Manager
Red Gate Software Ltd
Back to top
View user's profile Send private message Send e-mail
richardjm



Joined: 20 May 2005
Posts: 383
Location: Red Gate Software Ltd

PostPosted: Wed May 28, 2014 9:37 am    Post subject: Reply with quote

Just so you know I'm working on the options in Source Control however the main issue is actually creating storage options that are granular enough to be useful. The current single option has the subtlety of a sledgehammer.

What individual settings would you think are necessary? So far my ideas run to...

“Ignore Tablespace”
“Ignore X”
“Ignore Y”
“Ignore ‘cruft’” – as somebody else puts it when de-selecting “Ignore Storage”

I’m not fully up to speed on Oracle yet so I appreciate any idea you can give me on how to group the options for “storage”.

http://docs.oracle.com/cd/E16655_01/server.121/e17209/clauses007.htm#SQLRF52291
and
http://docs.oracle.com/cd/E16655_01/server.121/e17209/clauses009.htm#SQLRF52300

On a related note I took a closer look at nested table support and it wasn't very good so I've worked a lot on it for the next release.
_________________
Richard Mitchell
Project Manager
Red Gate Software Ltd
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group