You've several options, but you might have to copy the entire DB instead of one table. BCP initially sounds like the best option, but replication might fit as well. - replicate the table only, at once ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results