View Single Post

   
  #1 (permalink)  
Old 05-02-2008, 05:04 AM
John Sheppard
 
Posts: n/a
Default Orphaned tupels, should I clean or is it ok to leave?

Hello there,

I was wondering if anyone could give me some advice on orphaned rows and
foreign key constraints.

I am migrating a MS-Access database that didnt have any relations setup
properly, consequently there are gazillions of orphaned tuples.

If I was to leave these as they were and set constraints with NO CHECK is it
likly that I am going to run into problems down the track?

Some may shudder that I would consider not cleaning the data but we have a
timeline and there is months of cleaning to do, its something I would prefer
to do after we make our deadlines.

Thank you
John Sheppard


Reply With Quote