Activity overview
Latest activity by llerrac
Also relating to the example above
The ocp driven command should look like this:
"C:\Program Files\Red Gate\Schema Compare for Oracle 3"\SCO.exe /project "C:\Temp\redgate\TC1\db1 to db2.ocp" /report:"PreDeploy.html" /reporttype:Interactive
Though in my case I get:
Automation License: in trial, expires 22-8-2013 6:08:15
Checking that DataSources can be parsed
Reading dependency information
Error: Can not obtain Oracle client information from registry. Make sure that
Oracle Client Software is installed, or use Direct mode of connecting to server.
- while I know my registry setting is correct.. i have had to check it enough times.
I do have a reg setting for XE and one oracle 11g though. I suspect the above is due to the XE entry.
*it works using the UI*
Any thoughts?
Thanks
Alex / comments
Also relating to the example above
The ocp driven command should look like this:
"C:\Program Files\Red Gate\Schema Compare for Oracle 3"\SCO.exe /project "C:\Temp\redgate\TC1\db1 to db2.ocp" /repor...
Out of interest.
where the above example gives {schema} for the TNS log in, use a standard tns logline commmand line and that seems to connect.
eg user/password@sid:port/schema
As for the SVN schema, using "{schema}" fails as does "/schema" , "\schema" , "schema"
eg
C:\Versioning\SVN4\testschema
error:
Schema Compare for Oracle: in trial, expires 22-8-2013 6:13:11
Automation License: in trial, expires 22-8-2013 6:08:15
Error: Missing schemas from DataSource string C:\Versioning\SVN4:testschema,
startOfSchemas = -1, endOfSchemas = -1
I may be being daft. / comments
Out of interest.
where the above example gives {schema} for the TNS log in, use a standard tns logline commmand line and that seems to connect.
eg user/password@sid:port/schema
As for the SVN schem...
Thanks for the reply
The error pops up every time unless I log in as user with a lot of rights. I am not a DBA.
I was just wondering what access rights your tool requires(what you need to search), then I can ask our DBA's whats up.
I can attach a few more logs tomorrow. I did restart the software last time a few times. I saw identical as such, faults logs when i logged in as a user which had only rights across the schema(and all referenced objects in schema) I wished to compare. I presume a schema compare user would require some more rights, if for instance I was to create a user/role specifically for the schema compare tool to login as.
Thanks alex / comments
Thanks for the reply
The error pops up every time unless I log in as user with a lot of rights. I am not a DBA.
I was just wondering what access rights your tool requires(what you need to search), ...
Hi
Thanks for the reply / comments
Hi
Thanks for the reply
sco.exe Missing schemas from DataSource
I trialing out redgate for Oracle.
I am testing the TC connection and running the comparisons by hand.
from redgate TC guide, i wish to run command line compare with what I have in SVN
So guide rea...
Error "Object reference not set to an instance"
Hi
I am trialing out the Oracle suite. Using the UI at the moment. I aim to use command line
I compare a largish schema from a database. Its just one schema of many in the database, they are all i...