I can't think of any reason to use free tables other than to allow older FoxPro applications to access the data. DBCs provide features like long field names, triggers, defaults, etc. These are all SQL Server features so it would be easier to write a VFP application that works like a SQL Server application.
By the way, to make the transition to SQL Server easier you should try to write your application using views and/or SQL statements to access all data. If you use SQL statements you may want to have one or more procedures you call to execute the SQL. You could then change the procedures to send the SQL commands to SQL Server instead of executing them in VFP. This will make it pretty easy to move to SQL Server.
>I'm looking for some information on the pros and cons of VFP database containers vs free tables. My company may migrate to SQL server using VFP as a front-end so that needs to be considered as well. Any information that you can provide is appreciated!