Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    124

    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:
    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 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.
    -D-

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Follow these links :
    http://support.microsoft.com/default...b;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.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •