Adding a Table to the subscriber DB manually in a Transactional Replication Environment

I need to add a table that exist on the publisher db to the subscriber DB. However it does not have a primaryID and I do not want the data to be replicated just the table structure.( It is a Scratch table that is needed for reporting purposes). My Thought was to just run the table creation script against the Subscriber DB, after replication is setup each time.

will that work
is there a better way ?

Thanks

Brian

asked Nov 13 '09 at 11:29 AM in Default

Brian
36 ● 4 ● 4 ● 6

(comments are locked)

1 answer:

Yes, that will work.
sp_addScriptExec - this will publish your table script when you run it interactively, but it will also cause the table script to be included whenever you set up in the future.

sp_addScriptExec @publication='your-publication' , @scriptFile = '\\snaphot-storage-location\your-table-script.sql' , @skipError = 1

answered Nov 17 '09 at 12:28 AM