Partager via

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.
  • Developing Visual FoxPro Applications
    This section includes conceptual information about how to develop Visual FoxPro applications, instructions for creating databases and the user interface, and other tasks needed to create Visual FoxPro applications.
  • Creating the Application
    Discusses how to create Visual FoxPro application, which may include one or more databases, a main program that sets up the application's system environment, and a user interface comprised of forms, toolbars, and menus.
  • Setting the Starting Point
    Describes how the main file is the starting point for your application, and can consist of a program or form. When your application is run, Visual FoxPro launches the main file for your application, which in turn runs all other components as needed.
  • Initializing the Environment
    Setting up the application environment is the first task that a main file or application object must accomplish.
  • Controlling the Event Loop
    Learn how to establish an event loop to, which causes Visual FoxPro to begin processing user events such as mouse clicks and keystrokes. This occurs after the environment is set up and you've displayed the initial user interface.
  • Creating Applications with the Application Framework
    Explains how to create applications with the Application Framework using the Application Wizard and the Application builder.
  • Client/Server Performance Optimization
    Learn how you can fine-tune your application to gain maximum performance by increasing data throughput.
  • Creating the User Interface
    Learn how creating forms, classes, controls, and toolbars can provide a rich set of tools for your user interface.
  • Creating International Applications
    Describes how you can design and develop your Visual FoxPro applications so they are as effective internationally as domestically.