Oninit cdi / Archive
Talk to an expert →

triggers and views not created by dbimport

Posted in 2004

Topics: Triggers, Constraints & Referential Integrity, Migration, Import/Export & Data Conversion

LIXIN WU — — source: IIUG Forums & Mailing Lists

The "database.sql" file created by running dbexport contains all schema information for creating views and triggers. But the views and triggers are all missing in the new database created by running dbimport. Any help is greately appreciated.

↪ replying to LIXIN WU
pamadeo@cespi.unlp.edu.ar — — source: IIUG Forums & Mailing Lists

Hi, what's the last line in dbimport.out file? Mensaje citado por LIXIN WU <lixinwufeng@yahoo.com>: > The "database.sql" file created by running dbexport contains all schema > information for creating views and triggers. But the views and triggers are > all missing in the new database created by running dbimport. > Any help is greately appreciated. > > >

↪ replying to LIXIN WU
Gregory S. — — source: IIUG Forums & Mailing Lists

Did you use the -ss parameter ? IIRC this tells Informix to include the functions, types and other goodies. Greg Williamson DBA GlobeXplorer LLC ps glad to see the list back >> SUBJECT: triggers and views not created by dbimport [3565] >> URL: http://www.iiug.org/forums/ids/?rev=3565 >> AUTHOR: LIXIN WU >> DATE: Tuesday, 26 October 2004, at 9:50 a.m. >>The "database.sql" file created by running dbexport contains all schema >>information for creating views and triggers. But the views and triggers are >>all missing in the new database created by running dbimport. >>Any help is greately appreciated.

Glossary