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 |
|
Grofit
Starting Member
11 Posts |
 Posted - 2009-07-31 : 12:08:36
|
| Hey,Im using an MSSQL 2005 server with SQL Managment Studio 2008, and im trying to copy my local database to one on the server. Now i can use the export task and that works fine and makes the structure and data, even the views. However none of my stored procs get copied over.So im just wondering is there some magic option im not seeing or do i have to copy them over seperatly? ive temporarily moved some over using the Create As script thingy so i can just copy from there and dump into the other server, but for some of my other projects i will have LOTS of stored procs and would take me forever to do each one manually...Hopefully there is some quick way to do it as im sure lots of DBA people frequently have to copy stored procs and things around... |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-07-31 : 14:57:38
|
| Just backup database and restore in your server. |
 |
|
|
Grofit
Starting Member
11 Posts |
Posted - 2009-08-02 : 05:24:32
|
| Unfortunatly im using shared hosting, so i dont think there is any way that i can put it on their DB server for it to pick up... If anyone knows a way round this though it would be GREAT as im currently holding off doing this part until i can find a solid way of doing it... but it would help me alot if i could get it up and running on this other sever asap... |
|
|
|
|
|
|
Migrating Database with Stored Procs