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 |
|
davidR
Starting Member
5 Posts |
 Posted - 2006-06-29 : 21:51:09
|
| I am kind of new to SQL Server Management Studio.How do I export tables and stored procedure from a database on my PC to a database by the same name located on a remote server. |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-06-29 : 22:15:26
|
| It's probably easier to backup the existing database and restore it on the destination server. Otherwise, you can script out the objects and then run the script on the remote server.To script out the objects, simply right click on the source db and select 'generate sql script' |
 |
|
|
davidR
Starting Member
5 Posts |
Posted - 2006-07-10 : 19:55:44
|
| Import/Export using Management Studio |
|
|
|
davidR
Starting Member
5 Posts |
Posted - 2006-07-10 : 20:03:15
|
| Yes, it would have been easier to restore the backup. Unfortunately, The Web hosting Co. does not provide that option. I have to load data into a database they created by default. I will try the scripting and let you know the progress. I was gone for a few days and couldn't reply sooner. Thank you for the tip. |
|
|
|
|
|
|
Import/Export using Management Studio