Share via

Database Creation with Upsizing Wizards

  • Article

The Visual FoxPro SQL Server Upsizing Wizard creates SQL Server that duplicate, as much as possible, the functionality of a set of tables in a Visual FoxPro database. You can also choose to redirect Visual FoxPro views so that they use the newly created remote data instead of local data. You can use the Upsizing wizards to:

  • Move local data to a remote server.

  • Transform local base tables and local views into remote base tables and remote views.

  • Migrate a local application to a client/server application.

    Note   Though the Upsizing Wizard accesses SQL Server, you can create a client/server application for any remote ODBC data source. For servers other than SQL Server, you can use SQL pass-through functions to create remote tables, then use Visual FoxPro to create remote views that access server tables. For more information on using SQL pass-through functions, see Implementing a Client/Server Application. For information on creating remote views, see Creating Views.

See Also

Building a Local Prototype of an Application | SQL Server Upsizing Wizard Preparation | Upsizing Visual FoxPro Databases | Goals for Prototyping