Highlighted

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

New Here ,
Apr 09, 2015

Copy link to clipboard

Copied

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.

Views

563

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

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

New Here ,
Apr 09, 2015

Copy link to clipboard

Copied

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.

Views

564

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Apr 09, 2015 0
Advocate ,
Apr 10, 2015

Copy link to clipboard

Copied

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!

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 10, 2015 1
New Here ,
Apr 10, 2015

Copy link to clipboard

Copied

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!

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 10, 2015 0
Engaged ,
Apr 10, 2015

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 10, 2015 1
haxtbh LATEST
Advocate ,
Apr 11, 2015

Copy link to clipboard

Copied

Yeah I have done this before. Like I said, just the data source and you should be fine.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 11, 2015 0