Sign in
 
SQL Server Developer Center > SQL Server Forums > SQL Server Replication > How to publish encrypted modules
Ask a questionAsk a question
Search Forums:
 

AnswerHow to publish encrypted modules

  • Saturday, November 07, 2009 7:37 PMLeilas Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

    Hi all,

    We have many encrypted DML triggers that must also be kept encrypted at the subscriber. What’s the best practice to transfer such objects?

    Thanks in advance,

    Leila

     

Answers

  • Saturday, November 07, 2009 11:54 PMHilary CotterMVP, AnswererUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote
    You can't publish encrypted objects as you probably have noticed.

    The best way is to backup the database, restore it on the subscriber.
    looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
     

All Replies

  • Saturday, November 07, 2009 11:54 PMHilary CotterMVP, AnswererUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote
    You can't publish encrypted objects as you probably have noticed.

    The best way is to backup the database, restore it on the subscriber.
    looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941