Here is another option that we use:
Overview:
http://www.extendedsystems.com/ADS/default.htmHere is a cost comparison paper:
http://www.extendsys.com/NR/rdonlyres/e5hydl2agd7ps3q2xenvdmyvu57mvwhr7jzfznatwvm6yxjkbll55fwcsow4wrdd5gkdc263p7sgkfg7uxoukhjcnc/cost_comparison.pdfTracy
>Dear All,
>
>I have a general question:
>We are looking now on having our FoxPro database changed to SQL Server as a back database with the VFP forms and interface as a front interface.
>What I am curious to know is how fast could SQL be in comparison to VFP.
>Our main transactions table is about 1 million records long with 25 fileds.
>Is it worth upsizing at all? and if yes, will the data be much faster processed?
>Is it worthwhile buying SQL 2000 or SQL 7 can be sufficient?
>
>In the past I was told that my data must be very big in order to really have any profit from SQL, as for small database it is better and faster to process data in VFP. Is it correct? and if so to what data size and extend?
>
>I do appreciate your help.
>
>Thanks
>
>Jonathan Feldman
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"