July 12, 2011 at 9:20 am
I have a simple query which needs to run 4 times a day and update a table I have on Server B.
That query does inserts, no deletes. So I need to get the data from server A to server B. I was
asked to use subcription. I managed to setup a subscription to server A on Server B. Now, how
do I get to run that simple query in this subcritpion scheme ? Don't know where to start.
Thank you in advance !
Nagard
July 12, 2011 at 9:36 am
This doesnt sound replication related.
So you have now published an article (table) and this is now on the subscriber (server B) and communicating as expected.
Assuming you need to use this data, create a sql agent job to run at your required interval.
July 12, 2011 at 9:40 am
You also dont mention the type of replication, if you are inserting into the published table and if you require the data to propogate back to the publisher.
Transactional replication is generally one way so if any changes are made to the subcribed table they will not be visible on the publisher.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply