Ispirer SQLWays is a nice (although commercial) tool to convert DDL and data from one supported database to another. We are using it regularly, the list of supported databases is impressive: PostgreSQL, Greenplum, Oracle, SQL Server, IBM DB2, MySQL, Sybase, Informix, Teradata, *Netezza *and some more.
There’s just one thing which I always forget: SQLways exports all data by default, which makes the export unnecessary big and slow.
If you download the Greenplum Community Edition (GP CE) from the Greenplum website and if you want to connect tools like pgAdminIII from your host machine to the database inside the virtual machine, you have to disable the firewall. The CE is installed on CentOS and by default the firewall is enabled and blocks connections from outside to most ports.
Here are the steps which are required to disable the firewall:
Was the first time that I actually had the chance to attend CHAR(11). For various reasons (speak: my wife had tickets for a musical) I could not attend last year.