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?
Migrate comparison to different database - same schema
Re: Migrate comparison to different database - same schema
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
https://www.devart.com/dbforge/sql/stud ... ompare.htm
https://www.devart.com/dbforge/sql/stud ... d_line.htm
Re: Migrate comparison to different database - same schema
Also, you can open the *.dcomp file with some text editor and change the schema name in the following tags:
and in the <ComparedObjects> tag.
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>
Re: Migrate comparison to different database - same schema
Thanks very much; I will try these.