It is bad habit to argue. But I like to share my expirience.
I this there is the difference between MS SQL and Oracle from VFP programming.
I tested speed of the work from VFP to Oracle 7 and MS SQL 7.
Second is much slower.
Calling Oracle procedure with select inside from VFP does not produce any cursors in VFP, calling MS SQL procedure with select will produce the cursor.
There is different mechanism how to assign the primary key for MS SQL and Oracle
MS SQL has identity , wich inserted like default value of the primary key, so key value became known after insert into table like @@identity.
In Oracle there is the sequence object to generate keys values, but it can not be used in default for field. So program should call identity and use it in insert command, so key value is known before the insert. I counted near 50 differencies between Oracle and MS sql, which makes the limitation on scalebale
program in VFP wich will work in simmetrical way for these products.
I am personnaly have not any preferance between these servers, my user commands me, if he will pay for Oracle, I make Oracle, if he desided to take MS SQL, it is OK for me, I am outside of war between companies to promote their servers.
MVP-2006-2011, PHD in Math and Physics ,
host of
www.foxclub.ru,
VFP lector at Interface and Microinform companies
Head science researcher of VNIIA Rosatom.