Skip to main content
WolfShade
WolfShade
Legend
June 6, 2017
Answered

Transferring datasources from one machine to another

  • June 6, 2017
  • 3 replies
  • 6022 views

Hello, all,

I'm in the middle of moving all my stuff from my old, dying development system to my new development system, and in the process I'm also switching from CF10 to CF11.

I've finished the CF11 install, and can get to the CFAdmin page with no problem.  However, I have about 40 DSNs on my old dev system that I need to transfer to my new system, and I really don't want to manually enter everything.

I've seen posts online about taking the old neo*.xml files and "place them where the new install can find them" then tweak another .xml file to re-run the migration wizard.  That didn't work, for me.  It just broke my CF Server.  I restored the original .xml files and rebooted - that at least got me back to where I was.

Are there any other ways with which to xfer all my DSNs from my old system to my new system??

V/r,

^_^

This topic has been closed for replies.
Correct answer Priyank Shrivastava.

When you copy the neo-datasource.xml to the new machine where you are migrating the Datasources. You have to copy the seed.properties as well.

You will find both these files under \ColdFusion\{instances}\lib\

Make sure, take the back-up of existing files, before you replace with old ones.


Hope this helps. However, we recommend CAR package which is way easier.

Thanks,

Priyank

3 replies

K
karma007
Inspiring
August 4, 2018

OK. This does work. But there is a caveat. You will probably find that once you open CF Admin -> Datasources, you will need to add your Database server password for each entry. I am specifically talking about MySQL 5. This maybe different for other databases. This will save you a bit of time head scratching!

K
karma007
Inspiring
August 6, 2018

OK. So, you need to carry out the instructions in the green comment box above. Stop Coldfusion Application service. Rename the new neo-datasources.xml to something like 'neo-datasouces[todays date].xml' (neo-datasources060818.xml) and copy your old neo-datasources.xml file to the same directory, which is usually, C:\\Coldfusion11\cfusion\lib. This just allows you switch back, in case, anything goes wrong.

Then start the Coldfusion Application server. Go to CFAdmin -> Datasources, and you should see all your datasources listed. However, if they are MySQL datasources & you try and verify them, they will probably fail. Go into each datasource and type your MySQL password again. And everything should work!

Good luck!

Priyank Shrivastava.
Community Manager
Priyank Shrivastava.Community Manager
Community Manager
August 6, 2018

Hi,

If you check the above comment, I also mentioned the seed.properties. You have to copy that from old server to new server. Make sure, you take the backup of both the files before you replace it.

Thanks,

Priyank Shrivastava

Thanks, Priyank Shrivastava
    WolfShade
    WolfShadeAuthor
    Legend
    June 6, 2017

    ADDITIONAL:

    I should mention that my old dev system has already been decommissioned and powered down, the hard drive was removed and placed into another system as a slave along with the hard drives from other decommissioned systems, and set up as a network share so that I can copy anything from it across the network.  I cannot load CFServer and access CFAdmin from my old system.

    Should it be necessary to put my HD back into my old machine, I can do that, but would rather not.

    V/r,

    ^ _ ^

    Priyank Shrivastava.
    Community Manager
    Priyank Shrivastava.Community ManagerCorrect answer
    Community Manager
    June 7, 2017

    When you copy the neo-datasource.xml to the new machine where you are migrating the Datasources. You have to copy the seed.properties as well.

    You will find both these files under \ColdFusion\{instances}\lib\

    Make sure, take the back-up of existing files, before you replace with old ones.


    Hope this helps. However, we recommend CAR package which is way easier.

    Thanks,

    Priyank

    Thanks, Priyank Shrivastava
    WolfShade
    WolfShadeAuthor
    Legend
    June 7, 2017

    priyanks97293812  wrote

    When you copy the neo-datasource.xml to the new machine where you are migrating the Datasources. You have to copy the seed.properties as well.

    Och.. wish I had known that.  I would have saved a lot of password re-entering.    But now I know for future situations.  Thanks.

    priyanks97293812  wrote

    Hope this helps. However, we recommend CAR package which is way easier.

    It is my understanding that only Enterprise has the ability to export a CAR.  We are using standard.

    V/r,

    ^ _ ^

    H
    haxtbh
    Inspiring
    June 6, 2017

    If you are using Enterprise you can export all the settings to an archive and import them on the other side. YOu can choose what you want to export, so you can just do the DSNs.

    Its normally in the CF Admin under Package and Deployment > Coldfusion Archive.

    Copying neo-datasource.xml has also worked for me in the past, but I never did that on a production instance.

    WolfShade
    WolfShadeAuthor
    Legend
    June 6, 2017

    Hi, haxtbh​,

    Sadly, we are not using Enterprise.  Just standard CF10.

    V/r,

    ^ _ ^

    rahul_u
    Community Manager
    rahul_uCommunity Manager
    Community Manager
    June 6, 2017

    Take a backup of neo-datasource.xml from ColdFusion11\cfusion\lib. Copy neo-datasource.xml from ColdFusion10\cfusion\lib to ColdFusion11\cfusion\lib. Restart ColdFusion service.

    If It breaks ColdFusion, you can revert back to backup and restart ColdFusion service.

      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices