Posts
Sort by recent activity
Global Temporary Table support
Any plans to support global (or private) temporary tables i SCO?
Support for NLS_SORT
HiDoes Schema Compare for Oracle support setting NLS_SORT=binary for the dotConnect driver? We are having some inconsistencies between developers regarding sort in e.g. constraints. Thanks
Reverse engineered DB, shows changes
Just reverse engineered a DB into source files and upon recomparing the repo, we get 500+ with differences. Using the PL/SQL Difference Viewer, we see the following characters in the diff in the st...
Null reference exception SCO v5.1.0.1030 /DMS-36240
HiTrying to create an initial update to a folder (15000 objects) from an existing DB and receive a null reference exception. I'm using v5.1.0.1030 of SCO. Same problem if I uncheck 'Deploy all affe...
Trigger difference, but SCO displays none /DMS-36184
HiWe a series of triggers, which exists in both DB, but SCO says there's a difference. When looking in the diff, there's none. Any idea why this is happening?
Type operation order /DMS-34058
It seems SCO order TYPE operations wrongly in deployment scriptsI have used SCO to create a deployment script for 2 types.See attached file SCO_depend_otype_depl_example.sqlOne of the types is depe...
Triggers and WHEN clauses /DMS-34056
SCO has a problem with consistently extracting WHEN clauses of triggers.E.g. for trigger h0915.DPFW_LOGHANDLER_ID_TRGSCO claims the triggers are different. In the visual tool displayed as:Script le...
SCO Options /DMS-34051
Can SCO be configured with the following options:
Ignore cache?
Roles?
Context?
Directories?
Materialized View and Reduced Precision /DMS-34050
SCO does not consistently extract properties of MV for creation scripts.E.g.The use of REFRESH with specific timestamp is a separate issue.Here i concentrate on 1 other error around the 'WITH REDUC...
Materialized View and timestamps /DMS-34049
SCO include state info of the instance of MV into its metadata in the form of the current refresh time (in relation to log files). That is very inconvenient For MV present and identical on source a...