Best way to submit a query recordset to a remote server

Question

Hello, everyone.I've been tasked with a project that will involve querying a table on one server, then sending the data to a remote server that will take the data and insert it into another database (the two db cannot communicate directly with each other.)I've never had to do something like this, before.  What is the best way to achieve the desired results?  Is there a way to "submit" a query (anywhere from 1 to 5 records at any given time) to the remote server without incorporating WDDX?CF9 environment, soon to be CF10.V/r,^_^

WolfShade · Accepted Answer

WolfShade wrote:... querying a table on one server, then sending the data to a remote server that will take the data and insert it into another database (the two db cannot communicate directly with each other.)So, you have 4 servers: CF1<=>DB1 and CF2<=>DB2. What about CF1 bypassing CF2, and inserting the data to DB2?Hi, @BKBK,Not permitted.It's kind of tedious, but what I've worked, so far, is to have CF1 select data from DB1, SerializeJSON the data, use cfhttp to POST the data to CF2.THEN, CF2 DeserializeJSON the data back into a query object and insert that into DB2.Unless you think there's a better way to do it?V/r,^_^

Carl Von Stetten · Answer

What is running on the remote server? ColdFusion, .Net, PHP, Ruby, etc.? Or is the remote server the other database server?-Carl V.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded