Share via


Database Creation with Upsizing Wizards

The Visual FoxPro SQL Server Upsizing Wizard creates a SQL Server database that duplicates the functionality of a Visual FoxPro database as closely as possible. You can also 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 Enhancing Applications Using SQL Pass-Through Technology. For information on creating remote views, see How to: Create Remote Views.

In This Section