How do i upload sql server tables to my webserver

Posted on 1999-06-22
Medium Priority
Last Modified: 2010-03-19
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
Question by:tonytpark
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2

Accepted Solution

mativare earned 0 total points
ID: 1095882
Tables cannot live outside database structure alone,  sometimes you could link them to another database. If you are using some of Microsoft web servers
it is easy to put data from databases dynamicly to web using ASP
Interdev creates ASP automaticly(wizards). You need to set up ODBC Data
Source first. In control panel you have ODBC applet , it can create data
sources using wizard. If you do not have SQL server ODBC driver you
need do download it from Microsoft site. Having ODBC DSN set up you can go
forward and use Interdev, it asks you DSN  sooner or later.
Good luck.


Author Comment

ID: 1095883
I will need a little more help as i am completely new to this thing. let me go back a little.

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.

Expert Comment

ID: 1095884
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

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Ready to get certified? Check out some courses that help you prepare for third-party exams.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question