Information générale
Forum:
Microsoft SQL Server
Titre:
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
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement