I got a question. Do I need for transactional replication with horizontal/vertical filters make a full db synchronization including all table and data?
I need to replicate one-way, SQL Server 2000 Ent. -> SQL Server 2000 Std.
I have set a publication for a table with certain filters (not all columns are to be replicated). On subscriber - I have set the subscription and after running the Agent the proper db schema was created (including only the columns I'd set for replication).
After starting the synchronization (Pull: shared agent) I got the following error: *Invalid column name: tr_next_tran_nr*
The column above is EXCLUDED from replication - it exists in the source table, but the publication has filter on that column. It hasn't been created by Replication Agent within the subscriber's database.
My question is: do I really need to make an Initial Snapshot full? (the table is 200GB large...)
