Upsizing Parameters

-Tabte Attributes to Export

® Indexes 3 Validation rules ¡3 Defaults d Structure only, no data

Table relationships:

Up sized using DRI

Tlmestamp fields added:

Some tables

Modifications to Existing Database -

d Attach newlycreated D Save password and

SQL Server tables user ID with attached tables

CEEent/Servei' Modifications -

® Create a new Access D Save password and client/server user ID with application. application

Figure 9.35

14. After the upsizing is completed, the new Access Project is displayed, as shown in Figure 9.39. If you had instead selected the option to keep the existing MDB open, that database would have been displayed instead.

15. If you navigate to the Queries objects in the Database Window, you can see that the previous queries were upsized to various stored procedures, views, and functions. This is illustrated in Figure 9.40.

After the database has been upsized, you must correct any errors that were encountered and retest the functionality of the database to ensure that the objects were converted correctly. After these issues have been resolved and the application has been tested, you are ready to let your users work with your new SQL Server application from the Access Project.

Table: Products

Microsoft ACCESS

SQL Server

Table Name! Pio-ducis

Products

Mtached Table Name:

Aliasi ng Query:

Validation Rule:

Fields

M i era soft Access

SQL Server

Field Name:

ProducCD

Product SD

Data Type:

H u IV be r [ Long)

'ni

Field Name:

Prod uotNa me

Product Name

Data Type:

Text:;40}

n •••s. rcha rj 40}

Field Name:

£upf er!D

SupperiD

Data Type:

Number (Long)

-t

Field Name:

CstegoryiD

CetegoryJD

Data Type:

Number [Long}

:nt

Field Name:

^janttyPerUnl

QuentitvPerfJn't

Data Type:

Text(2(J}

rv/archartlO)

Field Name:

UntFrce

Un'tPrte

Data Type:

Currency

money

Validation Rule:

>=0

AL_ER "AELE [Products] ADD CONSTX «¡ttl* [Oí Products UntPr:=] CHECK (Ur tPrr^>=0)

DíEC s p_adde>dended property N MEConstnsntïext. N'You mict entera pea ¡fi ve nu m ber., N use r ■ N ±c . N tab e. N Products . N const r= Inf. N CK Products Unt Price

Figure 9.36

0 0

Post a comment