General information
Forum:
Microsoft SQL Server
Title:
Data exchange between servers
Hello,
I have to solve problem of data exchange.
We have central server (brand new slq2k) and ~30 local servers (6.5 already in use by another apps and we can't upgrade).
Specific of current project is that a lot of small records have to be sent to central server in one transaction periodically through low speed and not stable networks.
Besides, local servers time by time have to load some data from cetral server. Because they are 6.5's, whe have set up central as remote server.
And we can't use linked servers.
To send data to central server - stored procedure has to be called for each record. That means high traffic and slow performance and other problems.
It's better to send in batches - Bcp is a solution, but not wery nice.
Replication is not nice too (30 x 6.5).
Is there another way to send/upload data in batches ?
Thank's in advance
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only