Devart Forums

Posted: **Tue 29 Dec 2015 23:40**

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?

Posted: **Wed 30 Dec 2015 15:00**

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

Posted: **Wed 30 Dec 2015 15:55**

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.

Posted: **Thu 07 Jan 2016 15:30**

Thanks very much; I will try these.

Devart Forums

Migrate comparison to different database - same schema

Migrate comparison to different database - same schema

Re: Migrate comparison to different database - same schema

Re: Migrate comparison to different database - same schema

Re: Migrate comparison to different database - same schema