moving SQL Server to remote web server

I'm very new to using SQL Server and have a very basic question that I was hoping someone could help answer or point me in the right direction.

Ive been searching for the information and have been unable to find what Im looking for. I might be using the wrong keywords.

This is what Im trying to find. I have found some information on building a database in Access and porting it over to SQL Server. The information that I've found discusses on a simple level how to use Enterprise Manager to port over using the following steps:
Enterprise Manager:
1) Database level >> Action Menu >> New Database setup a name
2) Highlight new database name
3) Tools Menu >> Data Transformation Services >> Import Data

Data Source = Microsoft Access

Okay, so that is pretty straightforward. If I created the web page using the Access DB and I am using an OLE-DB connection string then once I port over to SQL Server all I should need to change is the connection string to a SQL Server connection string. Is that correct? Anyone know where I can find some information about this process and specifically how to upload the new SQL Server DB to the remote web server? To upload an Access DB, I just FTP the DB to the site directory. Pretty easy. If I understand right, you dont do that with a SQL Server DB, but rather replicate the DB to the remote server. I would like to understand how to move the SQL Server DB to a remote web server. Im trying to learn the steps and how it is done? Thanks in advance for any help.
-D-Follow these links :
http://support.microsoft.com/default.aspx?scid=kb;en-us;247931

http://www.faqts.com/knowledge_base/view.phtml/aid/3332

If this is not what you're looking then kindly come up with more explanation.sql