Please Advice. What?s the right path? plain file vs xml file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jorge Luzarraga Castro - 07 Sep 2004 21:15 GMT

Hello Everybody!

I?d like that you give me some advice on what the right approach to import
some data from one system to another is. I know that a webservice fits
perfectly to intercommunicate two different systems but it is said that
unfortunately it is slower than to load a plain txt file via a stored
procedure.

What should I do? To keep loading the data from a plain text file or to
change the aproach and consume a webservice developed in the other system to
load the data I need.

TIA

Jorge.

Reply to this Message

Denis Kondratyev - 07 Sep 2004 22:09 GMT

Imho XML is a best approach in many cases (and imho in your situation too),
but I dont use web services always because its "cooool". Check requarements
for you system: how many data u must import - 1 MB or 10 GB? what
environments for your system - intranet or internet, homogeny or heterogenic
system? security requirements?

Denis Kondratyev

> Hello Everybody!
>
[quoted text clipped - 11 lines]
>
> Jorge.

Reply to this Message

Jorge Luzarraga Castro - 07 Sep 2004 22:53 GMT

Dennis, Thanks for your reply.

Here are some extra considerations:

The initial load is going to be the heaviest, but next loads are gonna be
under 1 MB.
Both of the systems have their own database schema on different servers.
Both of the systems are on top of the .NET Platform and using MSSQLServe 2K.
Both of the systems are part of the same intranet.

Given all of this, is it still good choice to consume a webservice to load
data?

TIA

Jorge Luzarraga

> Imho XML is a best approach in many cases (and imho in your situation too),
> but I dont use web services always because its "cooool". Check requarements
[quoted text clipped - 21 lines]
> >
> > Jorge.

Reply to this Message

Denis Kondratyev - 08 Sep 2004 19:44 GMT

Imho with 1 MB data u dont have performance troubles with web services via
intranet. For initial load u can use DTS if amount of data is big.

> Dennis, Thanks for your reply.

> Here are some extra considerations:
>
[quoted text clipped - 10 lines]
>
> Jorge Luzarraga

Reply to this Message

Please Advice. What?s the right path? plain file vs xml file

Free Magazines