VWD Capabilities?

Hi:

I've been to the product comparison page at http://msdn2.microsoft.com/en-us/vstudio/aa700921.aspx and still have a number of questions.

I would like to create a small web site with a couple of custom, data driven applications on it. Can the SQL Server Express databases that I am creating on my local machine be uploaded to a commercial host that has the asp 2.0 framework on it. Do I have to get a host that would rent me use of a sql server database - or is my sql server express database part of the asp 2.0 standard framework? Can I start with a SQL Express database for a small commercial client and then migrate up to full SQL Server? What are the main limitations that I will find with the SQL Server Express database - and the VWD engine?

Any help greatly appreciated.

Regards,

Roger

SQL Server is RDBMS(relational database management systems) you need a SQL Server to run your database and you can either buy one with a hosting company package or host it in house. Express comes with most except the Agent, Profiler and what we call the calculus end SSIS(sql server integration service), Reporting Service and Analysis service. Post again if you still have questions. Hope this helps.

Thanks so much for your reply Gift. In your experience, what is the biggest limitation that I am likely to run up against in using SQL Express? In doing further research, I see that there is also a limit of 1CPU, 1Gb adressable RAM and 4Gb database size.

Regards

Roger

You can manage the size issue with backup and truncate the log file look it up in the BOL(books online). if you are hosting in house just buy the Developer edition it comes with the Profiler you can use to profile Express database, it also comes with the Tuning Advisor which can recommend indexes for your tables and try not to write SELECT * stored procs. I think if you do the above you can use Express to run a site of 1000 or more read users.