Skip to main content
Apr 9, 2015 10:14 PM UTC
Question

Modifying neo-datasource file to change datasource IP to a similar SQL server...

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.

    This topic is closed to new replies. Start a new post to keep the conversation going.

    4 replies

    Inspiring
    Apr 10, 2015 7:50 AM UTC

    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!

    Translate
    Apr 10, 2015 4:37 PM UTC

    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.

    Thanks!

    Translate
    Legend
    Apr 10, 2015 6:12 PM UTC

    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.

    Translate