[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

How to move encrypted sql procedure from one server to other ?

Posted on 2009-07-13
1
Medium Priority
?
302 Views
Last Modified: 2012-06-21
Hello Experts.
I need to move encrypted tsql procedure from one MS SQL 2005 server to other, how can i do this ?
I add that this must be done using SQL scripts and person charging procedure for the second server can not know the source code.
This is the code that i used to encrypt the procedure:

CREATE PROCEDURE example_procedure
WITH ENCRYPTION
AS
SELECT * from somewhere;
GO
0
Comment
Question by:ASkEPA
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 31

Accepted Solution

by:
RiteshShah earned 2000 total points
ID: 24846643
you can't export SP and can't generate it's text because it is encrypted, the only option is to take full backup of database, restore it, restored database will have that SP too.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question