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
Tagged:

Answers

  • 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"
    Kind regards
    Peter Laws | Redgate Software
    Have you visited our Help Center?
  • DenisJCilliersDenisJCilliers Posts: 19 New member
    edited March 29, 2024 3:04PM
  • DenisJCilliersDenisJCilliers Posts: 19 New member
    edited March 29, 2024 2:56PM
    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


  • DenisJCilliersDenisJCilliers Posts: 19 New member
    edited March 29, 2024 3:03PM
    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

Sign In or Register to comment.