I'm also interested, so could you post to the list?
Thanx,
Mike Diehl,
Network Monitoring Tool Devl.
284-3137
[EMAIL PROTECTED]
> -Original Message-
> From: David Reid [mailto:[EMAIL PROTECTED]]
> Sent: October 19, 2000 5:31 AM
> To: [EMAIL PROTECTED]
> Subject: [GENERAL] MySQL -> pgsql
I don't think this will work in all cases. The index syntax is different
between mysql and psql. For example, I specify indexing in the create
clause under mysql; I use a separate statement to create an index under
psql. Am I missing something?
Thanx,
Mike Diehl,
Network Monitoring Tool Devl.
ideas for migration will be most appreciated.
Mike Diehl,
Network Monitoring Tool Devl.
284-3137
[EMAIL PROTECTED]
> -Original Message-
> From: Michelle Murrain [mailto:[EMAIL PROTECTED]]
> Sent: October 19, 2000 3:15 PM
> To: Diehl, Jeffrey; David Reid
> Cc: [EMAIL P
But remember, that mysql doesn't have rules, triggers and such. Moving the
data is all I need to do. I guess I could write a tool to select from mysql
and insert into psql... I was hoping someone else had already done it. ;^)
Mike Diehl,
Network Monitoring Tool Devl.
284-3137
[EMAIL PROTECTED]
MySQL -> pgsql
>
>
> On Thu, Oct 19, 2000 at 03:18:50PM -0600, Diehl, Jeffrey wrote:
> > The database I am hoping to migrate has a few tables with around 50K
> > records. These databases get updated every hour, 24/7. I
> don't think I can
> > do the migrat