Conversion / migration tool question

RT Developers
1

This is probably a wish but along with this import tool, can I migrate from
mysql to postgres? Higher ups have decided that’s the new corp standard db.

Failure of import over here (this is with MySQL 4.0.9 - I just did the
upgrade).

A new import tool should be out later today which will resolve this
issue.

|[Thu Feb 6 11:04:36 2003] [warning]: DBD::mysql::st execute failed:
Column |‘Disabled’ cannot be null at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/|Handle.pm line 376.
| (/opt/rt3/lib/RT.pm:220)
|[Thu Feb 6 11:04:36 2003] [warning]: RT::Handle=HASH(0x8cbf0fc)
couldn’t execute |the query ‘INSERT INTO CustomFields (Queue, Creator,
Type, LastUpdatedBy, |Disabled, SortOrder, Created, Name, Description,
LastUpdated) VALUES (?, ?, ?, ?, |?, ?, ?, ?, ?, ?)’ at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm |line 383.
| (/opt/rt3/lib/RT.pm:220)
|[Thu Feb 6 11:04:36 2003] [crit]: Couldn’t create custom field
Arbeitsplatz at |dumpfile-to-rt-3.0 line 295.
| (/opt/rt3/lib/RT.pm:226)

Regards,
Harald Wagener

Harald Wagener * FCB/Wilkens * An der Alster 42 * 20099 Hamburg

rt-devel mailing list
rt-devel@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

�|� Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.
rt-devel mailing list
rt-devel@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

2

This is probably a wish but along with this import tool, can I migrate from
mysql to postgres? Higher ups have decided that’s the new corp standard db.

The postgres port isn’t well tested yet, but if you want to exercise it,
by all means report back :wink: The upgrade tool serializes data to a
database-neutral format. you should be able to switch engines when you
upgrade RT.

  • mz

»|« Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.