Skip to main content
M
matthisco
Inspiring
February 22, 2009
Question

Updating a database on a different server

  • February 22, 2009
  • 3 replies
  • 718 views
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
This topic has been closed for replies.

3 replies

M
matthiscoAuthor
Inspiring
February 23, 2009
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
M
matthiscoAuthor
Inspiring
February 23, 2009
Thanks for your reply.

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

Thanks again
T
Tariq_Ahmed__ACP_
Participating Frequently
February 22, 2009
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.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices