Rahul, I think I understand your question, but let me know if I'm off here. You want to deploy content onto a server you have outside of your local network that has only Access as a DB. The content is from your local intranet server running SQL Server 2000. Is this right?
If so then, I would suggest two options. First, if your department has the funding and you're running SQL Server 2000 Enterprise Edition, buy another license for the DB server and use replication to accomplish your goals. I'm guessing from your email this is not an option. The other suggestion I had is more along the lines an XML based solution. Create a scheduled process based on how often you want to update the data on the internet server from the intranet server. Have the process query the intranet server and return your desired data via XML (i.e. - using AUTO XML). Now you have an XML repository, if you may. Then you can query these docs via Xpath, or if you wish use an API like soXML to query the docs with SQL. Since you'll have to query specific docs instead of a database, you might want to use Access to create a mapping so that you know which docs to query when you are looking for data. Another option would be to do a mapping in XML. Since you don't have a strong replication service like the one in SQL Server, the obvious weak point in this design is the scheduled process. This is just the idea that came to mind while reading your email. It still needs a lot of work but I hope it helps. -Brian LeGros -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, January 31, 2002 1:27 AM To: [EMAIL PROTECTED] Subject: [cf-xml] Syndication -off topic Hi all I am pretty new to XML in the sense that I have not yet been able to deploy any appln involving XML. But I believe there is a project for me now . What my problem is that we have a database (SQL Sever 2000) on our local intranet ...we used to deploy our content on that datbase.But now there is a need that we wanna replicate the content of the database on an internet server from where some applns will be using that data .The database changes on a daily basis & we need to update the internet server (running on Access) with the database tables on the intranet (behind a firewall) I smell the sense of using XML here but am really not getting any start due to my lack of practical exposure.. I just wanna ask whether what I am asking is really possible & plz cud any one help me in finding some stuff which maybe useful in achieving what I am looking for !!! thanks Rahul -----------------------+ cf-xml mailing list list: [EMAIL PROTECTED] admin: [EMAIL PROTECTED] home: http://torchbox.com/xml -----------------------+ cf-xml mailing list list: [EMAIL PROTECTED] admin: [EMAIL PROTECTED] home: http://torchbox.com/xml
