Part VI: Access as an Enterprise Platform
1228
- The second dialog box of the Upsizing Wizard asks for the location of the SQL Server
installation you want to use.
In Figure 38.2, a SQL Server Express database has been selected running on a computer
named “DELL6000.” The Upsizing Wizard creates a new database on the selected server,
containing replicates of all the database objects (except for forms, reports, modules, and
macros) in the current database.
FIGURE 38.2
Specifying the SQL Server installation to receive the new database.- The third dialog box (shown in Figure 38.3) allows you to select which tables to export
to the SQL Server database.
Again, our scenario is to completely upsize an Access application to SQL Server, so all
tables have been selected in this dialog box.
- The next screen (shown in Figure 38.4) asks for a lot of details on the table attributes that
you want to upsize.
Generally speaking, if you’ve added an index or validation rule to an Access table, you
want the same attributes in a corresponding SQL Server table. Therefore, all the options
are selected on this dialog box by default. The Use DRI option is selected by default
because DRI (Declarative Referential Integrity) is much closer to the Access model of table
relationships than using triggers to maintain referential integrity. Using triggers means
that each table requires triggers (SQL statements that are executed whenever data in a
SQL Server table is changed) that ensure the proper relationships between tables are
maintained. Using triggers to manage referential integrity requires considerably more
work than DRI but is preferred in some situations, particularly situations where the data-
base administrator (DBA) prefers triggers over DRI for performance reasons.