You can use Visual FoxPro to create client/server applications that combine the functionality of Visual FoxPro on your local computer with the storage and security benefits provided by a remote server. You can build your application locally, and then use one of the Upsizing Wizards to transform the application for the client/server environment.
A Visual FoxPro client/server application combines the power, speed, graphical user interface, and sophisticated querying, reporting, and processing of Visual FoxPro with the seamless multiuser access, massive data storage, built-in security, robust transaction processing, and native server syntax of an ODBC data source or server. This means you can have the benefits of a Microsoft SQL Server or Oracle database without having to become a SQL Server or Oracle expert.
Visual FoxPro provides two upsizing wizards: the SQL Server Upsizing Wizard and the Oracle Upsizing Wizard. Both of these wizards create databases 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:
For More Information See Upsizing Visual FoxPro Databases, online in MSDN Library Visual Studio 6.0.