Hi Larry:

>Anyone have advice for upsizing a VFP7/Codemine application to SQL Server. I need to get the back end into SQL Server to be able to use it as a data source for a web-based application using ColdFusion and Dreamweaver.

Why do you need it in SQL server just to service a Web based application? How were you planning to present the Codemine application's functionality to the Web client - as a COM object? If so, a Codemine COM object can carry on talking to the VFP back end, no problem. If you want Coldfusion to talk directly to the data and you feel that this is easier to do if it is in SQL server, then fine. However, talking directly to SQL server will not provide access to your Codemine business logic. The only way to do this is via COM. In that case, your web application wont know or care that the data is in VFP or SQL server.

If you must take the application into SQL server, then given the very few number of tables and views in your existing application, you don't have too much work to do to get the data into SQL server. You just need to upsize the tables into SQL server and create Codemine cursor objects in the CDE based on remote view cursor type.

If you are using CDEs, then you are half-way there already. Make sure that you have housed most of your business logic in the CDE. This way, it will be available to the forms and web agent via COM.

If you want to ask anything more specific, feel free.