Andrus,

If nothing else borrow some code from the wizard to help with the task.

It wouldn't be that hard to adir() your tables, loop through each onw USE it, afields() it and build a CREATE TABLE command that you can run via SPT.

Since you don't already have the tables in a DBC then you'll have a bit of work to build foreign key constraints.

You'll probably want to be more selective on the indexes you push up to SQL, what is there to make Rushmore work well won't necessarily be a good index for SQL.

>I have some hundreds of FoxPro 2 dbf,fpt,cdx files (free tables).
>
>I want to upsize database structures, indexes and data to SQL server.
>
>Is there any sample VFP code for this ?
>
>I looked into VFP Upsizing wizard but this requires dbc file.