SQL Express possible

Discussion in 'Pre-sales questions' started by Mark, Sep 17, 2009.

  1. Mark

    Mark Guest

    I've read in the knowledge base that it's not advisable to use sqlexpress in a shared web hosting environment but my question is , is it possible to use sql express databases to be hosted on your site? Or should I convert to sql server 2005 and create databases in it before uploading it to your hosting area?

    Thanks
     
  2. Ray

    Ray

    Unfortunately we do not support SQL Express on our shared hosting environment. We only offer SQL 2008 databases.
     
  3. Although you cannot use SQL Express database files directly on the server, there shouldn't be a problem with continuing to use it in your development environment. Then when it comes to deploy to your live Winhost site you do the following:

    1. Use the SQL Publishing Wizard to import/export your SQL Express database to your Winhost SQL 2008 database.

    2. Change the connection string in your ASP.NET application to point to your Winhost SQL 2008 database.

    3. Upload your app.
     
    Last edited by a moderator: Oct 14, 2015
  4. Mark

    Mark Guest

    Thank you for your response.. So I can just download SQL publisher for free then convert my MDF file to be compatible with SQL server 2008 before putting it in live?
     
  5. Mark

    Mark Guest

    btw, I'm using SQl Express for development.

    Thanks
     
  6. Last edited by a moderator: Oct 14, 2015
  7. Mark

    Mark Guest

    Thanks for everything .... I'll be signing up with Winhost by this week ....

    Thanks for prompt responses.

    Cheers
     
    Last edited by a moderator: Oct 14, 2015
  8. Guest

    Guest Guest

    Actually I have found it far easier--and faster--to use the Import and Export Data utility that comes with Management Studio. It took just a few seconds to upload 80 meg data.
     
  9. Good idea. Thanks for the post!
     

Share This Page