Chapter 38: Upsizing Access Databases to SQL Server
1229
FIGURE 38.3
Selecting tables for the upsizing operationFIGURE 38.4
Specifying the table details for the upsizing process- The next screen (shown in Figure 38.5) allows you to either specify a new Access .adp
file, or simply link the upsize SQL Server tables to the current database.
Because our scenario is to completely upsize an Access application to SQL Server, and
because we want to use the SQL Server application for managing the tables and other
database objects on SQL Server, Figure 38.5 shows the Creating New Access Client/
Server Application option selected. The default name for the upsized .adp file is the
same as the current Access database with a CS suffixed.