|
|
Posted by <wipeout64 on 07/23/07 13:50
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" <raylopez99@yahoo.com> wrote in message
news:1185177937.413330.301830@g4g2000hsf.googlegroups.com...
> On Jul 22, 5:31 pm, <wipeou...@hotmail.com> 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
>
>
Navigation:
[Reply to this message]
|