Replicate new objects
-
Is there any way that new objects will get created in the subscriber database which has been created at the publisher's end, like a new stored procedure, after the replication has been setup?
Chandrachurh Ghosh
DBA – MS SQL Server
Ericsson India Global Services Limited
Quality is not an act, it is a habit. -
In transactional and Merg replication it is possible
-
But how?
I would like to use the transactional replication.
Chandrachurh Ghosh
DBA – MS SQL Server
Ericsson India Global Services Limited
Quality is not an act, it is a habit. -
After the objects are created on the publisher you need to use sp_addarticle an run the snapshot agent.
the distributor will pick those up an apply them.
* Noel -
Define ur new objects(table,sp,view..) using sp_addarticle then define ur subscriber using sp_addsubscription. Run it in publisher side.
Then start your snapshot agent. Now your new article will be availble in your subscriber.
Thanks,
Balaji L
-
Great...........thanks!
That was quite a good help from you.
Chandrachurh Ghosh
DBA – MS SQL Server
Ericsson India Global Services Limited
Quality is not an act, it is a habit.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply