On Tue, Feb 26, 2008 at 6:18 PM, Rick Schummer <[EMAIL PROTECTED]> wrote: > >> Is this an easy way to manage using a local dbf backend versus easily > >> upsizing to a non-dbf > backend eventually, all with the click of a checkbox in the Advantage > configuration utility? That's > what it sounded like to me. Rick -- you commented....is that the way you > interpreted it?<< > > I have just started to play with it. I am not an expert in the database yet. > But everything I have > seen and read has me pretty impressed with the product.
We've been using Advantage SQL with our app for a few years and I'm quite impressed. This is not a VFP app but it's written in xBase++, a Clipper compiler (although it does have GUI classes like VFP). The nice thing about xBase++ is that it provides a Advantage database engine that you can use instead of the fox/clipper type engine. Basically this means you can use USE, SKIP, SEEK etc without *any* code changes (apart from a few caveats of course!). > The Advantage Database Server is a price per seat business model which may > turn some people off the > backend database, but the costs of the licensing is likely cheaper than the > cost of the upsizing > code if you are not doing SQL Server and using the new Sedna upsizing > wizard. I think if developers > do a serious cost analysis they will see some interesting possibilities. One thing you didn't mention is the ADS local server. This is a free product that doesn't require a server installation. The API is still the same and supports multiple clients. Obviously performance is lower, transactions are not supported and you don't get the protection from file corruption etc. However it's very handy if you have clients with only 1 or 2 users that can't afford the full blown client/server support. The local server requires no installation, you just need to provide the DLLs (you may need to install the ODBC driver though). If you become a reseller (as we are) you get a 35-40% discount on the cost of the server product, depending on the volume you sell. The upcoming 9.x version supports more (all?) of the extra VFP9 datatypes like varchar, datetime, autoinc, etc. They've improved the VFP upsizing wizard too. One thing I don't like is the syntax of stored procedures/functions etc. It's quite different from Transact SQL (MS/Sybase) that I'm used to which could be a problem if you plan to support multiple SQL servers. -- Paul _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
