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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-05-22 : 08:07:22
|
| Anand writes "I have Sql server 2000 installed. And designed database with 13 tables with primary and foreign key relation.And some stored procedure and triggers.I have sample data in the database.Now I want to upload all these objects to another remote server. How to export these objects.Can u explain step by step how to export these.I will be very much thankful if u reply each step.I is now held up my uploading job. Thanks and regards.Anand" |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-05-22 : 08:15:14
|
| 1. Backup the database2. Move/Copy the backup file to the other server3. Restore the databaseThere are other ways to do it but this, but this should be easy and fast. |
 |
|
|
|
|
|
Data base upload