XML数据处理 [英] XML Data Processing

问题描述

大家好。我需要有关以下方面的帮助：


给出下表：

CREATE TABLE T1（C1 nvarchar（10），C2钱）


插入T1值（''A''，1）

插入T1值（''B''，2）

INSERT INTO T1 VALUES（''C''，3）


让'我说我在本地服务器上有这个表，我想上传

它到远程服务器和远程服务器上传到数据库

包含相同的表格。


上传部分可由另一个人完成应用程序在远程

服务器上，但我想要的是一种以最快的方式传输数据的方法。


我需要遵循哪些步骤？


tia，


Rey Guerrero

解决方案

嗨Rey


答案取决于你是否要保持数据之间的同步

两个服务是不是？如果没有，那么您可以在

远程服务器上并行处理上传。如果他们必须同步，那么你可能想看看复制。它还可能取决于远程服务器的可访问性以及它们之间的连接。


John


" _（d）IEGO" <再********** @ hotmail.com>在消息中写道

news：11 ********************* @ f14g2000cwb.googlegro ups.com ...

大家好。我需要有关以下内容的帮助：

如下表所示：
创建表T1（C1 nvarchar（10），C2钱）

插入T1值（ ''A''，1）
插入T1值（''B''，2）
插入T1值（''C''，3）

让我们说我在本地服务器上有这个表，我想将它上传到远程服务器，在远程服务器上传它到包含同一个表的数据库。上传部分可以由远程服务器中的另一个应用程序完成，但我想要的是一种以最快的方式传输数据的方法。

我需要遵循哪些步骤？



Rey Guerrero

John，


感谢您的回复。


此表包含交易记录，因此每笔交易将为

本地存储并以预定义的间隔新添加的转换ns

将上传到远程服务器。因此，它们一直同步并不重要。

你的第一个建议似乎适合我需要的b $ b。我怎样才能做到这一点？在发送文件之前，我是否必须执行数据

转换？如果是这样，它是如何完成的以及如何在远程处理它？<​​br />

tia，


Rey Guerrero

嗨Rey


有哪些建议？


查看 http://www.perfectxml.com/文章/ XML / ImportXMLSQL.asp 关于如何将
导入XML数据到数据库中的方法。


您可以在两者上使用相同的过程服务器（源文件必须两台机器都可以使用
）或者从表中创建一个从远程数据库中上传的数据刷新

远程服务器的作业

在本地数据库中。这可能是一个DTS任务，或者你可以设置

复制来完成它。


John


" ; _（d）IEGO" <再********** @ hotmail.com>在消息中写道

news：11 ********************** @ g14g2000cwa.googlegr oups.com ...

John，

感谢您的回复。

此表包含交易记录，因此每笔交易都将在本地存储并以预先定义的方式存储interval新添加的事务将上传到远程服务器。所以它们一直都是同步的并不重要。你的第一个建议似乎适合我需要的东西。我怎样才能做到这一点？在发送文件之前，我是否必须执行数据转换？如果是这样，它是如何完成的以及如何在远程处理它？<​​br />
tia，

Rey Guerrero

Hello everyone. I need help regarding the following:

Given the following table:
CREATE TABLE T1 (C1 nvarchar(10), C2 money)

INSERT INTO T1 VALUES (''A'',1)
INSERT INTO T1 VALUES (''B'',2)
INSERT INTO T1 VALUES (''C'',3)

let''s say that i have this table in a local server and i want to upload
it to a remote server and in the remote server upload it to a database
that contains the same table.

the uploading part can be done by another application in the remote
server, but i want i need is a way to transfer the data at the fastest
possible way.

what steps do i need to follow?

tia,

Rey Guerrero

解决方案

Hi Rey

The answer will depend on if you want to keep the data synchronised between
the two servers or not? If not then you can have an upload working on the
remote server in parallel to yours. If they have to be syncronised then you
may want to look at replication. It may also depend on the accessibility of
the remote server and the connection between them.

John

"_(d)IEGO" <re**********@hotmail.com> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...

Hello everyone. I need help regarding the following:

Given the following table:
CREATE TABLE T1 (C1 nvarchar(10), C2 money)

INSERT INTO T1 VALUES (''A'',1)
INSERT INTO T1 VALUES (''B'',2)
INSERT INTO T1 VALUES (''C'',3)

let''s say that i have this table in a local server and i want to upload
it to a remote server and in the remote server upload it to a database
that contains the same table.

the uploading part can be done by another application in the remote
server, but i want i need is a way to transfer the data at the fastest
possible way.

what steps do i need to follow?

tia,

Rey Guerrero

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

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" <re**********@hotmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.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

这篇关于XML数据处理的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！