|
Posted by samh on 10/25/06 13:01
Thank you all for your reply. Malc, your suggestion is just what I was
looking for, thank you.
I would love to use replication but the client we are developing this
for just doesn't want it. The problem is they have another system
(written by another company) that uses replication and they have
serious concerns about the amount of data being sent around their
network. Now this seemed strange to me and I identified that the data
was being replicated from all all machines to ALL machines! The client
(IT manager in particular!) still insists that replication isn't a good
solution and all I can do is write something similar but on smaller
scale.
Having written something the problem that I've identified now is the
speed. Running 1000 insert statements one after another is just way to
slow. Especially considering its a server sending these to another
server down a v. slow line. If anyone can suggest a quicker way of
moving the data I'd ve grateful. I thought maybe about a linked server
on each local server but I thought i'd see if anyone else has any
suggestions. There's BCP but I'm not sure this is relevant???
Steve.
Navigation:
[Reply to this message]
|