Is that I proposed first time - transactional replication - but the client don't want to add the primary key for all tables. Result: no transactional replication! and they want all that replicated, no just some tables for the purpose of reporting.
Thanks,
Paula