If Remote Data Does Not Exist

If the remote data does not exist when you begin your VPM Enterprise client-server application, someone has to create it. If that someone is you, there are two alternative approaches you can take that will automate much of the work for you:

Alternative 1 - Visual FoxPro Upsizing Wizard

If the remote data will reside in a SQL Server database, you can prototype the data by creating a database, local tables and local views using the VPM Enterprise Data Builder and Visual FoxPro data creation tools. Then, when you complete the prototyping, you can use the Visual FoxPro SQL Server Upsizing Wizard to create remote views and to move the data structure to the server. The VFP SQL Server Upsizing Wizard creates SQL Server databases that duplicate, as much as possible, the functionality of a set of tables in a Visual FoxPro database. Of course, if you need to upsize to a different type of server database, you're out of luck with the VFP Upsizing Wizard.

Tip How to Prototype an Application with VPME: The next section How to Prototype an Application with VPME describes the benefits of protyping and how to do it.

Tip: When you use the VFP Upsizing Wizard, we recommend that you do not select Redirect views to remote data in the Set Upsizing Options step, in the Changes to make locally area. When you use VPM Enterprise to prototype a client-server application, you normally want to maintain both local and matching remote views. The local views are needed so that you can continue to test your application using local data after you run the Upsizing Wizard. VPME provides a switch in the Data Builder that allows you to choose when a local view or its matching remote view should be used for forms. Therefore, you do not need to let the Upsizing Wizard convert your local views to remote views.

Alternative 2 - xCase Professional and xCase2VPM:

A better alternative is to prototype the data using xCase Professional from Resolution Ltd (http://www.xcase.co.il/). xCase is a data modeling and creation tool that provides many advantages over the data creation tools provided by Visual FoxPro. The xCase view designer has many advantages over the Visual FoxPro View Designer. xCase is capable of helping you create the kinds of complex views you will probably need for a client-server application. When it comes time to upsize the data you have created in xCase Professional to a database server, xCase's automated capabilities are not limited to SQL Server. xCase also supports Oracle, Sybase, SQL Anywhere, Informix, DB2, and Interbase.

xCase2VPM (http://www.promatrix.com/xcase2vpm/xcase2vpm01.htm) from ProSysPlus (http://www.prosysplus.com) moves the data you have prototyped in xCase into the VPM Enterprise data dictionary tables. The combination of xCase Professional and xCase2VPM give you tools (1) that will significantly decrease the time required to prototype your data, (2) that will give you more back-end database options, and (3) that will move the prototyped data to both your database server and to VPM Enterprise.

Tip: Using xCase to prototype your data and xCase2VPM to move it into VPM Enterprise, saves considerably on the time required to set up data properties in the VPM Enterprise Data Builder.

More:

How to Protype an Application with VPME