SQL Server Upsizing Wizard

See Also

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.

For more documentation related to the SQL Server Upsizing Wizard, including a preview of information you might want to gather before using the wizard, see Chapter 20, Upsizing Visual FoxPro Databases, in the Programmer's Guide.

For general information about wizards, see "Using Wizards" in Chapter 1, Getting Started, in the User's Guide. For information about data type mapping, see "Mapping Visual FoxPro Field Names and Data Types to SQL Server Equivalents" in Chapter 20, Upsizing Visual FoxPro Databases, in the Programmer's Guide.

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

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