MS Access / PostgreSQL

[Chris Fletcher]

Slightly off the main topic here but ...

Can anyone recommend a 'safe' way to import the entire contents of an MS
SQL7 database table into a MYSQL database.  The MS SQL database contains
about 10 million records and cant really be taken offline so it needs to be
done live.  And without impacting performance either.

Oh, and they would like fries with that too!  Sheesh!

Any thoughts or suggestions would be appreciated.

I was thinking of linking to the mysql table from the mssql server and
running a select/insert query to populate it.  I suspect though that this
will kill the ms sql server for a while which would be bad.

Is there a better way??

Chris.




----- Original Message -----
From: "Terence Kearns" <tkearns at fastmail.fm>
To: "James McNeill" <james at heague.com.au>
Cc: <linux at samba.org>
Sent: Monday, October 14, 2002 11:23 AM
Subject: MS Access / PostgreSQL


> If there is still a windows box to run access, then you could use it via
> ODBC - although this assumes you have a client interface. There are many
> different GUI clients for postgresql so I'll leave that up to you to do
> a search.
>
> As mentioned earlier, you can convert the mdb file to postgres (Access
> supports forreign keys and mysql does not, I recomend postgres). I have
> an mdb file which contains functionality for exporting PG compatible SQL
> dumps. I've had mixed success with it but perhaps there is a newer
> version now.
>
> I think this might be the site. It talks about Access97 though :-/
> http://www.sevainc.com/Access/
>
> other handy info about linking tabled between Access/PostgreSQL
> http://joelburton.com/resources/pgaccess/faq.html
>
>
>
> James McNeill wrote:
>
> > hi all.
> > I was discussing with someone recently about moving their small office
> > over to Linux. The one thing that stands in the way is a database they
> > use written in MS Access. Short of rewriting the whole thing, is there
> > any way for them to get at this database from Linux?
> > has anyone had any luck running access runtime under Wine or another
emu?
> > Thanks heaps,
> > -James
> >
> >
>