Set Datasource Location???

[jhein]

Is this as simple as going into each report and setting the location of the connection to our prod box or do I have to go through each individual stored proc and change it to the corresponding one on our prod box?

For example I have an OLEDB connection called Justice that is pointing to our test box. Do I simply have to go into that connection and change the database it is pointing to or is there way more to this?

 

[morriskc]

We do not make any changes when going from dev to integ or from integ to prod. We just move the server that the sql.ini is pointed to for Sybase or the alias set up in our client network utility for SQL Server.