Help, Transferring XML data under SSL

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: jimb (spam_at_spamity.spam)
Date: 09/19/04 

Date: Sun, 19 Sep 2004 15:07:04 GMT

I need some advice on how to securely transfer data between two servers.
Here is the situation. We have two sql servers that hold student data.
I have full access to my sql server, but only write access to the main
sql server on campus. I hope to use XML and SSL to transfer student
data to the main server.

As for generating the XML, I'll have an asp.net page set up in a secure
directory that will generate the data in xml format. The data people
will access this page and get the xml file with all the data.

What's the best way to turn a sql server table into XML format?

What about the SSL part? Do all we need to do is access it with
https:// just like you would a typical secure page?

As for accessing the page, how will the data people authenticate to my
server? What's the best way? I'm sure they'll want to script it so
that this can be done automatically. 

-- 
.
http://sf-f.org, weblog and search engine for fans and writers of 
speculative fiction.
.

Relevant Pages

  • Secure access to a SQL Server database
    ... securely accessing SQL Server. ... script text, computer launched from, user launching. ... the hash value that gets authenticated against the secure table. ... ASP Currently we use SQL Server authentication and stuff something in a ...
    (microsoft.public.sqlserver.security)
  • Re: Best method of saving data between the normal and SSL stuff
    ... I would use a central SQL Server to host both secure and non-secure data. ... > What I want to do is store their completed orders so that they can look at ... > to same http 'hit' DB? ...
    (microsoft.public.inetserver.asp.db)
  • Help, Transferring XML data under SSL
    ... We have two sql servers that hold student data. ... I have full access to my sql server, but only write access to the main ... As for generating the XML, I'll have an asp.net page set up in a secure ...
    (microsoft.public.dotnet.xml)
  • Help, Transferring XML data under SSL
    ... We have two sql servers that hold student data. ... I have full access to my sql server, but only write access to the main ... As for generating the XML, I'll have an asp.net page set up in a secure ...
    (microsoft.public.sqlserver.xml)
  • Re: How to prevent my stored procedure code from being decrypted?
    ... > How should I do to secure my code? ... the primary way to protect intellectual property is with license ... this alias are considered for inclusion in future versions of SQL Server. ... > I found some freewares which can decrypt the encrypted stored procedure. ...
    (microsoft.public.sqlserver.security)