This content has been marked as final. Show 2 replies
It depends upon couple of factors like:-
- If your workbook is using published data sources , then you have to simply download it from Test environment , open it in Desktop and change your sign-in to Production and simply publish it in the relevant folder. Now for this approach to work, name of your published data source has to be same in both the environment else it will not automatically pick up the connection in production. So make sure that connection information is same in both the environments.
- If your workbook has local / embedded data source , you have to change the connection information like server name , port number , login id and password to connect it to production and after that ideally it should be pointing to your production database.
Let us know if it helps or in case you face any issues.