Hopefully this isn't a cross post issue, but I recently had an issue whereby I need to move my XAF app from Access to Postgre as Access didn't support complex queries, large amounts of relations (constraints) etc.

I chose to go with PostgreSQL v8.3 as my next step as it was free and have had some dealings with it in the past.

The issue I had was I couldn't find a commercially available product that would allow import, as XPO Access provider uses GUID for the OID whereas in XPO Postgre provider (using NPGSQL v1)  it uses a bpchar(36) text field, I found the commercially available stuff like Navicat etc couldn't handle it.

So I made a litte app that would read in the tables/rows from Access, turn off constraint triggers and dump the data into PostgreSQL. As this technically applies to any XPO app I posted it all under XPO, but I figured for those who aren't keeping an eye on XPO forum (however you really should as XAF and XPO go hand in hand)

http://community.devexpress.com/forums/t/70476.aspx 

Have a good one, I might if there is a need, look at expanding it to do MySQL... your thoughts?