Hi Cognoise friends,
We are changing the backend reporting database server from ServerA to ServerB.
All the required databases (with all data) from ServerA has been copied to new server (ServerB).
I need to test everything that may impact the underlying reports that had ServerA databases as source after that server is replaced by new server (ServerB).
I'm not sure if:
creating a new datasource with ServerB connection string then replacing the datasource in Framework Manager and republishing the package
is better than
changing the Connection string in the existing datasource and republishing the package?
What are the Best practice to follow to implement this change without affecting the existing reports in Production? (step by step guidance is greatly appreciated
Note: we do have Cognos Dev and Cognos Prod.
Thank you in advance,