Using Service Broker for sending/receiving large XML files over WAN
-
vendredi 21 janvier 2011 11:41
Hello!
PROBLEM:
An entity has a central DB and some 30 scattered DBs at different location conneted through WAN.
DB communication is needed in both directions (update, insert, delete). Merge replication is excluded as a solution.
PROPOSED SOLUTION:
All DB modifications saved as XML files to the source. Compress these files to reduce size and put them on Service Broker queue using VarBinary(max).
At the other end decompress and apply the XML files to the destination DBs.
The XML compressed files will be put in a varBinary(max) data type using FILESTREAM.
QUESTIONS:
1. Will the Service Broker support this scenario?
2. Do you know any compression utility on Windows side to help with this scenario?
Thank you for the time.
FlorinPo
Toutes les réponses
-
vendredi 21 janvier 2011 17:07Modérateur
Hi,
The part I'm not getting is why you want to store the compressed xml using FILESTREAM (I mean why you need to store it at all, other than sending it via Service Broker and therefore storing it in the transmission queue). Could you please clarify that?
-
mercredi 2 février 2011 00:38
agreed w/pawel...
you're gonna have to write a bunch of code to write to the filesystem just to read back into sql!?
mike t. -
mardi 13 mars 2012 11:00
Hello,
I am actually in a project that needs the same thing as you, I need to send data from a data base to another without using the replication or mirroring, I head about the Service broker and I tested it with some simple wml messages.
Now I'd like to send XML files from an instance to another, or id possible, i'd like to send .sql files from an instance to another. As you can see the documentation is rare about that subject, if you have accomplished some progress concerning this project I'll be very thankful if you give me some tips.
Thank you.
TAHRI JOUTI Abdoullah.
Software Engineer.
.png)
