I need to setup replication in standard edition.
my requirement is:
1. I have server A .it contains 10 tables (Like A1,A2,A3.....A10).
2. i have another server B. it is backup of server A but it contains only 5 tables, coz i need to replicate only 5 tables (table names like A1,A2..A5).
I want to replicate changes from server A to B (only 5 tables not all 10 tables).
1. Is it possible in replication (The replication method may be merge/snapshot/transactional.)?
2. Is it possible in Standard edition?
please respond ASAP.