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 |
|
jrockfl
Posting Yak Master
223 Posts |
 Posted - 2005-02-21 : 09:52:36
|
| Is it possible to to copy the SPs I created on the development database to my production database?They are both on the same SQL Server. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-02-21 : 09:55:23
|
script them and run then on the production serverGo with the flow & have fun! Else fight the flow  |
 |
|
|
jrockfl
Posting Yak Master
223 Posts |
Posted - 2005-02-21 : 09:57:18
|
| i was hoping you would say...yeah just drag and drop them lol. oh well...i will script them. thank you. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-02-21 : 10:08:29
|
| oh yes of course... just drag and drop them. no problem. Go with the flow & have fun! Else fight the flow |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-02-21 : 11:32:20
|
| Neet Trick I useActually You can use Access 2002 or >I have a Access front end of my master (production) DB and a one of my test db on my desktop.To use it I simply select it in my test right click and export to the other. This will also check for replace existing an let you decide.JimUsers <> Logic |
|
|
|
|
|
|
Copy SP from one database to another?