RE: FN-FORUM: XML Question

date posted 10th January 2007 10:42

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