I'm not sure how to attack this.

We have a production database (Oracle), and we also have the same database replicated into a Managed Reporting environment. The original database is not in managed reporting.

To verify that our replication works properly, I need to write a little fex to look at a field in the production database, then compare it to the same field in the replicated database. Can I do that on one fex? I'm sure I'll need to use a hold file in there somewhere. Thanks in advance.

This message has been edited. Last edited by: Kerry,

This really brings back memories. In my first installation we had multiple identical data bases in different geographic locations. We solved this by creating a separate master file for each, with a 2 letter prefix in the Synonym name to identify which database that MFD was pointing too.

i.e. Norfolk's table CAR was NOCAR, while Miami's was MICAR.

Then just do a MATCH file report to find the differences between them.

You might want to even go so far as to create a separate application to keep these 'special' MFD's in. There is no limit I know of as to how many MFD's can point to the same table.

Good suggestion. These databases are on 2 different reporting servers, so that part has me confused on where to place my MFDs.

You should be able to do one of two things here.

1. Create a master for the tables as per roberts suggestion.

2. Create a synonym of the master on the other reporting server.

Either way you will have two masters to access the two tables in the two DB's.

Mike, databases are not 'on' reporting servers. While they may reside on the same physical box, as long as you set up the client on the reporting server to access both databases, have a different MFD for each of the two tables, you will have no problem.

That installation I refered to before, one reporting server had connections, and MFD's for 13 Oracle data bases in 13 different locations in the US, 6 SQL Server data bases and a DB2 database in Copenhagen Denmark.

With WebFOCUS, just as one browser can access multiple web servers, each WebFOCUS web server can access multiple Reporting Servers, each reporting server can access multiple databases. I won't even start on the possibilities with EDA to EDA connections here :-)

Good info, thanks a lot!