Share via

SQL Server Upsizing Wizard: Step 3 – Choose Tables

  • Article

In this step you select the Visual FoxPro tables you want to export to SQL Server.

  • Available tables
    Lists all the tables stored in the database you've chosen to upsize.

  • Selected tables
    Lists the tables you've chosen to upsize into the database on the server.

    You must select at least one table, and you can choose the >> button to export all tables.

When you choose Next, the SQL Server Upsizing Wizard reads the list of tables you've selected to upsize and tries to open those tables for exclusive use in the database you choose to upsize. Any tables that can't be opened exclusively won't be available to upsize. The tables are opened exclusively to prevent other users from changing the data in the tables during the upsizing process, which helps to ensure the accuracy of exported data. If any tables are already open and shared, the wizard closes them and then reopens them exclusively; this might cause you to lose any temporary relations established with the SET RELATION or SET SKIP commands.

Choosing Tables to Export

It's very important to choose the tables you export carefully, as this choice has a significant impact on the performance of your application. Exporting all tables might result in excessive (and slow) server queries. A well-designed client/server database usually consists of a mix of local and remote tables.

In general, keep tables, which change rarely or infrequently, in your local database, such as a table of state names and abbreviations. Export tables that change frequently and are accessed by many users, such as a table of orders.

The SQL Server Upsizing Wizard exports the table's field names, data types, and data. For information about storing tables in the best location, see Designing Client/Server Applications. For information on optimizing client/server applications, see Optimizing Client/Server Performance.

See Also

SQL Server Upsizing Wizard | SQL Server Upsizing Wizard: Step 1 - Select Local Database | SQL Server Upsizing Wizard: Step 2 - Select Data Source | 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 Upsizing Options | SQL Server Upsizing Wizard: Step 9 - Finish | Wizards Overview