SQL Server Upsizing Wizard

The SQL Server Upsizing Wizard creates a SQL Server database that duplicates, as much as possible, the functionality of Visual FoxPro database. You can use the SQL Server Upsizing Wizard 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   Upsizing can take a long time, depending on the size of your data, the amount of network traffic, and the number of concurrent demands being handled by your server. Large tables may require several hours to upsize.

To run the SQL Server Upsizing Wizard

1. From the Wizards submenu on the Tools menu, choose Upsizing.
2. In the Wizard Selection dialog box, choose SQL Server Upsizing Wizard.

Wizard Steps

• SQL Server Upsizing Wizard: Step 1 - Select Local Database
• SQL Server Upsizing Wizard: Step 2 - Select Data Source
• SQL Server Upsizing Wizard: Step 3 – Choose Tables
• SQL Server Upsizing Wizard: Step 4 - Map Field Data Types
• SQL Server Upsizing Wizard: Step 5 - Select Target Database
• SQL Server Upsizing Wizard: Step 6 - Set Database Properties
• SQL Server Upsizing Wizard: Step 7 - Specify Log Properties
• SQL Server Upsizing Wizard: Step 8 - Set UpsizingOptions
• SQL Server Upsizing Wizard: Step 9 -Finish

See Also

Wizards Overview | Upsizing Visual FoxPro Databases | How the SQL Server Upsizing Wizard Works