accessing two different datasources

[webCFDev]

I need to connect to 2 dfferent datasources that are in two different servers.
Example:
I need to move data from one table on server 1to a table (whith the same
structure) on server 2.
They both have different datasource names.
So, content managers working on the development server(server number 1)
should be able to click on a link and push all the data on the table to stage
server(server number 2).
Any thoughts?

[MikerRoo]

Insufficient detail was provided -- starting with what DB system you are using.

Here are some options:

Set up DTS job(s). You can trigger these from cold fusion.

Or buy one of the many third party tools for this purpose. Red Gate SQL
bundle, for example.

Or set up replication.

Or do a custom merge all in CF.