February 21, 2007 at 9:23 am
All,
I've been asked to setup some sort of replication scheme between a server in India and one in Toldeo OH. Currently I get a report that details all the SPs that were changed on each of the enivormnets and run the sp on the appropriate enviroment. Is there a way to replicate the stored procedures changes from each of the environments each night and run the procedures on the applicable enivorment. I'd like to remove myself from this equation. It takes up a lot of time...
Thanks
-WM
DBA
February 23, 2007 at 12:12 am
Yes, you can replication procedure definations...
See BOL for more info and read the following article..
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1241182,00.html
MohammedU
Microsoft SQL Server MVP
February 23, 2007 at 5:57 am
Thanks
-WM
DBA
February 23, 2007 at 6:54 am
Not sure I agree. I believe the last time I looked you could set views and stuff to be part of the initial snapshot, but there is no provision in transactional to keep stored procedures up to date on the subscribers (other than the system generated ones used directly by replication). You have to add them manually to the subscribers, or cook up some semi automated method of distributing them that achieves the same thing.
Unless you're doing updates on the subscribers there is usually no need for the stored procedures that might change though. Typically a subscriber will have different indexes and permissions from the publisher if used in a read only capacity.
February 23, 2007 at 8:54 am
The majority of the updates come from the offshore development team. I get the report and run the Sps on the Dev machine here in Toledo.
I think If I use snapshot replication it will take a lot of time. Not sure if that's the best solution. I only need the SP and view changes not the entiroe database.
-WM
DBA
March 7, 2007 at 12:54 pm
Sill need help with this...
-WM
March 8, 2007 at 5:40 am
SQL2k or 2005?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply