Migrate comparison to different database - same schema

[Judith]

I have set up a dcomp file with 16 comparisons of custom SQLs. It compares two Oracle databases that are in our Test environment. Now I want to run the same comparisons against another copy of the databases in our SIT environment. The databases are structured the same, only the data are different.

I cannot change the connection or all the mappings disappear. I tried instead to change where the tnsnames.ora entry points - leaving the name the same and not touching the dcomp file - and that resulted in one error for each comparison, ORA-00942: table or view does not exist.

How do I do this?

[alexa]

You can explicitly specify synchronization options in the command line. Please see the following:

https://www.devart.com/dbforge/sql/stud ... ompare.htm
https://www.devart.com/dbforge/sql/stud ... d_line.htm

[alexa]

Also, you can open the *.dcomp file with some text editor and change the schema name in the following tags:

Code: Select all

<Source Type="Database"> <Schema> SOURCE_NAME </Schemas> 
<Target Type="Database"> <Schema> TARGET_NAME </Schemas> 
<Schemas> <Object SourceName="SOURCE_NAME" TargetName="TARGET_NAME" ... /> </Schemas> 

and in the <ComparedObjects> tag.

[Judith]

Thanks very much; I will try these.