The answer should have really been to restore to the former database to the new database using a different name.
Then the new database should have used the same database that all the reports were using.
This would need you to update the old URLs in the database, including the various My SQL database tables.For smaller websites, this can be managed by manually making the changes.I have a Crystal Reports 2008 user that has over 100 custom developed reports.The reports all query Sql Server databases (SQL 2005).Since the update operation specifies operator, which isolates the update operation and disallows yielding during the operation.
This isolates the update so that no client can see the updated documents until they are all processed, or an error stops the update operation.Mass Update can help you update all records with certain values. After clicking the Mass Update option under the Tools menu, you will be presented with a pop-up window where you can choose a field to be updated, and enter a new value for this field.During this step, if your field is a selection field, please make sure that you're using the same spelling as your value options in your database design. During this time, you may proceed to use the database.Migrating your Word Press website to a new URL and unsure about where and how to update old URLs in database?Do you want to skip the tedious process of manually changing the URLs?PILOTS stands for: Published International Literature on Traumatic Stress.