Copy CF datasources to other machines

I'm looking for a method to copy ALL CF datasources from one machine to other machines.
This includes password and all settings that one would normally configure inside the CF Admin.

LVL 25
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

James RodgersWeb Applications DeveloperCommented:

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Gurpreet Singh RandhawaCEOCommented:
you can also copy the neo-datasources.xml file to some other and after a fresh install or in anotehr install, make a backup of the original and replce the one u have and it works, i had it working
dgrafxAuthor Commented:
Thanks guys

I couldn't get the functionality to work correctly.
Main issue was that file was unreadable (according to CF).
Plus the main drawback would be that I'd need to do this on all machines.

Question for both of you
Say we go with copying the new-datasources file - what needs to be done for the dsns to be recognized?
Restart the CF Server?
That would be a drawback as well - restarting the CF Server.

Let me know ...
Gurpreet Singh RandhawaCEOCommented:
the neo-datasources.xml the file you will copy will have all info attached to it, once you all DSN's you will be able to connect them,

I am unable to test here as i had lost all my mysql databases while migration, so i had to recreate them for re-work

but it should work
dgrafxAuthor Commented:
well - my question "do you need to restart CF" goes unanswered ...

But according to Google you do need to restart.

Thanks Guys ...
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ColdFusion Language

From novice to tech pro — start learning today.