By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,611 Members | 1,468 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,611 IT Pros & Developers. It's quick & easy.

Moving stored procedures

P: n/a
Hi,

I have application with Access 2000 .adp and Sql Server 2000.
What is easiest way to move stored procedures from another database to
another database ?

colpo
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
aaj
Are you meaning copy rather than move, if so....

You can just copy the SQL text from the SP and paste it into a new SP in the
new database and then save it under the same name as the first SP

Or right click the tables in your new access front end and import
tables,views,sps etc from the original one (it generates all the scripts)

hope this helps

Andy
"Timppa" <co***@jippii.fi> wrote in message
news:37**************************@posting.google.c om...
Hi,

I have application with Access 2000 .adp and Sql Server 2000.
What is easiest way to move stored procedures from another database to
another database ?

colpo

Nov 13 '05 #2

P: n/a
"Timppa" <co***@jippii.fi> wrote in message
news:37**************************@posting.google.c om...
Hi,

I have application with Access 2000 .adp and Sql Server 2000.
What is easiest way to move stored procedures from another database to
another database ?

Easiest way is probably to use DTS from Enterprise Manager (Tools --> Data
Transformation Services --> Import). A better way is to use EM to script all
the procedures into a single file then use Query Analyzer to load the file
and run the script against the target db. This way you get back information
about any errors in the script.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.