I am looking to publish a workbook to the server, from my local environment. A coworker gave me a brief list of steps and I am getting tripped up during the process. We have a live connection to a data source and it breaks often when we migrate over. I have listed the steps below, please let me know if there is a better way to do this or a more comprehensive list. Thanks
Save the filename.twb as a new folder with a different filename.
Open filename.twb from the new folder.
Change the data visualization label to correspond to the new environment.
Run the scripts in the new environment.
Add a SQL Server data source with information from the new environment (It should have the same schema as the old one).
Replace the old data source with the newly created data source.
Set the different data types to their desired values and format (currency, date …)