Updating a database on a different server

[matthisco]

I currently publish news articles using CF to an MS SQL Server 2005 Db. I'd like to publish them to my website if possible, which is hosted on a dedicated server hosting package, where I have remote access to admin the server, IIS settings, DB settings etc.

Rather than mannually update the website and post the article twice, is there a way I can get each server to talk to one another and post to the external webserver somehow?

Could I perhaps export an xml document or database dump?

Thanks in advance

[Tariq_Ahmed__ACP_]

There's a number of ways you can tackle this.

If you have access to the Datasource admin, you can set up a Datasource to the remote Database (as far as a CF datasource is concerned, it's just basically just a combination of server name/IP, username, and pw).

So on the server that you post your news to, you can do an INSERT to your local datasource, and remote datasource.

If you don't have that kind of access... then ya you can have one machine pull data from the other using CFHTTP and grab some XML from the source. Or create a CFC that acts as a Web Service on the remote server (your website I guess), and you call a function and pass the details of the news.

[matthisco]

Thanks for your reply.

Could you please tell me how I can setup a datasource to the remote server?

Thanks again

[matthisco]

I've managed to use cfftp to ftp to my site, are there any security issues I need to be aware of by using this method?

Thankyou