You want to know the best way, not lower cost way, correct? So, buy a Rational Rose for Linux, design you database in Oracle 7 mode and do script generation.
Works fine. Ah, remember: when connecting to SapDB, uses Oracle mode. Best regards, Edson Carlos Ericksson Richter Gerente de Tecnologia ECONET Soluções Web +55 61 326 5115 -----Mensagem original----- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Em nome de Dr. Thomas W. Richter Enviada em: Thursday, December 27, 2001 1:59 PM Para: [EMAIL PROTECTED] Assunto: Opinion on best way to create several tables Hi, I get on your nerves, I know... But I need the opinion of experts: I am using Linux, so there is no SQL-Studio. My database constists of more than 80 tables. I want to create the database in a batch-like mode. What is the best way to create tables? Using dbmcli with sql_execute is a little bit long-winded (you need to insert '/' and no comments allowed for the fields..). Is it a better choice to use PERL? Are there samples? Thanks in advance for comments Thomas