change databases from dev to prod

Discussions related to Crystal Reports development.

Moderator: Lisa Ennis

Post Reply
czentman
Posts: 157
Joined: Tue Dec 02, 2008 12:02 pm

change databases from dev to prod

Post 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?
Lisa Ennis
Posts: 84
Joined: Thu Sep 11, 2008 1:57 pm

Re: change databases from dev to prod

Post 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.
Lisa Ennis
Senior Report Developer
SoftPro
Post Reply