SQL vs MySQL vs MS SQL Express Advanced 1

[lifesupport]

I'm planning to transport a desktop application to the web. A spin-off of this application has already been put on the web by another programmer. He used ColdFusion with MS SQL, Access, VC, and Java. It is faster than the desktop application. Can I get the same results using MS SQL Express Advanced and Access for the internet version if used with .net? Are the select statements limited in power, accuracy, size, etc. for MS SQL Express Advanced when compared to SQL?

 

[onpnt]

SQL Server Express is not limited in how the database performs. Only growth restrictions and features. Access is a desktop database. A bit higher than excel. Yes it will cause bad performance. No it is not a true platform you should build your applications on in a true business environment unless perhaps you use it as the front-end application itself.

To answer your question is impossible without knowing what and how your application is doing what ever it is mean to do. Every tool (language/platform) has its cons and pros. .NET is far more superior than ColdFusion in many ways but I'm sure a CF guru would try and confront that. Although it would be an interesting and I think short discussion.

Anyhow, not much need to go further until for one you actually ask a SSRS question. Otherwise you may be better off in the forum654

_{____________ signature below ______________
You are a amateur developer until you realize all your code sucks.
Jeff Atwood}

 

[lifesupport]

RE: Yes it will cause bad performance. - I take it you're referring to MS SQL Express Advanced. If so, will MySQL work well?

 

[xlbo]

....still...nothing to do with SS Reporting Services.....

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[lifesupport]

Sorry for the wrong post, but I don't know enough on the topic as to where I should post it.

 

[mrdenny]

forum962 would probably be a good place.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com