If I modify the file to point a data source database to a similar SQL server hosting a copy of the same database, can this work without breaking CF?
CF version: 9 standard.
From experience it doesn't cause any major issues. I would recommend just using the CF admin if you are only doing 1 or 2, although I have done a bulk find and replace in the neo-datasource to quickly change the source of a SQL database. Username and passwords stayed the same during the temp migration so it all worked out but I would say you may have trouble with changing passwords as they are obfuscated.
Just remember, back it up first before you change it!
So you have done it before? While googling the issue someone said something like an encryption issue but I guess that might be because of that password issue.
I'm unable to access the admin page as it keeps showing up as a blank page. I just need to do 1 change (just the ip address) to point it to a copy of the same database in a new SQL server. 'll definitely backup any files that would be changed.
I have done this multiple times on almost every setting except for the password. Never had any problems. Just be sure you're Find/Replacing the correct items. Make a backup of the original file. Once done, restart CF and you should be good to go.
Yeah I have done this before. Like I said, just the data source and you should be fine.