PfiKXKaieQBaSH OK on it before clicking Next on the second screen of the Upsizing Wizard

If you don't run into one or another roadblock, you will get the third screen of the Upsizing Wizard, shown in Figure 18.32, listing the tables in the Access database for selection.

Selecting Access tables for upsizing to SQL Server.

Selecting Access tables for upsizing to SQL Server.

I selected all the tables with data (leaving out tblBackupInfo and some lookup tables). After selecting the data tables to upsize, on the next screen (Figure 18.33) you can select various attributes to export.

FIGURE 18.33

Table attributes to export.

FIGURE 18.33

Table attributes to export.

Next, you can select to create a new Access client/server application, or link the new SQL Server tables to the existing Access front end. For this section, to convert just the tables, I chose the link option (see Figure 18.34).

FIGURE 18.34

Selecting the Link option for connecting to SQL Server.

FIGURE 18.34

Selecting the Link option for connecting to SQL Server.

Finally, the Upsizing Wizard success screen appears (Figure 18.35); click Finish to proceed to do the upsizing using the selected choices.

FIGURE 18.35

The last screen of the Upsizing Wizard.

FIGURE 18.35

The last screen of the Upsizing Wizard.

You will get a dialog, shown in Figure 18.36, with a progress bar listing each table in turn.

0 0

Post a comment