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 Administration (2000)
 Uploading sql database to Web Server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-07-24 : 08:51:55
jabeer writes "hello Sir,

I have created a database in MS Sql Server 7.0 , and i have to upload that database to my Web Server. how can i do this , this is first time i am doing this.(i have created an asp file to access that data base.)

Thank you,
jabeer khan"

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2002-07-24 : 09:07:34
I'm not familiar with the concept of 'uploading a database'. What does that mean?

<O>
Go to Top of Page

jasper_smith
SQL Server MVP &amp; SQLTeam MVY

846 Posts

Posted - 2002-07-24 : 17:08:22
If you mean you have developed an application locally and you need to upload it to your hosted server then the easiest way would be to take a full backup,zip it,ftp it to your server and restore it. Depending on how its accessed you may need to do some work to resync users with logins on your host server


HTH
Jasper Smith
Go to Top of Page

salpesh
Starting Member

5 Posts

Posted - 2002-08-27 : 10:04:56
The best bet is to talk to your ISP if you are hosting your site outside. I had the same problem and I ended up connecting to their SQL Server using IP address. Once you are connected to their SQL Server, then you can upload your tables, store procedures, views... to database. I hope this helps.

-Alpesh Shah

Go to Top of Page
   

- Advertisement -