Creating tables - migrating from MySQL.

2014-01-21 Thread Paul Linehan
Hi all, I'm trying to migrate a system (72 tables) from MySQL to Apache. I've looked at the docco here http://db.apache.org/derby/docs/10.0/manuals/reference/sqlj27.html#CREATE+TABLE+statement, but it isn't readily apparent to me how to create INDEXES within the CREATE TABLE statement. I'd rathe

Re: Creating tables - migrating from MySQL.

2014-01-21 Thread Bryan Pendleton
I'm trying to migrate a system (72 tables) from MySQL to Apache. Have you considered using ddlutils: http://db.apache.org/ddlutils/ thanks, bryan

Re: Creating tables - migrating from MySQL.

2014-01-21 Thread Paul Linehan
Hi Bryan, >> I'm trying to migrate a system (72 tables) from MySQL to Apache. > Have you considered using ddlutils: http://db.apache.org/ddlutils/ Yeah, looks interesting for when I come to settle down and write this sort of thing, but what I'm trying to do for the moment is just get it up and

Re: Creating tables - migrating from MySQL.

2014-01-21 Thread Rick Hillegas
On 1/21/14 7:07 AM, Paul Linehan wrote: Hi Bryan, I'm trying to migrate a system (72 tables) from MySQL to Apache. Have you considered using ddlutils: http://db.apache.org/ddlutils/ Yeah, looks interesting for when I come to settle down and write this sort of thing, but what I'm trying to d

Re: Creating tables - migrating from MySQL.

2014-01-21 Thread Paul Linehan
2014/1/21 Rick Hillegas : Hi Rick, and thanks for your input. > You might want to take a look at the optional foreignViews tool, which can > be useful for data migration projects like yours: > http://db.apache.org/derby/docs/10.10/tools/rtoolsoptforeignviews.html. You > can create and populate

Re: Creating tables - migrating from MySQL.

2014-01-21 Thread Rick Hillegas
On 1/21/14 11:39 AM, Paul Linehan wrote: 2014/1/21 Rick Hillegas: Hi Rick, and thanks for your input. You might want to take a look at the optional foreignViews tool, which can be useful for data migration projects like yours: http://db.apache.org/derby/docs/10.10/tools/rtoolsoptforeignviews