• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 3. Introduction to Client/Server... > Using the Upsizing Wizard

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.7. The first step of the Upsizing Wizard allows you to create a new SQL Server database or to use an existing database.


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

Figure 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.


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

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

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

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


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

7.
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.

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


8.
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.11. In the fifth step of the Upsizing Wizard, you specify whether the wizardestablishes table links or creates an Access Data Project file as part of the upsizing process.




9.
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.12. The Upsizing Wizard report provides important information about the upsizing process.


Figure 3.13. The Northwind database after upsizing.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint