Thanks a bunch. I appreciate it. I think replication is probably the best option for us. The foreign key constraints and all would make the SSIS implementation very troublesome.

Thanks for your prompt response and knowledge sharing, Dave.

Actually, I was particularly interested in finding out more on the timeout for class 'ACCESS_METHODS_BULK_ALLOC'. We have seen in several occasion...

We happened to have encountered a similar problem. Could you kindly share your findings?