Please excuse my ignorance, as I'm not overly with the inner workings of SQL,
nor do I know programming very well.  I've been given the task of taking all
of the data from a table on our sql 2005 server, exporting it, and importing
it into a SQl 2005 express client.  This needs to be very straight forward,
and should not involve the management studio.

I've started a program in VB.net 2008 that exports the table into an XML
file.  I think I'm doing this part correctly, but cannot figure out how to
get the XML file into the remote database.  There is no replication, etc. for
me to be concerned with.  Below is a snipit of the export code, as well as
the import code that I'm stuck on.  I've left out the SQL connection
statement as I've got it down pat.  I'm also leaving the file extension off
for a reson, but it should be creating a .xml file during the export, not xsd.

From what I understand, I've read the XML file into the dataset properly, I
just need to figure out how to take the dataset and import it into the
database.  If anyone could offer some assitance or direction I would
appreciate it!!

EXPORT CODE
=====================
Private Sub Export()
       Dim sqlConn As New
System.Data.SqlClient.SqlConnection(StrConnection) 'OleDbConnection i
       Dim strFilename As String
       sqlConn.Open()
       ' Queries Database for _Product Table and writes to XML File
       Dim ds As New Data.DataSet()
       Dim da As New System.Data.SqlClient.SqlDataAdapter("select * from "
& strPricelist & "_Products", sqlConn)
       da.Fill(ds)
       strFilename = "C:\" & strPricelist & "_Products"
       ds.WriteXml(strFilename, Data.XmlWriteMode.WriteSchema)
       ' Queries Database for _Product Table and writes to XML File
       Dim ds2 As New Data.DataSet()
       Dim da2 As New System.Data.SqlClient.SqlDataAdapter("select * from "
& strPricelist & "_Folders", sqlConn)
       da2.Fill(ds2)
       strFilename = "C:\" & strPricelist & "_Folders"
       ds2.WriteXml(strFilename, Data.XmlWriteMode.WriteSchema)
       sqlConn.Close()
End Sub

=============
IMPORT CODE
================
Private Sub Import()
       Dim sqlConn As New
System.Data.SqlClient.SqlConnection(StrConnection) 'OleDbConnection i
       Dim strFilename As String
       Dim xdoc As XmlDataDocument = New XmlDataDocument()
       xdoc.DataSet.ReadXmlSchema(textReader)
       sqlConn.Close()
End Sub