Copy/Export Datasources to a different CF server

[loke662]

I have a CF MX 7 server, and I am replicating it on a different server to do
some testing.
Server 1 has a bunch of datasources pointing to a bunch of access files. (over
20 datasources)
Is there an easy way to copy/migrate the datasources from one server to
another? (assuming that the access files are copied to the exact path as the
main server?)
Sorry if this has been asked before, I looked around and could not find a post.

[ear011]

Have you received any input on this topic? We experiencing the same situation.
We need to transfer the datasources from the old server using CFMX 6.1 to the
new server using CFMX 7. We tried by copying over the neo-query.xml file, but
that didn't work. We have around 200 datasources to transfer. Your help is
greatly appreciated. Sincerely, Ana

[loke662]

nope. none sofar.

[CWH-Gotee]

I'm running into the same issue myself. Need to move from one server running MX 6.1 to another running MX7 and bring the 80 datasources along. Have you guys made any progress?

[Pat D.]

On the bright side I found this topic doing a search. Obviously the down side
is no answers here yet. I'm also moving 105 datasource definitions. I thought
I could just update the list in the neo-query.xml file but that didn't work.
First it just fixed them by loading in the .bak file. Then I changed both
files in case there was an issue with a date stamp saved somewhere and it cause
the datasource section to not start. oops.

I hope someone has some ideas. Hey Adobe; are you listening? This is how the
government has to do business. I have to have a failover server running with
the same configuration.

Thanks,
Pat

[Abinidi]

There is a file called swandi.in in the C:\CFusionMX7\db\slserver54\cfg that stores the validated DNSs. You will need to migrate that file over as well.

[Pat D.]

Well. So I looked at this file. Gee, that's hardly cryptic at all! As near
as I can tell they've got checksums and a specific order to these things. I
can't see any other link except one-to-one based on ordering.

That means I can't simplify my life by alphabetizing them nor can I make the
change from one MS SQL server (the live one) to another (the backup that would
come up in an emergency where I'd need this machine).

If I'm making this more difficult than it needs to be or someone knows a trick
or two on this please let me know.

Thanks for the insight Michael.

Pat

[JMGibson3]

The neo-query.xml method worked fine for me. In fact I even opened it in
wordpad and made a few Replace All's for the new directory structure. Did you
remember to Stop/Start all 3 Services on the new server? You should also see a
message like this:
01/26 13:31:52 Information - neo-query.xml has been modified . Reloading the
service coldfusion.sql.Executive@176a8c8
in C:\CFusionMX7\runtime\logs\coldfusion-out.log

[dlasley]

Maybe I'm missing something here, but the Archive/Deploy feature seems to fit
what you need:

[url]http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/[/url]
wwhelp.htm?context=ColdFusion_Documentation&file=0 0001759.htm

I've used this to move settings across same-level (i.e. all mx6 or all mx7)
systems*. The only time I've ever hit serious issues using Archive/Deploy is
when I included things I wasn't supposed to and over-wrote certain settings.
Archive/Deploy is fairly customizable, and has worked (for me) on both Windows
and Linux systems.

HTH;
&laz;

*per the docs:
"Note: ColdFusion MX does not deploy Administrator and RDS passwords, nor does
it unpack archives created in previous versions of ColdFusion."

[dlasley]

A quick PS: you may want to get this thread in the Advanced Techniques or ColdFusion Server Administration Forum(s) to get some feedback from more sysadmins and appadmins.

&laz;

[Pat D.]

:o Nope. It's definitely ME that's missing something. This is the first I've
heard of that feature. Guess I shoulda done more reading on the subject. I'll
look into it.

That's why these forums are useful. Even idiots like me who don't read enough
can figure things out.

Thanks!
Pat

[Pat D.]

Well I just tried this out. Or tried to. It wants an Enterprise serial number
and we don't have the Enterprise license. I tried using a development
enterprise license and it goes through some of the motions without actually
doing it. I'm pretty sure there's no way we can spring for an Enterprise
license.

Thanks though,
Pat

[dlasley]

My bad - I forgot that was an Enterprise-only feature (I've never used any of
the other flavors, and I'm more of an admin / engineer and have never had cause
to work with a Dev install or the Pro version). The next time I run a .car
transfer, I'll take a look at the logs and inspect the archive to see if
there's an easy way to pick out what you need and put it into some kind of
shell script. Will post the results here, with a sample script if I can get one
working.

&laz;