473,394 Members | 1,752 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Help, Transferring XML data under SSL

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.
..
Nov 12 '05 #1
2 4525
I hope that you are using SQL 2000 and then you can use the FOR XML things.
If not, then you should just return all the rows from ADO in your asp page
and generate a response.write with your xml. Access the page over https and
make sure that you are validated via nt authentication for your web page.

The web page should accept query string params so you can modify your return
as needed.

Yes, just access your page just like any other https page.

Authentication to your server should be via NT security. Setup a username
and password for them in your user manager and have them use that.

Scripting this is not a problem. Use xp_cmdshell and call out to an
application called "curl". Curl is free for download and it installs like
nothing. Once this is installed you can call your xp_cmdshell to curl, then
use your favorite method to import the data. Here's one example:

1) Put your ASP page on server1 that will return XML.

2) The ASP page will just create an ADO connection to your database and
response.write out the xml of your choice.

3) The ASP page will be protected by an NT user (not anonymous) and will be
https.

4) The sql server (server2) will have curl installed on it.

5) Create a BAT file that will accept %1 %2 %3 %4 %5 and such parameters
that will use curl with the passed in username, password, website, and
such.

6) The BAT file will use the curl command and redirect " > " to another file
the actual XML that is returned.

7) The BAT file will then call osql with the parameters needed to import the
XML into server2.

8) done.

.... please note that XML is a little inefficient in this manner and if you
are just attempting to pass data from one machine to the next the BEST way
to do this is not use XML but rather have your asp page generate a SQL
script that osql can just execute. So your BAT file just calls osql with
the correct logon params and executes the script that it just downloaded.
The script would start with "begin tran" and then all the inserts or
whatever statements then end with "commit". Simple.

jimb wrote:
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.


Nov 12 '05 #2
See below.

Best regards
Michael

"jimb" <sp**@spamity.spam> wrote in message
news:Xn*****************************@68.12.19.6...
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?
Use FOR XML on your SELECT statement. If you cannot write statements
directly against the database, use the SQLXML component.
What about the SSL part? Do all we need to do is access it with
https:// just like you would a typical secure page?
Yes. But your webserver needs to be configured to accept SSL connections
(enable the SSL port etc.).
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.
.

Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: r_burgess | last post by:
I am looking for some guidance on transferring data between two pages in my ASP.net Web app (intranet). I have a form that will have a button and a text box on it (among other controls of course)...
3
by: phong.lee | last post by:
Hello all, i'm new at this. I need some assistant in transferring data from excel to access. I created a macro that basically gather all the necessary data that i need to bring into access. I...
1
by: Michael Fitzpatrick | last post by:
Transferring arrays from C DLL's to VB.Net I have a DLL written in C. This DLL reads a text file and creates a several very large arrays, 500,000 points and even larger. I would like the get the...
15
by: http://www.visual-basic-data-mining.net/forum | last post by:
Does anyone have any idea how to transferring data from TextBox1 in form1 to textBox2 in form2..... That means after i fill in any data in textBox1 and click Next button... It will bring me to...
1
by: Asaf | last post by:
Hi, I am developing a windows forms client application that will send a large XML data to a web server using Web Services. I saw this article http://www.codeproject.com/soap/MTOMWebServices.asp...
3
by: Mike Dee | last post by:
Hi, I'm having an issue with the status bar in Mozilla and Netscape showing that it is still waiting on the page to load even after it is finished. This problem does NOT occur with IE. In...
2
by: Dino | last post by:
dear all, i got this script form a customer. in general, it recieves data which is send via http to a server and generates a .xml file from this data. because i'm not familar with .asp, i'm...
2
by: Tommaso Caldarola | last post by:
I'm using a Remoting to manage small set of data, now the customer wants to transfer big binary files (up to 10 Gb) between 2 computers. It's better to use socket or other technology or I can...
0
by: Aqib | last post by:
I am working with Client Server Desktop Application which used to run on intranet. I am facing problem of slow speed due to large data (up to 1 GB). I am using Synchronies communication method (as...
2
hsriat
by: hsriat | last post by:
I have a page working on Ajax. The problem is, after doing many changes using Ajax (like uploading, changing name, adding to favorites etc), the status bar starts behaving unexpectedly. Even when...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.