Merge databases

Hi,
Is it somehow possible to merge two databases with identical schema? We
have two or more sites whose data are supposed to be merged into the
main database at night. Data at each site is unrelated to the data at
other sites. Each site has limited bandwidth (satellite). Some sites
may even lack network, requiring the data to be transported on a DVD-R
from site to main office.
regards,
Knut Eldhuset
You might want to roll your own solution using checksum's or use Red-Gate
software's data compare.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Knut Eldhuset" <knut.eldhuset@.gmail.com> wrote in message
news:1115636465.617229.291830@.g14g2000cwa.googlegr oups.com...
> Hi,
> Is it somehow possible to merge two databases with identical schema? We
> have two or more sites whose data are supposed to be merged into the
> main database at night. Data at each site is unrelated to the data at
> other sites. Each site has limited bandwidth (satellite). Some sites
> may even lack network, requiring the data to be transported on a DVD-R
> from site to main office.
> regards,
> Knut Eldhuset
>