Kenneth,

>How did you modify your existing local views to point to the sql data? Don't you have to use remote views? If there is a way to just modify them that will take out a big chunk of time and will make me very happy =)...

If I remember correctly, the upsizing wizard will automatically create remote views for you after it creates the SQL tables and can create remote views also based on existing local views. You can check an option to save the SQL it generates -- so run an upsizing run with a small set of data at first (because the SQL generated will include insert statements for each row of data). Once you have the SQL saved, you can then take it and tweak it as needed, then perhaps write your own conversion program to actually put the data up into SQL Server.

In other words, look at the wizard as a tool to help you get your SQl Server set up (and remote views created), but not as the be-all and end-all ultimate conversion tool.

Also, you might look into CursorAdapter, which I have used on a large VFP to SQL conversion recently. I have some tools for quickly creating CA subclasses from a DBF with metadata about tables/fields, and Mark McCasland also has a good utility to create CA subclasses from tables already in SQL Server. CursorAdapter is like a remote view on steroids and is very flexible, since it gives you access to hook events and properties to customize far beyond what you can do with remote views. (CA also doesn't require a DBC).

Give me a yell by email and maybe we can get together soon to bat around some ideas over lunch in your town or mine.