The sample database to be upgraded is Basic Northwindaccdb a version of Northwind with a naming convention applied to all objects and a limited number of queries forms and reports

Converting Access Tables to SQL Server Tables

To start the Upsizing Wizard, from the Ribbons Database Tools tab, click the SQL Server command from the Move Data group, as shown in Figure 18.26.

FIGURE 18.26

Starting the SQL Server Upsizing Wizard.

FIGURE 18.26

Starting the SQL Server Upsizing Wizard.

The first screen of the Wizard (Figure 18.27; just like the one in Access 2003) offers a choice to use the existing database or create a new one. Generally, it is a good idea to create a new database.

The Help button on the wizard screen shown in Figure 18.27 doesn't open context-specific Help, as you might expect. Instead of getting a topic with information that would help with the decision to use the existing database or create a new one, you get the main Access Help screen, with a Table of Contents and a Search box. This is not an improvement over previous versions of Access, where context-specific Help was generally available in wizards. In Access 2003, for example, if you run the Upsizing Wizard and click the Help button on the first screen, you will get a "Use the Upsizing Wizard" Help topic, with pertinent information for each screen of the wizard.

FIGURE 18.27

The first screen of the Upsizing Wizard.

FIGURE 18.27

The first screen of the Upsizing Wizard.

TTnT

0 0

Post a comment