March 11, 2006 at 1:08 pm
Hi,
I red this article : "Servicing Internet Websites.com" from Brian Kelley on November/December issue of SQLSERVER STANDARD magazine.
Now I wonder what is the best way to PUSH data (only) from our production database (internal Network) into our web database (DMZ) ?
SQLXML (for xml, sp_xml_preparedocument, opeenxml) ? Pros ans Cons ?
DTS ? Pros and Cons ?
Replication ? pros and Cons ?
bcp out / bcp in ? Pros and Cons ?
thank you
Danny (alias calico)
March 12, 2006 at 8:22 am
Hi,
My previous message was a little vague ! I will reformulate my question:
I wonder what is the simpliest way to PUSH data (only) from our production database (internal Network) into our web database (DMZ) ?
IF :
Our web database must be isolated from our production database
smal amount of data will transfered (300 to 1000 records)
synchro and latency is not a problem (we can push data every 1 or 3 hours)
we don't want to modify our production database
Our production databse is SQL2000 ED and our web database is SQL2005 Express
XML ? DTS export ? Replication ? bcp ?
thank you
Danny (alias calico)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply