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] > Subject: [GENERAL] MySQL -> pgsql

RE: [GENERAL] MySQL -> pgsql

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

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 Diehl, Jeffrey
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]

RE: [GENERAL] MySQL -> pgsql

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