Hello,

Our application's data is currently stored in VFP free tables, one set of tables in each customer's installation.

We want to programmatically convert each customer's VFP data tables with the help of an appropriate tool (to be determined), and with the following goals:

• End up with new properly normalized data tables
• Create new primary keys (integer) and corresponding foreign keys that maintain previously existing relations
• Change name of fields as indicated
• Fill the new tables appropriately
• Store the transformed data in a SQL Server database

Has anyone here done something like this?

TIA,

Alex