MS SQL Database Question

[mark | r]

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

 

[Bob Barrows [MVP]]

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

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

is it the same as access, where i just ftp the .sql file online or is
Almost.

it more complicated (i dabbled with mysql databases and that was a
text based nightmare - i hope MS Sql isnt as difficult)

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

 

[Aaron Bertrand - MVP]

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

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