Page 1 of 1
change databases from dev to prod
Posted: Wed Mar 04, 2009 11:39 am
by czentman
I need to change databases now as we're going live from the dev db to the prod one. Does anyone know how to change the databases without changing anything else in the report?
Re: change databases from dev to prod
Posted: Wed Mar 04, 2009 12:29 pm
by Lisa Ennis
If you are not currently connected to the new database, open a report and then select Database, Database Expert. Create a new connection using OLE DB(ADO).
Once you are connected to the database, right click the connection and add it to your favorites, it will make it easier to change multiple reports. Once it is added to your favorites, you won't have to create the connection for each report.
For each report that needs to be changed, select Database, Select Datasource Location.
In the Current Data Source (top window), highlight the Server name of the current connection. Then in the Replace With (lower window), highlight the Server name of new database. If both databases are on the same server, you will need to expand the tree so that you can see the database names and select the server with the new database. Once you highlight the new database, click the Update Button on the right side of the window.
If you have subreports, you will need to repeat these steps for the subreports listed in the Current Data Source window as well.