Pete Freitag Pete Freitag

Backing up ColdFusion Datasources

Updated on December 01, 2023
By Pete Freitag
coldfusion

If you want to backup datasources on ColdFusion 5 and below on windows, backup the following registry keys:

HKEY_LOCAL_MACHINE\SOFTWARE\Allaire\ColdFusion\CurrentVersion\DataSources
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC

Create two reg files, and then just double click the reg file on the server you want to backup on. If your only using OLE DB datasources, then I believe you only need to backup the first key. Also it may be a good idea to keep a backup of your the entire ColdFusion registry key.

On ColdFusion MX 6 settings are stored in files (typically xml using WDDX) instead of the registry. So you need to backup the files that contain the settings. The file cfusionmx\lib\neo-query.xml stores the datasources.

Update: On more recent versions of ColdFusion the file is called neo-datasource.xml and is still using WDDX as of ColdFusion 2018.

Update Again: You can use a tool such as commandbox cfconfig to export the datasources to a JSON file, and then import them into a different server.


Backing up ColdFusion Datasources was first published on March 18, 2003.

FuseGuard Web App Firewall for ColdFusion

The FuseGuard Web Application Firewall for ColdFusion & CFML is a high performance, customizable engine that blocks various attacks against your ColdFusion applications.

CFBreak
The weekly newsletter for the CFML Community