Home > Articles

  • Print
  • + Share This
This chapter is from the book

Using the Upsizing Wizard

As mentioned in the previous sections, the Upsizing Wizard, included with Access 2002, greatly facilitates the process of upsizing to a SQL Server database. To invoke the Upsizing Wizard, follow these steps:

  1. Select Tools, Database Utilities, Upsizing Wizard. The Upsizing Wizard appears (see Figure 3.7). Here you can opt to upsize to an existing SQL Server database or to create a new database.

Figure 3.7Figure 3.7 The first step of the Upsizing Wizard allows you to create a new SQL Server database or to use an existing database.

  1. Make the appropriate selection and click Next. If you opt to create a new database, the Upsizing Wizard appears, as in Figure 3.8.

  2. Select the server where you want the database to reside.

  3. Enter a login ID and password with privileges to create a database.

  4. Enter a name for the new database. Click Next. The Upsizing Wizard appears, as in Figure 3.9.

Figure 3.8Figure 3.8 The second step of the Upsizing Wizard allows you to designate the server, a login ID, a password, and other important information required when creating a new database.

Figure 3.9Figure 3.9 The third step of the Upsizing Wizard allows you to select the tables that you want to upsize.

  1. Select the tables that you want to export to SQL Server and click Next.

  2. The next step of the Upsizing Wizard, shown in Figure 3.10, allows you to specify important information about what is included in the upsized tables. You can designate whether indexes, validation rules, defaults, and table relationships are upsized. You can also determine whether timestamps are added to the tables. Finally, you must designate whether table structures only or table structures and data are upsized. Make your selections and click Next.

  3. In the next step of the Upsizing Wizard, pictured in Figure 3.11, you can opt for Access to modify your database to create links to the new tables. If you prefer, Access will create an Access Data Project (ADP). Otherwise, you can opt for no application changes to be made. If you specify that you want access to create a new Access client/server application (ADP), you must specify the ADP filename. Click Next after making your selection.

Figure 3.10Figure 3.10 The fourth step of the Upsizing Wizard allows you to designate whether indexes, validation rules, defaults, and table relationships are upsized.

Figure 3.11Figure 3.11 In the fifth step of the Upsizing Wizard, you specify whether the wizard establishes table links or creates an Access Data Project file as part of the upsizing process.

  1. Click Finish. The database is upsized. Access produces an Upsizing Wizard report (see Figure 3.12). You should review this report because it contains important information about the status of the upsizing process. Figure 3.13 shows the result of upsizing the Northwind database.

Figure 3.12Figure 3.12 The Upsizing Wizard report provides important information about the upsizing process.

Figure 3.13Figure 3.13 The Northwind database after upsizing.

  • + Share This
  • 🔖 Save To Your Account