SQL Support
Microsoft SQL Server
Microsoft SQL Server is recommended for large databases
(more than 20MB) with few user logins. You can use SQL Server for your
website by using the Enterprise Manager tool for Object transfer (preferred).
Alternately, you may send a database dump or SQL scripts
to your web site via FTP, and letting us know:
- the database name and size,
- the Data Source Name (DSN) that you will use in your scripts to
access the database,
- your username,
- your password.
We will then incorporate your database into our SQL Server
and set up the Data Source Name on the Web Server.
You can access the database through web pages that you
create, which we can secure by login name. If there is a large change,
you could FTP a database dump or SQL script, and we will publish it
to the database. We also have custom database management ASP pages,
which can be setup for a small fee, to modify your database for minor
changes.
Microsoft Access
This database type is recommended for small databases (less
than 20MB) with many user logins. You can simply upload the Microsoft
Access database to your web site, tell us the DSN name and the file
name, and we will create the ODBC DSN entry. You can set the permissions
for the database file with Microsoft FrontPage, or you can request that
we set the permissions to execute only. To make changes in the database,
you simply upload the updated Microsoft Access database file. We also
have custom database management ASP pages, which can be setup for a
small fee, to modify your database for minor changes.
|
