Batrch Update Verify Database

[DBAFrog]

We use CR 10 (not enterprise) for approx. 6 users and moved our reports 200+ from one server to another for a migration. The database structure mirrors the old server, but every report we open is sending multiple 'Verify Database' msg boxes.

The data is there, the reports run, and we can manually verify the complete table structure. But, that is time consuming and some of the report throw the verify db error again.

IS there a batch\mass updater tool for fixing this? We cannot be the first company that has had to move rpts like this.

any help appreciated,

Brad

------------------
Curious by Nature,
Linux by Design

 

[DBAFrog]

Followup;
I've found that our ODBC(RDO) rpts are the ones with the verify db msg. If I set datasource to ADO, then the rpt runs fine.
Then, if I change the datasource back to ODBC the rpt opens correctly.

...is there a batch tool to move the datasource?

Brad

------------------
Curious by Nature,
Linux by Design

 

[AndrewBaines]

It could be written - not complex, maybe a day's work.

Andrew Baines

http://www.pursuittechnology.co.uk

 

[MJRBIM]

I think that RPT-Inspector does this....

We tested it for a while, but didn't use it because it wouldn' run on our managed-workstations.