I try to setup a transaction replication across the network of servers, but first I was testing the replication on the single machine.
I think I got everything setup correctly. I choose to run the initial snapshot (in transaction replication) immediately. After that, I saw that the schema (tables) were replicated to another database, but the data is not there. Does anyone know why?
Also, can someone tell me what I should do n choosing articles? I checked tables, views and stored procedures. But then i noticed (from Monitor) that the distribution agent failed for the reason"unable to replicate a view ro function becuase the referenced objects or columns are not present on the subscriber".
BBTW, i was using PUSH distributuion.