How can we help you today? How can we help you today?

What is the manual connectionstring format?

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
DenisJCilliers
0

Comments

4 comments

Sort by
  • 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"
    Peter_Laws
    0
  • DenisJCilliers

    DenisJCilliers
    0
  • 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
    0
  • 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

    DenisJCilliers
    0

Add comment

Please sign in to leave a comment.