Data Exchange

Data Exchange

• Adam Toth

  can you provide some more info like :

  1. do u have connectivity between two netwroks.

  2. where is data stored in your network e.g. db or file system

  http://DotNetWithMe.blogspot.com
  vikas goyal

  
  
  

• Sanje2v

  Don't forget to compress it first! Following the web services theme, the binary (and encrypted) data could be sent using MTOM, which means the data gets transmitted as MIME attachments rather than in the SOAP XML document itself. It's more efficient to process because the XML parser doesn't see the data (I think).
  
  

• siavoshkc

  Vikas,

  We don't have any connectivity between two networks as of now. The cusotmer data is stored in SQL Server (some applications in 2000 and some applications in 2005). The partner uses SAP(SQL server as its database)

  
  

• joss1974

  1 GB a day Are you sure you need that much data Is some of it redundant Trimming down the amount might open up some other possibilities.

  My initial thought would be a program, probably a Windows Service working off a schedule, that would extract the data from SQL Server into an XML file into a very limited access folder, encrypt it, and then call a web service on the other end to upload it. Then, on the receiving end, have a Windows Service application move the encrypted file to a safe location, decrypt it, and load it into the database in a secure table on that side.

  
  
  
• Data Exchange