On 7/15/10 6:40 PM, Kent Belan wrote: > I have a client that has been going along great for the last 10 years. He is > now ready to explode. > > We are pushing the 2 gig limit now on the client table and he wants to add > tons more.
Well, that's good news. Work is good, right? > What do you recommend to solve the table size limit problem ? Upsizing to a server database. I'd recommend MySQL or Postgresql but I'm sure MS SQL Server will work just fine, too. > I know the answer is probably SQL server but I have never programmed to > access SQL. You haven't been seeing the writing on the wall for the past decade or so? ;) > I am guessing that this is going to be a huge job to covert the app from DBF > files > to SQL server. It depends. If you USE your data tables currently, it'll be a lot of work. On the other hand, if you use views and/or mostly SQL, you are much of the way there already. > Has anyone converted an app from DBF to SQL access ? I've converted 3 Fox/VFP apps to use MySQL. > Do I have to convert all the tables from DBF to SQL or can I just convert > the client table > and maybe a few others like transactions and payments ? You can certainly go one-by-one on the table conversions. Actually, you'll want to convert sets of related tables at once, so the server can do the joins. > I wish I had used business classes, it would have been much easier ... Is your data access logic sprinkled in the code pretty much everywhere? The nice thing about remote views and/or SPT is that you end up with cursors you can use just as if they were local Fox tables. So depending on your situation, it may not be too daunting to set up new data access methods while leaving most of your code alone. 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.
