I never liked wizards, to begin with, because one looses control over how things are done, or what was in the mind of the VFP programmer when he/she developed the wizard. An example of that is the very intricated code you find inside your DBC when you want to apply RI to your tables. I never understood how it worked, and in addition, all error messages are in English, which is not a language most of my local clients are proficient with.
Having said that, I always tried to develop my own "wizards" to do things. And in the case of upgrading to sql server I simply developed my own two forms. One creates de SQL Server database, tables, constraints and indexes, fom the VFP DBC, and the other one rearranges VFP data to SQL Server standards and passes the information from the DBF to the SQL tables. Works very efficiently, using cursors adapters, and I do not need the VFP Ole provider at all. So Microsoft can deprecate it freely, I can't care less. Rafael Copquin El 15/09/2011 18:45, Ted Roche escribió: > On Thu, Sep 15, 2011 at 3:38 PM, Lou Syracuse<l...@iconmediadirect.com> > wrote: > >> We are taking small steps towards getting all our apps to SQ,L which we have >> only had a few months. These little problems will then go away (to be >> replaced with newer problems, most likely. Lol) > Oh, yeah. > > I think you have the experience to present a good argument to > management that migrating Fox data to SQL Server will be much more > efficiently done using VFP than the SQL Server import tools. I've done > this a few times, and using VFP to take the existing data, rearrange > or clean it to SQL standards, then pushing it to a SQL Server can be a > very efficient process. > > _______________________________________________ Post Messages to: ProFox@leafe.com 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/4e774f36.3030...@fibertel.com.ar ** 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.
