Hi,

I would like to create a program to take free tables directly to SQL Server. SQL Server's Data Transformation Services is not a very good option in this case because the free tables are encrypted (in the Fox environment I decrypt on the fly) and also because table structure is not identical for every migration made. As you know DTS creates a structure-specific program to do the conversion.

A second need in the same general area is for a VFP routine to update table structure of SQL Server database given a "model" database of my own. In other words, some small change in the structure has occurred in my office and I need a routine to synchronize client's SQL database structure with my "model".

Thank you all for your help with this question and for all the help you have given me and so many others in the past. Merry Christmas.

Alex