I have a database created without any nornalization criteria. There isn't primary or foreign keys. I want to introduce PK
and FK now. Also I'm going to remove some fields and change the format of others fields.
My tables has lot of records. Before introduce the structure changes I'm going to make a backup.
What kind of problems will I have when I try to reload the database? I suppose there will be problems with
format fields, and with referential integrity...any other problems?.
I suppose the order is important in the load process..isn't?. I will begin with the non-FK tables.
Any advice will be greatly apreciatted. Thanks