Welcome to dbForumz.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Export SPs?

  
   Database Forums (Home) -> General Discussions RSS
Next:  greatest value bounded above?  
Author Message
laurenquantrel

External


Since: Dec 07, 2004
Posts: 18



(Msg. 1) Posted: Thu Dec 22, 2005 10:03 pm
Post subject: Export SPs?
Archived from groups: comp>databases>ms-sqlserver (more info?)
I have uses DTS Import/Export wizard to export all my tables from one
databse to another on the same server. How do I export all of my stored
procedures and UDFs?
Thanks,
lq

 >> Stay informed about: Export SPs? 
Back to top
Login to vote
Jens

External


Since: Sep 12, 2005
Posts: 91



(Msg. 2) Posted: Thu Dec 22, 2005 11:31 pm
Post subject: Re: Export SPs? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
1. use the DTS Wizard and specify the "Copy Objects and Data between
SQL Server databases and then select the stored procedures you want to
export.

2. Script up a file by (right) clicking on the appropiate database or
the individual procedure and Select "Generate SQL Script"

HTH, Jens Suessmeyer.

 >> Stay informed about: Export SPs? 
Back to top
Login to vote
laurenquantrel

External


Since: Dec 07, 2004
Posts: 18



(Msg. 3) Posted: Fri Dec 23, 2005 5:21 pm
Post subject: Re: Export SPs? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Jens, Thanks. I didn't see that option for some reason.
This has made recovery much simpler.
lq
 >> Stay informed about: Export SPs? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Primary Key fails to copy in db Export - Currently, I'm exporting a database from production to local (test) machine. I've done this several times without problem, but during the last few days, the primary keys have failed to export. Would anyone know what options might keep the keys from..

Concurrency in Transaction - hi gurus the scenario Frontend - MS Access (not yet decided whether MDB or ADP) Backend - MS SQL Server it is a conversion from MS Access backend to MS SQL Server Backend. Planning to create stored procedures for all the Inserts, Updates, Deletes and....

Configuring SQL MAIL - Hi All, My question is that can I configure SQL MAIL, if my EXCHANGE SERVER is on different domain and my SQL is running on different domain.Can anyone guide me for this because I googled a lot without any result. I am using SQL SERVER 2000..

working with daily results : results per day - Hi, I'm trying to get an overview of counted visits per day for a webapplication. The thing is that SQL doesn't work with full days. For instance: getdate() returns a fulldate instead of a date in the format 'yyyy-mm-dd'. I need this format, without....

Importing multiple files to SQL - I have over three hundred text files that I need to import to SQL Server. Each is in the exact same format. I want to import tham as seperate tables. Is there any way to do it in one process? Regards, Ciarán
   Database Forums (Home) -> General Discussions All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]