I am trying to migrate the database to another server for a site using site server 3.0. I have found that I need to somehow modify the \config\site.csc file because the connection string is hard coded in the file. I have also found reference on a technet saying that you can't directly modify a site.csc file, and that I will have to explicitly state the ConnectionString property in the global.asa file. My question is, is this truly necessary (isn't there someway to modify the file), and if it is necessary, how do I do it.
Here's the reference (do a Find for "site.csc"):
http://technet.microsoft.com/en-us/library/bb687458.aspxThanks in advance!