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

Forum|Forum|11 years ago
April 9, 2015
4 replies
828 views

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 has been closed for replies.

H

haxtbh

Inspiring

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!

A

Anonymous

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!

S

sdsinc_pmascari

Legend

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.

Remix with Firefly Community Gallery

Thousands of free creations to fall in love with and remix in Firefly.

Explore now

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.