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 |
|
sbhatt.84
Starting Member
1 Post |
 Posted - 2008-07-29 : 03:57:28
|
| Dear friends,Everytime i start of with a new project i first create the DBMS structure. This i do with the help of the diagram i.e. GUI interface of MS SQL 2000. However after this when i want to test this site online on server i am unable to upload the diagram on the SQL server online. I know the techniques of taking a back up and then restoring it but that is not possibl;e when u have a remote server in MS SQl 2000. Is there any other this can be achieved.Please help me out with this. If i am able to only transfer ALL THE db TABLE DIAGRAM with their relationship set as it is from my machine onto server it would help me greatly.Any help is appreciated...... |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-07-29 : 08:29:21
|
Use Enterprise Manager right click on the database to generate the database SQL Script and run that script against your remote database
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
how to upload only SQL database table or diagram