The upsizing process needs a running SQL Server
installation.
If, on the other hand, you??™re using a SQL Server instance running on another computer on the network,
it is almost surely up and running, and there is nothing more for you to do.
1251
Upsizing Access Databases to SQL Server 41
Running the Upsizing Wizard
After you??™ve completed the steps to prepare for the conversion, you??™ re ready to upsize your application.
First, open the Microsoft Access database that you want to convert. This example upsizes
the database for this chapter (Chapter41.accdb??”make sure you use the original copy). Keep
in mind that the result of the upsizing wizard is a brand-new Access .adp file already linked to the
SQL Server database created by the Upsizing Wizard. Your original .accdb file remains
unchanged:
1. Open the Access database for this chapter (Chapter41.accdb).
2. Select the Database Tools tab.
3. Select the SQL Server option from the Move Data section.
The first dialog box of the Upsizing Wizard is shown in Figure 41-1.
Pages:
2274
2275
2276
2277
2278
2279
2280
2281
2282
2283
2284
2285
2286
2287
2288
2289
2290
2291
2292
2293
2294
2295
2296
2297
2298