.NETGURU
Please Advice. What´s the right path? plain file vs xml file
Messages   Related Types
This message was discovered on microsoft.public.dotnet.framework.aspnet.webservices.

Post a new message to this list...

Jorge Luzarraga Castro
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
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

"Jorge Luzarraga Castro" <Click here to reveal e-mail address> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:Click here to reveal e-mail address...
[Original message clipped]

Reply to this message...
 
    
Jorge Luzarraga Castro
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

"Denis Kondratyev" <Click here to reveal e-mail address> escribió en el mensaje
news:chl80q$ovu$Click here to reveal e-mail address...
> 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
[Original message clipped]

Reply to this message...
 
    
Denis Kondratyev
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.

"Jorge Luzarraga Castro" <Click here to reveal e-mail address> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:Click here to reveal e-mail address...
[Original message clipped]

Reply to this message...
 
 




ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
Ad


Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews
.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT
Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project
FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.
Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials
 
ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
 Copyright © ExamGuru, Inc. 2001-2006
Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification