Options for underlying scripts
Allow us to specify options (like in Schema Compare for Oracle) when creating a Source Control for Oracle project (e.g. we'd like to include storage clauses in the table create scripts)
Note from Red Gate: If you vote on this feature request, it would also be helpful to know what options specifically you'd like to see.
Storage options are now available in the latest release of the tools.
There are a number of new “Include ..” storage options available in both the Schema Compare and Source Control tools.
To get to options in Source Control right click on the project in the start screen and selected “Edit comparison options”.
-
Ivan commented
Would be nice to have storage clause and partitioning clause included for tables and indexes as a option during extraction
-
AdminRichard Mitchell (Admin, Redgate) commented
I'm still working on this, just taking a lot longer than expected as I'm hitting many issues parsing storage options from scripts.
-
Jacek commented
include storage clauses
-
Tim Cavanagh commented
ignore starting sequence
-
Geoff Os commented
I think you need to ensure you include logging, segment creation options as well.
-
Roberto Martin commented
It would be great if I could clone a database with your application. ( just adding schema/tablespaces support)
-
Roberto Martin commented
I would be nice to have at least all configuration options that Schema Compare have.
-
Dennis Mellican commented
Allow sequences START WITH to be stored into Source Control.
-
Mark Illum commented
it should allow for the ability to check in individual storage options (for example we want to check in PCTFREE but not other storage options)
-
Mark Illum commented
specifically a new option of ignore PCTFREE, as storage is to broad. We DO want to ignore other storage areas, but WANT to INCLUDE PCTFREE when we check into source controll
-
bernard antonuk commented
indeed...it's not just the storage...it's all the partitioning information including the storage, both for tables and indexes