Hi, there is another company that we have fiber connection with them. we have so many data transfer between our systems. in current situation we use link server from our SQL 2005 server to their ORACLE 9i and ORACLE 10g databases.
we mostly use VIEW and some times SP. I am thinking that it is not a good way to transfer data between two company. so we are going to define another solution. I proposed xml and XML Web service or as a newer version WCF.
I am not sure these are the best so could any body present any proof about using XML or WCF.
is there any other suggenstion that we can use. (please consider that we are going to define a standard solution that we can use it over high speed connection (like fiber) and also over internet.
I want to be sure that XML services are reliable, secure and fast. Could anybody help me