Migrate comparison to different database - same schema

Migrate comparison to different database - same schema

Postby Judith » 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?
Judith
 
Posts: 5
Joined: Tue 08 Sep 2015 18:00


Re: Migrate comparison to different database - same schema

Postby alexa » 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.
alexa
Devart Team
 
Posts: 2170
Joined: Fri 24 Jun 2011 14:17

Re: Migrate comparison to different database - same schema

Postby Judith » Thu 07 Jan 2016 15:30

Thanks very much; I will try these.
Judith
 
Posts: 5
Joined: Tue 08 Sep 2015 18:00


Return to dbForge for Oracle