What is needed for a hoster / hosting company to be able to host .Net applications with SQL Server 2005 Express database
My questions regarding this issue basically are:
- If a hoster has several sites hosted on a server, can each one of them have its own SQL Express database
- Or, do they have to be migrated to full SQL Server
- What is with the Upsize Tool for SQL Server Express (or something like that) - is it available
- Generally, how do hosters do their hosting - do they have SQL Server SPLA signed Or do they just have SQL Server 2005 Express and allow users just to copy their web sites and databases to server
I would really appreciate any answer.
Kind regards,
Luka
Web hosting - ASP.NET with SQL Server 2005 Express database
Paul.Peat
1/ Yes this is the norm, a database pers customer
2/ In general I ahve seen most shared hosting with SQL Server Standard Edition and Workgroup Edition, dedicated starts with Express and then offers more.
3/ There is no upsize tool for express, you can either detach and attach the database files (they are the same format) or you can use backup and restore.
4/ Large numbers have signed SPLA and use Workgroup/Standard.