Hello,

I am attempting to perform an SQL Server7 to 2000 migrations. However
where my database schema is concerned I am receiving error messages. ie.

ALTER TABLE statment conflicted with COLUMN FOREIGN KEY constraint
'FK_AsdaOrders_RDC_4CAD06362'. The conflict occurred in database RFTest,
table 'DeliveryPoints' column 'Depot'

I have tried going into the db diagram to the relationship and changing the
properties. Still I have no success?

Do you have any suggestions?

Thank you kindly
Rhonda

Hi Rhonda,

Is there data in the table? If yes, save the data out using a 'select...into tmp_name..." table. Make sure you have the FK definition so you can reapply it. Drop the FK, alter the table, reapply the FK and reinsert the data.

This is the reader's digest condensed version of the actual process, but it should give enough of a start to help. If you need some assistance, please feel free to drop me an email.

Regard,
John Miceli, MCDBA
jmiceli (AT) wrberkley (DOT) com

"Rhonda Fischer" wrote: