Migrate comparison to different database - same schema

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
Judith
Posts: 5
Joined: Tue 08 Sep 2015 18:00

Migrate comparison to different database - same schema

Post by 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?

alexa
Devart Team
Posts: 2424
Joined: Fri 24 Jun 2011 14:17

Re: Migrate comparison to different database - same schema

Post by alexa » 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

alexa
Devart Team
Posts: 2424
Joined: Fri 24 Jun 2011 14:17

Re: Migrate comparison to different database - same schema

Post by 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.

Judith
Posts: 5
Joined: Tue 08 Sep 2015 18:00

Re: Migrate comparison to different database - same schema

Post by Judith » Thu 07 Jan 2016 15:30

Thanks very much; I will try these.

Post Reply