To rename publication name

SQL2K

I want to rename a publication name.

Publications:     siddiqsons:siddiqsons (Name before : is publication name and after column is database name.

I want to rename the above as [ SiddiqsonsVsProd_Dcity ] without affecting the existing articles and subscribers.
MateenAsked:
Who is Participating?
 
imran_fastConnect With a Mentor Commented:
>>want to rename a publication name.
>>Publications:     siddiqsons:siddiqsons (Name before : is publication name and after column is database name.
>>I want to rename the above as [ SiddiqsonsVsProd_Dcity ] without affecting the existing articles and subscribers

one way generate the script of your publication.
paste it to the query analyzer replace siddiqsons  with  SiddiqsonsVsProd_Dcity dont replace the server name and database name only the pulication name and then execute it  on the query analyzer and then reschedule the four agents
either from the replication screen or the jobs screen.

the four agents are
1.snapshot agent
2..log reader
3. siddiqsons:SiddiqsonsVsProd_Dcity
4. distributor (just schedule it once it will be common for all publications)
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
I think the better way is to drop and recreate the publication
0
 
MateenAuthor Commented:
Oh my god.

It would take a lot of time.

Ok.
0
 
MateenAuthor Commented:
I would be happy, if u may please have a view at
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21836260.html.

Thanks
0
 
imran_fastCommented:
tell you what if you try to rename the publication without droping them you need to change it in msdb database but it is very risky. i never did it and it is not recommended. so better use the above mentioned method of generating the script.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.