Solved

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

Posted on 2009-07-13
1
294 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
1 Comment
 
LVL 31

Accepted Solution

by:
RiteshShah earned 500 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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 set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

744 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now