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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 managing database

Author  Topic 

hasanali00
Posting Yak Master

207 Posts

Posted - 2004-11-01 : 06:03:43
Hi
I have been working with MSSQL on my local machine, but now i need to upload the database onto the hosted server.

I wonder if u can give best guide lines as to the follwoings:

(1) When creating a new table, should I first design and populate the table on my local machine and then upload it onto the hosted MSSQL server OR can I simply design and populate the table on the hosted MSSQL server directly.

(2) I am new to MSSQL so i would be grateful if u can tell me of any good resource that shows how to:
(i) import / export data structures and data from one server / database to another.
(ii) how to maintain databases

regards
   

- Advertisement -