<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - FIREBIRD: Migration: No migration possible with data in tables and declared realtionship" href="https://bugs.documentfoundation.org/show_bug.cgi?id=116980#c5">Comment # 5</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - FIREBIRD: Migration: No migration possible with data in tables and declared realtionship" href="https://bugs.documentfoundation.org/show_bug.cgi?id=116980">bug 116980</a> from <a class="email" href="mailto:drewjensen.inbox@gmail.com" title="Drew Jensen <drewjensen.inbox@gmail.com>"> Drew Jensen</a> <pre>Created <a href="http://bugs.documentfoundation.org/attachment.cgi?id=141469" name="attach_141469" title="screen shot of migrated database showing persons records.">attachment 141469</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=141469&action=edit" title="screen shot of migrated database showing persons records.">[details]</a> screen shot of migrated database showing persons records. Looks like it could be a sequencing issue now. Using the latest Linux 64 build. Downloaded the second attachment, TwoTablesRelated Tried to migrate the database, it failed with a constraint violation during a record insert. Closed without saving. Made a copy of the original. (TwoTablesRelated_mig) Opened the copy in hsqldb mode and deleted all the records in the persons table. Did not delete the records in sports table. Saved and closed the file. Opened the copy (as firebird) and the original (as hsqldb). Moved the persons table, via drag drop, from the original (source) to copy (target) and the data goes in without an error. The file is fully migrated with fk relationship and data. Screen shot attached.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>