Skip to main content
Inspiring
December 15, 2008
Question

CF 8 exporting or importing data sources

  • December 15, 2008
  • 3 replies
  • 3260 views
Instead of manually configuring 40 data sources in the administrator, is there a way to import the data sources from another server that already has the data sources configured? We've done a new install of CF 8 on a new server box, and we have a previous version of CF on another server. On that box there are 40 data sources already set up and running. Is there a way to move all these data sources at once? Or do we have to set them up one-by-one on the new box? Thank you for your suggestions.
This topic has been closed for replies.

3 replies

Inspiring
December 15, 2008
sbudlong wrote:
> Instead of manually configuring 40 data sources in the administrator, is there
> a way to import the data sources from another server that already has the data
> sources configured? We've done a new install of CF 8 on a new server box, and
> we have a previous version of CF on another server. On that box there are 40
> data sources already set up and running. Is there a way to move all these data
> sources at once? Or do we have to set them up one-by-one on the new box? Thank
> you for your suggestions.
>

http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:53686

I just read this thread, and you can no longer import neo-query.xml. CF
8 uses different xml files for it's datasources, neo-datasource.xml and
neo-drivers.xml according to the above link.

sbudlongAuthor
Inspiring
December 15, 2008
Is the answer to use Packaging & Deployment in CF 8 Administrator? Let's assume the old version is MX or 7 (I don't know which version, offhand, right now). Can we create an archive file that we can bring into CF 8 and recreate all the data sources from that older version of CF?
Inspiring
December 15, 2008
sbudlong wrote:
> Is there a file on the old CF server that contains all the data source
> information? Maybe we can copy some of that file into its equivalent file in
> the new CF 8 installation on the new server box. Is something like this
> possible?
>

How old is the 'old' CF server?

On all MX generation servers (ColdFusion 6 and up), you are looking for
the neo-query.xml file. This file contains the dsn configurations of a
server.

There maybe differences in the layout of this file from version to
version so I can not guarantee that you can directly export from one to
the another.

If you have enterprise servers you can export and impart CAR -
ColdFusion Archive - files to migrate Administration configurations from
server to server.
sbudlongAuthor
Inspiring
December 15, 2008
Is there a file on the old CF server that contains all the data source information? Maybe we can copy some of that file into its equivalent file in the new CF 8 installation on the new server box. Is something like this possible?