tonytpark
asked on
How do i upload sql server tables to my webserver
I have roughly about 200 tables in a database on my sql server. Now i have to upload it to my web-server. They have given me the username, passowrd and location of the sql server database on their computer (which is not on the webserver). I am using viusal interdev and would appreciate if someone could tell me how i should go about doing it. thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You have everything you want
Database can be "outside" web server, DNS is pointer do it
Start to develop your ASP with Interdev and then in order to test them you need to FTP them to Web server. Your web server folder has property
to run script, ask this to set ENABLED
Good luck
Database can be "outside" web server, DNS is pointer do it
Start to develop your ASP with Interdev and then in order to test them you need to FTP them to Web server. Your web server folder has property
to run script, ask this to set ENABLED
Good luck
ASKER
awright this is what i am trying to do...
1) i have my sql server on my nt machine which is also the webserver running iis. lets call this machine-Homewebserver
2) i have interdev on another machine in the network...lets call it-clientmachine.
3) i connect to the internet using a proxy which is on another machine- proxy server (stricly http and ftp)
4) now my webserver is somewhere in baltimore and i will have to connect to it remotely over the internet. from what i have been told by the web-hosting company is that my database is not on the webserver but another machine. they have given me the sql database path (something like
e:\data\sql\myname) and also my dsn name which is- tony (that is all the info i have...should i ask for more info...if yes, what should it be?)
now can you please tell me in this maze of computers how and what should i do sequentially...this is the first time i am doing it.