Command Line compare without a project?

amorts

Hi,

I am really familar with the SQL Server version but new to the Oracle one.

I had some really good results in the past writing a generic batch file to carry out a compare between db1 and db2 where db1 and db2 where parameters. I then had a calling batch file which called the compare and drove the values for db1 and db2.

This was simple and easy to maintain.

It appears in the Oracle version you need to have a project file pre-created to run a command line compare. Is this right?

Eddie D

Hi, thank you for your forum post.

You can either use a project file or specify each data source.

The syntax for specifying each data source is as follows:

sco -source System/pass@TEST{SCHEMA_A} -target System/pass@my.host.com/PROD{SCHEMA_A}

The help information available HERE contains further advice.

Many thanks
Eddie