|
|
 |
RE: FN-FORUM: XML Question
date posted 10th January 2007 11:03
Hi Andrew and Dave
Thanks for getting back to me so quickly.
Your right I should have given more detail. (Dave) The other website that needs
updating is in another country on another server completely separate. The
customer is looking to exchange data from his website with another website
dynamically so the information is updated quickly.
I am assuming the other databases are not running SQL server, hence XML, however
the developer from the other website is asking the data to be in XML format.
If XML is the answer how does it get parsed from one server to the next?
Thanks
Anthony
Anthony,
You might be able to do this automatically - have a look into the replication
features of SQL Server (I assume this is SQL Server we're talking about). Are
the databases on the same server, or same location, or completely separate
servers in different locations? What version of SQL Server are you using?
Another option might be using triggers on tables to update the other database,
but I'm not a big fan of triggers (although they're useful in certain cases) and
it will depend on the location of your databases.
Another question, while I think of it: how are you updating the database?
If it's a series of SQL statements (say) then can these also get run against the
other database at the same time?
Cheers,
Andrew.
--
_____________________________
Andrew Bibby
I.T. Solutions Ltd
http://www.itsolutions.uk.com
-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of [EMAIL REMOVED]
Sent: 10 January 2007 11:15
To: FN-FORUM / [EMAIL REMOVED]
Subject: FN-FORUM: XML Question
Dear Forum
I think XML Parsing is the answer here but I would like to check with you guys!
I have a website which is being updated and has a SQL database with the updated
information.
There is another website which will require the same updates as this one and will
need to be updated constantly through out the day.
I would imagine with the amount of updates it would need to be done automatically.
Can anyone give me any directions?
Anthony Rome
Web Designer
LME Ltd
The Old Court House,
24 Church Street, Wellington, Shropshire, TF1 1DG
(T) 01952 25 24 23
(F) 01952 25 24 22
(W) www.lme.ltd.uk
--
Freelancers, contractors earn more with Prosperity4 Call 0870 870 4414 or visit
www.prosperity4.com and benefit from Inland Revenue approved expenses today.
To advertise here: http://www.freelancers.net/advertising.html
--
Freelancers, contractors earn more with Prosperity4 Call 0870 870 4414 or visit
www.prosperity4.com and benefit from Inland Revenue approved expenses today.
To advertise here: http://www.freelancers.net/advertising.html
|
|
|
