December 4, 2001 at 4:02 am
Is it possible to create a snapshot publication then subscribe to it so it writes the data to a different tablename than the one in the publication?
Paul Ibison
Paul Ibison
Paul.Ibison@replicationanswers.com
December 4, 2001 at 4:06 am
Never tried it. Dont see why you couldnt manually alter the stored procs it uses to apply the changes to point to another table though.
Andy
December 4, 2001 at 4:19 am
Thanks for such a quick response. I'd never tried scripting replication before but it works well. I just changed sp_add_article and altered @destination_table. This option didn't seem to be on the gui, but the new script did the job - cheers.
Paul Ibison
Paul Ibison
Paul.Ibison@replicationanswers.com
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply