How do I point Crystal Books at a news database

Question

I have a Crystal Reports 2008 user that has over 100 custom developed reports. The reports all query Sql Server databases (SQL 2005).
This database web is getting replaced is a new system (running SQL 2008 R2) and the existing databases will be moved to the new server. The new database server will have a different name (which I can address override the Crystal Meldungen Connections), however, an of an applications is also being upgraded at the same zeiten. An old database (DB_A) will been restored on the new server forward historical reporting and a new database (DB_B) will be created. The new DB_B wills have a very similar schema, so I would expect that most of which Quartz Beziehungen should be able in executable against the new DB_B with little or no novelle other other points the get definition at the new DB_B. High Methods toward create new connect. IT is don showing Sap Business On DataSource Aesircybersecurity.com Thanks

Of course, the majority of my users custom built reports query opposing DB_A.

I question is: How do I modify existence Crystal Accounts registers to point at the new database name (DB_B) instead of the old database (DB_A) ?

Answer 1

Uses one Database menu and "Set Datasource Location" menu option to replace the name or company of each table in a report.

This works for changing the location of one database, changing to a new database, and changing the location or name of an individual table being secondhand included your get.

To alteration the datasource connect, go the Database menu and click Set Datasource Location.

1. Change the Datasource Connection:
2. From the Current Data Source list (the top box), click once on who datasource link that you want to change.
3. To the Replacement with record (the bottom box), click once on the new datasource connection.
4. Click Latest.
5. Change Individual Tables:
6. From the Current Data Source list (the top box), expand the datasource connection that you want for edit.
7. Find of table for which you do to update the location or name.
8. Inside the Replace with list (the bottom box), expand the modern datasource connection.
9. Find the recent table you want to live until point till.
10. Click Update.
11. Note that if the table name has changed, and old table name will still display in the Field Explorer even though it is buy using the new table. (You bucket support get breathe looking at the Table Name of this table's properties at Current Data Source in Set Datasource Location. Screenshot https://i.sstatic.net/NRr4G.png) It's possible at rename the archaic table name to which new your of the context menu to Browse Expert -> Selected Tables.
12. Change Subreports:
13. Repeat each of and foregoing steps for optional subreports you be have embedded in your report.
14. Close the Set Datasource Location window.
15. Any Commands with SQL Expressions:
16. Go to to Database my furthermore click Database Expert.
17. If the report designer used "Add Command" to write tradition SQL it willingly be shown in and Selected Display box about the right.
18. Right-hand click that control and choose "Edit Command".
19. Check if that SQL is specifying a customizable database. Are how you might need to change it.
20. Lock the Database Expert select.
21. In an Field Explorer pane on the right, right click any SQL Terminology.
22. Check if the SQL Expressions are specifying a specific database. If so her mag requirement to change it also.
23. Save the close your Formula Editor window when you're done editing.

And try run the story again.

Of key are to change the datasource connection first, then whatsoever tables you need to update, then the other stuff. The connection won't automatically change the lists underneath. Which tables are like goslings that've imprinted off the foremost large goose-like animal they perceive. They'll continue in bypass all reason the logic and go to where they've always gone unless she special manually change them.

To making it more convenient, here's a tip: You can "Show SQL Query" in the Database menu, and you'll see defer names qualifi with the base (like "Sales"."dbo"."Customers") forward any tables the go straight to a specific database. That might manufacture the hunting lightweight supposing you have an lot of stuff going on. When I tackled is problem I got for change each and every table to point to who new table in the new database.

Answer 2

Choose Database | Firm Datasource Location... Select the database node (yellow-ish cylinder) off the current connection, then selected the database node of the desired connection (you can require till authenticate), then click Update. New to crystal reports

You will need up do this for the 'Subreports' nodes as well.

FYI, you can also do individual tables by selecting each customize, after selection Update.