Limit to the number of SQL Server Express databases?

[cat1]

Is there a limit to the number of SQL Server Express databases which you can have, provided you don't exceed your disk storage space?

[paulredpath]

We dont offer sql express databases.

[artigat1]

Hi,

have started using Visual Web Developer 2005 Express Edition and the SQL Server Express DB seems to be a pretty integral part of this. Do Catalyst2 plan to support this so that I can deploy my applications to my website?

At the moment I am really struggling trying to get an application to use the MySQL database that I have with Catalyst2. Any ideas how this can easily e achieved in Visual Web Developer 2005 Express Edition?

Thanks.

Steve

[WhiskyFudge]

Due to licensing problems that Microsoft impose, Catalyst2 are unable to support SQL Express. However any databases developed for SQL Express will work on SQL server 2005 which Cat2 will be launching in the future.

[LeeDJ]

Originally Posted by WhiskyFudge

Due to licensing problems that Microsoft impose, Catalyst2 are unable to support SQL Express. However any databases developed for SQL Express will work on SQL server 2005 which Cat2 will be launching in the future.

Sorry to dig up an old thread, but is this still the case? If I develop a DB driven web site using VS2008 and SQLExpress, when I deploy the DB to Catalyst, all I need to do is change the connection string; or is the process more complex than that?
Do you have some examples of before/after for the connection strings if this is the case, so I can gauge the changes required?

Thanks

[WhiskyFudge]

Obviously you will need to upload your database onto catalyst2's servers. SQL Server Hosting Toolkit - Home is an easy way of doing it. Generate a SQL script from your local dev copy, and then run the script on your database. Job done.

In terms of connection strings your just changing the host, username and password. The only possible real difference here is that you might be using windows authentication with your database whilst Catalyst2 uses SQL authentication. The difference can be seen at ConnectionStrings.com - How to connect to SQL Server 2005 with windows authentication being the trusted connection and sql authentication being the standard one.

If you need any further help, shout up.