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
>

Merge data in SQL Server databases

I have two databases with identical tables structures. I need to merge the data in both databases without implementing merge replication. Can someone tell me what script to run that will compare the data in those tables? First I know the script has to search for data that doesn't exist in one table, the copy that over from the table that has extra rows. Thanks

AmmieNot sure how to help you unless you want to write a stored proc to do it.