Upsizing wizard and Referential Integrity Question

[Charles E Finkenbiner]

Hi All,

I have transfered my Access database file into MS SQL using the upsizing
wizard. There are 5 tables that have relationships with each other and
I have also set the 'Referential Integrity', including 'Cascade Update
and Delete' option.

Now, after the transfer to SQL I see that these 5 tables still have a
relationship setup but I have noticed that only the 'Enforce
relationship for replication' checkbox is checked. The 'Enforce
relationship for INSERTs and UPDATEs checkbox is NOT checked and the
'Cascade Update Related Fields' and 'Cascade Delete Related Records'
checkboxes for greyed out.

My question: Did the Upsizing wizard make a mistake by NOT checking the
checkboxes for INSERTs, UPDATEs and DELETE? Or did it do it correctly
and I should leave these checkboxes unchecked?


Thanks for any help,

Charles

 

[Charles E Finkenbiner]

Hi All,

Never mind, while continuing my search for an answer I found that I had
to use the DRI method during the upsizing. Problem solved now.


Thanks for looking,

Charles