Re: Parse-Dia-SQL foreign key

Alex, many thanks for your message.

My experience has been with Parse::Dia::SQL from CPAN. I have not been
using dia2code. However I did download it and read about it some.

I am not sure about the FK naming convention. My fact table might have
20 surrogate keys pointing to a dimension. They cannot all use the
"id" name. The foreign keys are not part of the primary key of the
fact table.

Can dia2code generate the SQL for creation of foreign keys? I did not
see one in the examples.

Does dia2code produce different SQL based on the target database?
Oracle, DB2, Postgress, Pure Data/Netezza, MySQL, etc.?

I tried to join the dia2code general mailing list, but I do not think
I have been successful yet.

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]