Re: [GENERAL] MySQL -> pgsql

2001-01-20 Thread Alex Pilosov
> > > > I'm also interested, so could you post to the list? > > > > > > Thanx, > > > Mike Diehl, > > > Network Monitoring Tool Devl. > > > 284-3137 > > > [EMAIL PROTECTED] > > > > > > > >

Re: [GENERAL] MySQL -> pgsql

2001-01-19 Thread Bruce Momjian
e list? > > > > Thanx, > > Mike Diehl, > > Network Monitoring Tool Devl. > > 284-3137 > > [EMAIL PROTECTED] > > > > > > > -Original Message- > > > From: David Reid [mailto:[EMAIL PROTECTED]] > > > Sent: October 19, 20

Re: [GENERAL] MySQL -> pgsql

2000-10-21 Thread Ron Chmara
Andrew Evans wrote: > On Fri, Oct 20, 2000 at 12:43:32AM -0700, Ron Chmara wrote: > > I'm a bit late on this thread, but I'm currently wranging a large > > set of migrations: > > postgreSQL-> Oracle > Would you mind explaining why your company's migrating a PostgreSQL > database to Oracle? I'm h

Re: [GENERAL] MySQL -> pgsql

2000-10-19 Thread David Reid
iant, but that's far off into the future for me! :) Oh, and I've subscribed now! david - Original Message - From: "Diehl, Jeffrey" <[EMAIL PROTECTED]> To: "'David Reid'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, Octo

RE: [GENERAL] MySQL -> pgsql

2000-10-19 Thread KuroiNeko
> But remember, that mysql doesn't have rules, triggers and such. That's exactly what I mean when I suggest re-designing the schema from scratch. Otherwise, you only get `a half of it.' > I guess I could write a tool to select from mysql > and insert into psql... This can be easy, up to

RE: [GENERAL] MySQL -> pgsql

2000-10-19 Thread Diehl, Jeffrey
Yup. Seems like that is what I need to do. Thanx, Mike Diehl, Network Monitoring Tool Devl. 284-3137 [EMAIL PROTECTED] > -Original Message- > From: Neil Conway [mailto:[EMAIL PROTECTED]] > Sent: October 19, 2000 3:30 PM > To: [EMAIL PROTECTED] > Subject: Re: [GENERAL]

RE: [GENERAL] MySQL -> pgsql

2000-10-19 Thread Diehl, Jeffrey
ECTED] > -Original Message- > From: KuroiNeko [mailto:[EMAIL PROTECTED]] > Sent: October 19, 2000 3:38 PM > To: [EMAIL PROTECTED] > Subject: RE: [GENERAL] MySQL -> pgsql > > > > Conversion tools? Na, that's just a small part of what I do. > >

RE: [GENERAL] MySQL -> pgsql

2000-10-19 Thread KuroiNeko
> Conversion tools? Na, that's just a small part of what I do. Since it's a network monitor, chances are you're not using exotic datatypes incompatible, or non-existant in PGSQL? If so, the fastest way would be to get a `dump' schema + data script from MySQL and adjust it with sed or

Re: [GENERAL] MySQL -> pgsql

2000-10-19 Thread Neil Conway
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 migration with a text editor. So, I'm still looking for some other > metho

RE: [GENERAL] MySQL -> pgsql

2000-10-19 Thread Diehl, Jeffrey
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

RE: [GENERAL] MySQL -> pgsql

2000-10-19 Thread Michelle Murrain
At 2:43 PM -0600 10/19/00, Diehl, Jeffrey wrote: >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 somethin

RE: [GENERAL] MySQL -> pgsql

2000-10-19 Thread Diehl, Jeffrey
Devl. 284-3137 [EMAIL PROTECTED] > -Original Message- > From: Michelle Murrain [mailto:[EMAIL PROTECTED]] > Sent: October 19, 2000 12:46 PM > To: David Reid > Cc: [EMAIL PROTECTED] > Subject: Re: [GENERAL] MySQL -> pgsql > > > >Can someone point me at any

RE: [GENERAL] MySQL -> pgsql

2000-10-19 Thread Diehl, Jeffrey
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] > Subj

Re: [GENERAL] MySQL -> pgsql

2000-10-19 Thread Michelle Murrain
>Can someone point me at any resources on the web that can help with such a >transformation? I have a series of tables I want to convert. Thanks. > >Oh, and I'm not on the list so can you email direct! :) I don't know MySQL, but I've converted tables from mSQL to pgsql by just using the dump t