Unanswered: 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.
Iíve been searching for the information and have been unable to find what Iím looking for. I might be using the wrong keywords.
This is what Iím 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:
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 donít 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. Iím trying to learn the steps and how it is done? Thanks in advance for any help.