Activity overview
Latest activity by Ivan
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. / comments
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, c...
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 / comments
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 ...
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 / comments
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 relea...
Hi Eddie,
Verifying to answer your question has shown I overlooked the role grants...
So, there is no problem with the grants to roles, you can close this ticket.
Reasons I missed them are :
- in Schema compare for Oracle, both grants to users and roles are grouped together while in SC for Oracle the are separate.
- Due to the lack of sort functionality on the screen, and the fact they were very far from each other in a long list of objects (initial load into subversion), I found the grants to user, but overlooked the grants to roles.
Sorry for my misstake,
Ivan / comments
Hi Eddie,
Verifying to answer your question has shown I overlooked the role grants...
So, there is no problem with the grants to roles, you can close this ticket.
Reasons I missed them are :
- in S...
Object grants not correctly compared by Source Ctrl Oracle.
Hi,
Although Schema Compare for oracle correctly compares object grants, Source Control For Oracle seems not.
Apparently SCFO is ignoring the grants to roles.
Regards,
Ivan
Roadmap
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
Soure Control for Oracle compare options.
It seems Soure Control for Oracle is using Oracle Schema Compare behind the scenes which is good.
However, is it possible to define the compare options used by Soure Control for Oracle (as is the c...