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<lous@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.3030803@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.