Crystal Reports??
What method are you using to access the database (OLEDB, ODBC, Native Driver)?

Are the tables in the two databases exactly the same? If they are then no problem, the SQL statement generated by Crystal will work against which ever server you login to. IE, there may be no need to change a thing.

You might want to check out the Database -> Set Location menu item.