What is the manual connectionstring format?

DenisJCilliers

Your documentation only provides a TNS format for the connection string.

What is the format for the Manual connection string for a snapshot

sco /source System/pass@TEST{SCHEMA_A} /snapshot SourceSnapshot.onp

Peter_Laws

Hi DenisJCilliers,

To target a snapshot using the commandline, the format is as you detailed, though I would recommend a full path for clarity sake.

To modify the documentation example to match your example:

sco /source System/pass@TEST{SCHEMA_A} /snapshot "C:\Snapshots\SourceSnapshot.onp"

DenisJCilliers

DenisJCilliers

Sry the command was wrong I needed to add a colon

"C:\Program Files\Red Gate\Schema Compare for Oracle 6\sco.exe"  /source:USER/USER_PASS@XE{SCHEMA} /snapshot C:\Agent1\_work\100\s\output\Target_SCHEMA_1.0.0.21.on

But there does seem to be an issue with TNS in Powershell 
As I now get 

Schema Compare for Oracle version:6.0.23.1366: activated, serial number: 389-739-884494-CF6E
Schema Compare for Oracle Command Line - Product version: 6.0.23.1366
Error: No TNS Entry for XE found, trying to connect using Oracle home
OraDB21Home1
Populating database
Error: Error while trying to retrieve text for error ORA-12154
70

DenisJCilliers

Also tried direct connection connection

"C:\Program Files\Red Gate\Schema Compare for Oracle 6\sco.exe" /source USER/USER_PASS@server:1521:service{SCHEMA}/snapshot C:\Agent1\_work\100\s\output\Target_SCHEMA_1.0.0.21.onp

With this I also get error

Schema Compare for Oracle version:6.0.23.1366: activated, serial number: 389-739-884494-CF6E
Schema Compare for Oracle Command Line - Product version: 6.0.23.1366
Populating database
Error: ORA-01017: Message 1017 not found; No message file for product=RDBMS, facility=ORA
70