MS SQL Express Advanced vs MS SQL full version vs MySQL

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 (written in VFP).
1. Can I get the same results using MS SQL Express Advanced and Access for
the internet version if used with .net?
2. Are the select statements limited in power, accuracy, size, etc. for MS
SQL Express Advanced when compared to SQL?
3. If Access will perform poorly, can VFP be used instead with .net? I
already know it can't be used with ColdFusion. 4. If MS Express Advanced
will not sufficiently replace SQL, will MySQL do the job better?

Thanks

Re: MS SQL Express Advanced vs MS SQL full version vs MySQL

On Jul 22, 5:31 pm, wrote:
> 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 (written in VFP).
> 1. Can I get the same results using MS SQL Express Advanced and Access for
> the internet version if used with .net?
> 2. Are the select statements limited in power, accuracy, size, etc. for MS
> SQL Express Advanced when compared to SQL?
> 3. If Access will perform poorly, can VFP be used instead with .net? I
> already know it can't be used with ColdFusion. 4. If MS Express Advanced
> will not sufficiently replace SQL, will MySQL do the job better?
>
> Thanks

I don't know nothing, but I can attest that MS SQL Server is not
compatible with MySQL--lots of commands are different.

For pure speed, I "heard in the street" that Oracle's version of SQL
is faster than MSFT's. But, because MSFT uses a different protocol
for starting and stopping transactions (for multiuser databases,
involving ROLLBACK), it is slower but in theory "more safe" than
Oracle (small victory for MSFT, since usually speed trumps safety).
MySQL also uses the "MSFT" protocol, so is slower than ORCL for
transactions.

MS Express has extensions to SQL but I doubt it will "replace" SQL.
Nor will any proprietary extension of SQL.

I like MS SQL Server 2005 because it is integrated better into my API
(C# using VS2005), but to be honest MySQL extensions for subqueries
are more intutitive for me. But MySQL lags in development to MSFT--
for example versions 4.x did not have Stored Procedures or Views (!).
And, like I say, I don't like the hassle of translating MySQL <--> MS
SQL Server 2005.

If you spend $50 you can get the "developer" version of MS SQL Server
2005; highly recommended and superior to the free version. Spend the
fifty bucks.

Remember, I don't know much about SQL, but these are my newbie
thoughts.

RL

Re: MS SQL Express Advanced vs MS SQL full version vs MySQL

(wipeout64@hotmail.com) writes:
> 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 (written in VFP).
> 1. Can I get the same results using MS SQL Express Advanced and Access for
> the internet version if used with .net?

Probably. But you could also get worse performance. It's difficult to
answer, because it depends on how you do the implementation. DB engines
are extremely powerful tools to make things to really slow if you don't
do things right.

> 2. Are the select statements limited in power, accuracy, size, etc. for MS
> SQL Express Advanced when compared to SQL?

Compared to what? If you mean if there are limitations in SQL Express
vs. the paid-for editions of SQL Server, the answer is, yes, there are
some limitations, but it is not all likely that you will suffer from
them.

First of all, the language is the same, so the SELECT statements that
runs in Enterprise Edition runs in SQL Express too. And there is no
difference in accuracy, and hardly in size of the statements either.
There is a difference in database size: with SQL Express, you cannot
have databases over 4GB in size.

The difference in performance lies in some special optimizer tweaks, like
considering using indexed view. But for the major bulk of queries,
query plans and performance are the same.

> 3. If Access will perform poorly, can VFP be used instead with .net? I
> already know it can't be used with ColdFusion. 4. If MS Express Advanced
> will not sufficiently replace SQL, will MySQL do the job better?

Those questions are completely beyond the scope for this newsgroup,
and also beyond my knowledge.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx

Re: MS SQL Express Advanced vs MS SQL full version vs MySQL

For a newbie " $50 you can get the "developer" version of MS SQL Server
2005" is the best news I've heard so far! Thanks much!



"raylopez99" wrote in message
news:1185177937.413330.301830@g4g2000hsf.googlegroups.com...
> On Jul 22, 5:31 pm, wrote:
>> 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 (written in VFP).
>> 1. Can I get the same results using MS SQL Express Advanced and Access
>> for
>> the internet version if used with .net?
>> 2. Are the select statements limited in power, accuracy, size, etc. for
>> MS
>> SQL Express Advanced when compared to SQL?
>> 3. If Access will perform poorly, can VFP be used instead with .net? I
>> already know it can't be used with ColdFusion. 4. If MS Express Advanced
>> will not sufficiently replace SQL, will MySQL do the job better?
>>
>> Thanks
>
> I don't know nothing, but I can attest that MS SQL Server is not
> compatible with MySQL--lots of commands are different.
>
> For pure speed, I "heard in the street" that Oracle's version of SQL
> is faster than MSFT's. But, because MSFT uses a different protocol
> for starting and stopping transactions (for multiuser databases,
> involving ROLLBACK), it is slower but in theory "more safe" than
> Oracle (small victory for MSFT, since usually speed trumps safety).
> MySQL also uses the "MSFT" protocol, so is slower than ORCL for
> transactions.
>
> MS Express has extensions to SQL but I doubt it will "replace" SQL.
> Nor will any proprietary extension of SQL.
>
> I like MS SQL Server 2005 because it is integrated better into my API
> (C# using VS2005), but to be honest MySQL extensions for subqueries
> are more intutitive for me. But MySQL lags in development to MSFT--
> for example versions 4.x did not have Stored Procedures or Views (!).
> And, like I say, I don't like the hassle of translating MySQL <--> MS
> SQL Server 2005.
>
> If you spend $50 you can get the "developer" version of MS SQL Server
> 2005; highly recommended and superior to the free version. Spend the
> fifty bucks.
>
> Remember, I don't know much about SQL, but these are my newbie
> thoughts.
>
> RL
>
>

Re: MS SQL Express Advanced vs MS SQL full version vs MySQL

Your answers are very helpful! Now a rather niave question: If I pay for a
site to host my application, does that mean I don't have to purchase the
server software and I only need the developer software?


"Erland Sommarskog" wrote in message
news:Xns997668DB16155Yazorman@127.0.0.1...
> (wipeout64@hotmail.com) writes:
>> 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 (written in VFP).
>> 1. Can I get the same results using MS SQL Express Advanced and Access
>> for
>> the internet version if used with .net?
>
> Probably. But you could also get worse performance. It's difficult to
> answer, because it depends on how you do the implementation. DB engines
> are extremely powerful tools to make things to really slow if you don't
> do things right.
>
>> 2. Are the select statements limited in power, accuracy, size, etc. for
>> MS
>> SQL Express Advanced when compared to SQL?
>
> Compared to what? If you mean if there are limitations in SQL Express
> vs. the paid-for editions of SQL Server, the answer is, yes, there are
> some limitations, but it is not all likely that you will suffer from
> them.
>
> First of all, the language is the same, so the SELECT statements that
> runs in Enterprise Edition runs in SQL Express too. And there is no
> difference in accuracy, and hardly in size of the statements either.
> There is a difference in database size: with SQL Express, you cannot
> have databases over 4GB in size.
>
> The difference in performance lies in some special optimizer tweaks, like
> considering using indexed view. But for the major bulk of queries,
> query plans and performance are the same.
>
>> 3. If Access will perform poorly, can VFP be used instead with .net? I
>> already know it can't be used with ColdFusion. 4. If MS Express Advanced
>> will not sufficiently replace SQL, will MySQL do the job better?
>
> Those questions are completely beyond the scope for this newsgroup,
> and also beyond my knowledge.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx

Re: MS SQL Express Advanced vs MS SQL full version vs MySQL

(wipeout64@hotmail.com) writes:
> Your answers are very helpful! Now a rather niave question: If I pay for a
> site to host my application, does that mean I don't have to purchase the
> server software and I only need the developer software?

Right. If you only use MS SQL Server to develop your application, but rely
on a web host to run it for you, you can get by with Developer Edition,
which is 50 USD. And, of course, if you are content with the features of
SQL Express, you can let it suffice with that for an even lower bargain.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx