Fellow DBA/DBD here. Now just realize that nearly all the criminal justice history kept at the State and Federal (FBI) level is also in ancient Oracle and DB2 databases with ton (tonnes for you Euros out there) of stored procedures and no foreign key enforcement. I will share sympathy with you on your upgrade/transfer as I plow through mine.
Fellow DBA/DBD here. Now just realize that nearly all the criminal justice history kept at the State and Federal (FBI) level is also in ancient Oracle and DB2 databases with ton (tonnes for you Euros out there) of stored procedures and no foreign key enforcement. I will share sympathy with you on your upgrade/transfer as I plow through mine.
OMG. To say nothing of the implicit type conversions that are allowed in Teradata. Monstrous.