Rafael Copquin wrote on 2014-05-27: > I need to clarify this: > > In all my new apps I use SQLServer Express as the database engine, > however some all perfectly good apps that have been operating for years > are of course based on DBF. > > Some of those clients want to upgrade and include some web > functionality, but do not want to pay for the cost of migrating dbf's to > sqlserver. With SQLServer you have things like replication and even > without that you could access your server from the internet. You need > of course to enhance security, but then, if the money is there, the > thing is perfectly doable. > > But they do not want to pay for the effort of converting from dbf to sql > server (MySQL or whatever). And you know that there are no REPLACE, > BROWSE, LOCATE etc in SQL Server. So you need to replace zillions of > statements to SELECT or UPDATE. Plus the fact that some VFP functions > are nonexistent in T-SQL. So you need to create new functions or even > change some of them, from VFP syntax to T-SQL syntax (INLIST comes to > mind, a statement such as "INLIST(X,1,2,3)" becomes "X IN (1,2,3)" in > T-SQL). > > Again, that is a lot of work. But a client that has been using > successfully a DBF based app is very reluctant to pay for all that, just > to add "a simple web form" > > So, the idea to place some DBF's in the cloud came to mind, especially > in a free site. Lots of thrifty people down here :-( > > Rafael Copquin > >
Rafael, A temporary solution I've been working with, as our main program is being written with C#. I have a C# MVC hosted in IIS (or self hosted in a Windows Service) that uses a VFP COM object to access the data. VFP is returning XML which the Controller converts to the Model for the View. Tracy Pearson PowerChurch Software _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.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.
