Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AlexP
Starting Member
34 Posts |
 Posted - 2005-08-04 : 17:17:42
|
| I create SProcs on a dev SQL2000 server and when I am ready to move them to production I always have to manually Copy and Paste the code from one SProc to create another on production. Is there a cleaner more efficient way than this? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-04 : 17:18:54
|
| Use the Generate SQL script wizard in Enterprise Manager. You can script all of them into one file, then run this one file in your other environments.Tara |
 |
|
|
AlexP
Starting Member
34 Posts |
Posted - 2005-08-04 : 17:21:55
|
ok I guess that will do.I was hoping that EM would allow me to do a simple copy and paste of the SP itself.quote:
Originally posted by tduggan
Use the Generate SQL script wizard in Enterprise Manager. You can script all of them into one file, then run this one file in your other environments.Tara
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-04 : 17:24:46
|
| The wizard allows you to copy the script without saving it to a file. I'd recommend the file though so that you can put it into your source control.Tara |
|
|
|
ssrikrish
Yak Posting Veteran
69 Posts |
Posted - 2005-08-04 : 22:12:10
|
| A tool like DBArtisan would be very handy. If cost is not a consideration, I would recommend it. It simplifies the roll out task. It also reduces deveopment time considerably.byesrikrish |
|
|
|
AlexP
Starting Member
34 Posts |
Posted - 2005-08-05 : 09:54:25
|
| thanks for the info guys |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-05 : 10:10:15
|
| We save our Sprocs to a File (never edit them directly in the database), and from there generate scripts of "new ones only" to run on Production server etc.Plus they go into Version Control systemPlus they go through peer reviewPlus we have them in a folder structure which can reflect client-specific mods, SProcs appropriate for specific Modules within the Application, that sort of thing.Kristen |
|
|
|
|
|
|
Deploying Store Procs