[quoted text, click to view]

Haven't we pointed you at aspfaq enough times? :-)
This subject is covered there ...

http://www.aspfaq.com/show.asp?id=2182
http://www.aspfaq.com/show.asp?id=2214

[quoted text, click to view]

Almost.

[quoted text, click to view]

With SQL 7 and above, you can detach a database file from the server,
copy/ftp the file to the destination server and attach it to the destination
SQL Server.

Another way is to take a backup of the database, copy/ftp the backup file to
the remote server where you restore it to the destination server.

If you need to make design changes to an existing database, the best method
is to run scripts containing DDL sql statements. However, there are free
web-based administration tools which can be used to make design changes in
much the same way that you would use Enterprise Manager:
http://www.aspfaq.com/show.asp?id=2442

HTH,
Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[quoted text, click to view]

You can also use DTS to transfer a copy of the structure, or structure AND
data. However this often misses important things like IDENTITY properties,
constraints, defaults, etc.

A

I have shared hosting that can support SQL databases. i currently use
access. whats the process in...
a. converting access to sql
b. uploading the database file

is it the same as access, where i just ftp the .sql file online or is it
more complicated (i dabbled with mysql databases and that was a text based
nightmare - i hope MS Sql isnt as difficult)

mark