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.
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 Chapter 19, Designing Client/Server Applications, in the Programmer's Guide. For information on optimizing client/server applications, see Chapter 22, Optimizing Client/Server Performance, also in the Programmer's Guide.