Activity overview
Latest activity by eandrews
Redgate support has looked into my particular issue and it appears that it has something to do with our "RELY DISABLE" statements we are using to identify foreign keys but disable them. This is being done to provide information to the optimizer without having the engine enforce the rule.
It appears to work correctly with multiple comparisons on tables not utilizing this particular feature. / comments
Redgate support has looked into my particular issue and it appears that it has something to do with our "RELY DISABLE" statements we are using to identify foreign keys but disable them. This is b...
I figured out that there is a "Ignore Storage" option as part of the project options when executing the compare. When this is not selected the tablespace as well as many other storage parameters are included in the compare and scripts.
However, there still appears to be an issue when comparing the files against the database. In my case I lose the partition information even though the information is in the file being used as the source. / comments
I figured out that there is a "Ignore Storage" option as part of the project options when executing the compare. When this is not selected the tablespace as well as many other storage parameters a...
Anyway to Include Tablespaces
Is there any way to include Tablespaces in the comparison? We currently store Indexes in a separate tablespace from the tables and this doesn't appear to be considered in the comparison.
Any other...
Multiple Comparisons using Folder as Target
Is it possible to keep a Script Folder up to date using Schema Compare 3 for Oracle?
I used Schema Compare to create the Script Folders. I then went an created a new table in the Oracle database, ...