Report and system administrators can migrate reports from one database to another in Report Gateway. Migrating reports allows you to associate multiple reports with a database at once without going into each report and adding a new data source manually. This process affects all of the client-specific reports in the database you choose, but reports that already exist on the destination database are not overwritten.
Example
You have created several client-specific reports in a production database, but you have just added a testing database. You migrate the reports using the Migrate button, causing all of your client-specific reports from the production database to be associated with the testing database as well.
To migrate reports to a data source, follow these steps:
1. Go to Admin Settings > Reports.
2. Click Migrate Reports. The Migrate All Reports to a Data Source window appears.
3. In the Platform Type field, select the platform type of the databases you want to migrate your reports between.
4. In the Existing Data Source field, select the data source that currently contains the reports you want to migrate.
5. In the New Data Source field, select the data source that you want to migrate your reports to.
6. Click Migrate.