I'm working on getting DotNetNuke site together which I plan on host on HostMySite (shared hosting account). I'm developing it locally, and I'm trying to decide whether I should build it with SQL or SQL Express in mind. Using SQL Express would probably make it easier to move the site from my dev machine to my hosting account, but I presume that I will get better performance using the shared SQL Server 2005, rather than a SQL Express 2005 file saved in my hosting account directory? Do you even support SQL Express?

Thanks

Usually, all versions of SQL 2005 are upgradable. Meaning, if you develop on SQL express, you can restore the database to a stardard, workgroup or enterprise. All I do is develop my databases on the Developers edition, create a backup, and submit a support ticket and have support restore my database.

You could use Import/Export (not on express though) to send your data to HMS, but the Import/Export won't hold Keys and whatnot.

SQL Express isn't support in HostMySite's shared environment, so for ease of transfering to the hosting account, you might want to use SQL. Thay way you can just create a bak like Jason and sent it off to support to restore it. If you use Express, you'll have to run a couple more steps to make the scripts to import it into SQL.