sql express hosting

sql express hosting

• Charlie Bis

  No one will offer SQL2005 Express hosting - it'll be with a full blown SQL2005 Server. There is absolutely no difference to you, as the user, as to what you will be able to do with it.

  Do a search for Hosting SQL2005 and there will be a bunch of them.

  
  
  

• Bob Clemens

  Blimey this is hard work...I am not going to argue with you over the semantics of publish vs deploy vs anything else - to everyone else 'publishing a website' is a perfectily acceptable term. I shall re-phrase my question:

  My problem is, I have developed a website using VWD express with a mssql express database, I want to publish this and I am looking for a suitable host.

  I usually use unix/mysql/php. This is my fist windows/mssql/asp.net site. With mysql when I want to publish the content of a mysql db I use a tool called phpmyadmin which is provided by my unix webhost and allows for mysql admin functions such as the import/ export of db tables.

  I fully expect a windows host to create the mssql db for me and provide some sort of tool (like phpmyadmin mentioned above) so that I can import my sql express db tables into the db they provide me.

  What mssql admin tool should I look for a prospective host to provide

  Do I need to have mssql2000 db or mssql2005 db

  Thanks

  
  

• Daniel Reis

  Depending on the web host, if you upload a database to the site, they may not allow you to attach the database to SQL Server - they will have to do it for you. They don't want just anyone attaching databases. They will also restrict the database file size, location, etc. and make sure it plays nicely with all the other databases on the web host server.

  I think the word 'publish' is misused in this scenario - it's a nice cool phrase ("hey, I'm going to publish my application"). What you are doing is installing your application to a publicly accessable web server (which may mean something as simple as copying files to the server). But there may be extra steps, such as getting the database attached.

  
  
  

• crimson33

  http://msdn.microsoft.com/vstudio/express/vwd/features/deploy/default.aspx

  http://go.microsoft.com/fwlink/ LinkId=55702&clcid=0x409

  
  

• mr_trixter

  what do you mean by "It's unlikely you will be able to 'deploy' your project to a web host" Surely the whole point of producing a website is because I want to publish it onliner rather than just stare at it on my own pc Perhaps I misunderstand you.

  Your advice that I can carryon developing with sql express and deploy to sql server is useful - thanks.

  
  

• aydin1

  My point was, things have not changed, significantly, over the past 5 years: the mechanisims are still the same.

  If you have created a web page in Visual Web Developer, you will likely need .NET 2.0 framework, and ASP.NET. An provider offering that is likely to have SQLServer 2005 available. Different hosts will offer different tools. Contact them to see what you need to do to get your site up and running.

  Most reputable providers offer a 30 money back garantee: I know mine did - but I never left because they spectacularly great service. This will allow you to try it out and see that it'll do what you need.

  It's hard work because you are posting in the wrong place : talk to the people who provide hosting services, or on an ASP.NET forum. Good luck, but it's actually not as hard as I'm making it out - it's just like walking, you learn how to do it, then it's second nature..

  
  
  

• Gabriel Kevorkian

  SJWhiteley wrote:

  No one will offer SQL2005 Express hosting - it'll be with a full blown SQL2005 Server. There is absolutely no difference to you, as the user, as to what you will be able to do with it.

  As I understand it VWD is well integrated into sql express in that it allows easy creation, management and migration of a database from my development pc to a host. If I use sql2005 server hosting I will lose the advantage of easy development and 'drag and drop' deployment.

  Sql express was developed by MS as an easy alternative to compete with the likes of mysql. As such they addressed the limitations of MSDE and Access so that sql express could be used in live environments.

  If MS don't encourage hosters to offer sql express then they will have failed in getting VWD to their target market of hobbyists and small web developers who will just retreat back to dreamweaver/php/mysql.

  
  

• xian_ve

  It's unlikely you will be able to 'deploy' your project to a web host, but I'm not a web host, so wouldn't really know. Regardless, if you develop your database using SQL Express, it will work seamlessly with any version of SQL Server 2005. SQL Express is SQLServer 2005.
  
  

• KeyWhacker

  hi,

  i guess in registeration benefits there are a hosting offer about 30 or 90 days i don't remember i guess this will help you to test, but for sure its not express edition at least its SQLServer 2005 but it will run your database that you creat by express edition, also i think the asp.net forum would have more information about that

  hope this helps

  
  
  
• sql express hosting