Posts
Sort by recent activity
Support for Surrogate Key and New Column Value Customization
Often times tables have surrogate key (sequence generated) values, that are use in in addition to a set of natural (alternate / unique) key constraints.The surrogate key value typically has no inhe...
Deploying Static Data from Source Control
I understand that SourceControl can capture static data (e.g. for a look-up table) and how the capture mechanisms work.However, how do I deploy the static data I've captured to a target table. Doe...
TYPE changes with /abortonwarnings switch
We're running SCO version 5.2.4.1278 from the command line and observed some odd behavior when changing an object type definition (referenced by a collection type) when combined w/ the /abortonwatn...
Deployment Automation: How to handle data implications of schema changes
We are in the process of working toward an automated deployment process using RedGate's tools for Oracle.A question that has come up is how can we most effectively manage the data implications of s...
SCO Drops All Objects in Target if Pointed to an Empty Source Directory
I've noticed that Schema Compare command-line has a nasty "feature" that will drop all objects from the target even if the source folder (SchemaName) location is completely empty (i.e. has neither ...
Multiple Drop Constraint Statements Generated by SCO...
I'm seeing multiple drop constraint statements generated by schema compare for Oracle (5.1) command line.I have a FK constraint w/ 2 columns. The source does not have the FK constraint, and the ta...
SourceControl for Oracle 4.0.3 Reports Table Difference when LOB storage is included
SourceControl for Oracle 4.0.3 always reports a table difference between the DB and the SourceControl (SVN) repository when LOB storage is included and the table has a LOB segment.There is no actua...
Commit Message - Disragard
Please disregard -- found the answer to this issue.
Was looking for how to post a commit message -- it was right there on the check-in page.