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?
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?