...
- Run Find it EZ software
- Click Replace, Crystal Reports , Data Source Connection or Qualified table names.
- Create New Project
- Next
- Add or change the path to your crystal reports.
- Next
- Create too a new folder so you have a duplicate
- Next
- Choose the new ODBC Connection (should be called Synergetic instead of SynergyOne) and username and Password.
- This actually needs to happen for all Extra Finance and Finance Database
- eg. SynergyOneFinance, SynergyOneFoundation, will all point to Synergetic now
- Check Leave the DSN qualified Table name as its currently set
- Next
- Convert
- This will Generate a Excel report of the conversion.
...
- Run the report as usual
- Possibly make some test changes to the new Single Database instance to confirm that data is been pulled from the correct source.
- Once Confirmed reports are running, archive non Single DB report and replace the site folder reports with the new Single DB reports that were converted.
Known Problems
- If the account this is run under has high level access to multiple database schemas (eg Foundation and Main Synergetic), the resultant database link appears to be randomly associated to either schema