Create PostgreSQL tables and project data transfer

[Rijk J. van Vulpen]

We are migrating from EAP file (using EA10) to PostgreSQL database 9.2.

When using PostgreSQL_EASchema.sql of created 21-01-2010, EA build 852, I had problems with tables T_Xref (field partition is a reserved word and should be between quotes), T_Xrefsystem (similar), T_Xrefuser (similar).

I fixed this.

Now I try to perform a project data transfer, after doing the project integrity check. The import crashes and I try to determine what is happening. The logfile says as a last entry:
Copying project information for: t_document

Anyone?

Thanx,
Rijk

[Aaron B]

Can you confirm whether your EAP file might have Replication enabled?

"When performing an EAP to DBMS transfer, if the EAP file has replication enabled, the replication must be removed before performing the transfer."

[Rijk J. van Vulpen]

Replication is not enabled.

I found a zip template in X_document, I removed that in EA, but that did not work. I handfilled the rest of the tables   (until no difference between the EAP was found anymore), but that did not work  .

[Aaron B]

Which specific program version of Enterprise Architect you are currently running?  (See: Help | About EA)

I'm not sure if it's related or not, but there was an issue fixed in EA 10.0.1009 related to handling of the Partition keyword in MySQL 5.6.  No idea whether this same issue may have also affect PostgreSQL.

If possible, please try updating to the latest release of EA and try again.  Any difference?

[Rijk J. van Vulpen]

I am running 10.0.1009.

[Rijk J. van Vulpen]

I tried with an empty EAP project file. The data transfer was succesful, but the EA crashed when connected.

[Aaron B]

Try transferring either EABase.eap or EAExample.eap to begin with just for testing.

Please make sure your ODBC connection is configured as per instructions on the following help page (in particular, make sure the advanced options in step 6 are configured as shown):
http://www.sparxsystems.com/enterprise_architect_user_guide/10/projects_and_teams/setupapostgresqlodbcdriver.html

[Rijk J. van Vulpen]

Found the solution: I renamed the column-names with capital P t_xref.Partition. It should be small p. The project data transfer was succesful. Thanx!