Posted by John Bell on 12/30/05 13:37
Hi Rey
Which suggestion was that?
Check out http://www.perfectxml.com/articles/XML/ImportXMLSQL.asp on ways to
import XML data into a database.
You can either use the same process on both servers (the source file would
have to be available to both machines) or create a job that refreshes the
remote server from the uploaded data in your remote database from the table
in the local database. This could be a DTS task or you can set up
replication to do it.
John
"_(d)IEGO" <rey_guerrero@hotmail.com> wrote in message
news:1135930212.830639.281760@g14g2000cwa.googlegroups.com...
> John,
>
> Thank you for your response.
>
> this table contains transaction records so each transaction will be
> stored locally and at a pre-defined interval newly added transactions
> will be uploaded to the remote server. so it is not that important that
> they are synchronized all the time. your first suggestion seems to fit
> what I need. How can I achieve this? Do I have to perform data
> trasformation before sending the file? If so, how is it done and how do
> I process it at the remote side?
>
> tia,
>
> Rey Guerrero
>
[Back to original message]
|