Upsizing Visual FoxPro Databases

  • Article

When you have designed your client/server application, you are ready to build and upsize a local prototype. A local prototype is a working model of your application using Microsoft Visual FoxPro tables, views, and databases to represent data that eventually will be accessed on a remote server. Use the upsizing wizards to move databases, tables, and views from your system to a remote Microsoft SQL Server server.

In This Section

  • Goals for Prototyping
    When you use Microsoft Visual FoxPro to build a prototype of your application, you are leveraging the power of visual forms, wizards, builders, designers, and the Project Manager to quickly develop a working application.
  • Building a Local Prototype of an Application
    When you build a local prototype of your application, you might be starting from scratch, or you might be converting an existing Microsoft Visual FoxPro application to a client/server application.
  • Database Creation with Upsizing Wizards
    The Visual FoxPro SQL Server Upsizing wizard creates SQL Servers that duplicate, as much as possible, the functionality of a set of tables in a Microsoft Visual FoxPro database.
  • SQL Server Upsizing Wizard Preparation
    Before you run the SQL Server Upsizing wizard, you must prepare both the client and server sides.
  • Creating Client/Server Solutions
    Client/server applications combine the functionality of Microsoft Visual FoxPro on your local computer with the storage and security benefits provided by a remote server.
  • Client/Server Application Design
    Building on multi-user development technologies, learn how to design a powerful client/server application.
  • Implementing a Client/Server Application
    You can use SQL pass-through technology to enhance your upsized application. While remote views provide access to server data, SQL pass-through lets you send commands directly to the server using native server syntax, increasing your control and flexibility.
  • Client/Server Performance Optimization
    After upsizing and implementing, you can take additional steps to optimize the performance of your application. Find out what you can do in Microsoft Visual FoxPro and on the remote server to optimize your client/server application.