Re: Conversion from MS Access to Postgresql
От | Mihai Gheorghiu |
---|---|
Тема | Re: Conversion from MS Access to Postgresql |
Дата | |
Msg-id | 004e01bfe041$541631e0$cc7b243f@new6 обсуждение исходный текст |
Ответ на | Conversion from MS Access to Postgresql ("G.L.Lim" <limgl@grouplinks.com>) |
Ответы |
Re: Conversion from MS Access to Postgresql
|
Список | pgsql-general |
I tried to export an Access Yes/No field to pgsql boolean and got an error message. By default, Access (and the ODBC driver) exports Yes/No to bpchar. However, I want to use bool. Any suggestions? Thanks, Mihai -----Original Message----- From: Stephen Davies <scldad@sdc.com.au> To: G.L.Lim <limgl@grouplinks.com> Cc: pgsql-general@postgresql.org <pgsql-general@postgresql.org> Date: Monday, June 26, 2000 7:54 PM Subject: Re: [GENERAL] Conversion from MS Access to Postgresql >G'day. > >Having just done it, I can confirm that converting an Access database >to PostgreSQL is very easy. > >All I did was as follows: > >1. create an empty Postgresql database, >2. cretae an ODBC DSN on the Access machine pointing at the empty >database, >3, fire up Access and Save/As/Export all tables to the ODBC target. > >Job done:-)) > >In fact, I had to do some massage to the results as the export process >does not create indexes nor sequences and I decidesd to change some of >the generated data types. > >This was also easy using the pgdump utility to dump the data and the >definition for editing. > >Be aware that any column names that include upper case letters in >Access will keep their capitalisation and require quotes in Postgresql. > >HTH, >Stephen. >"G.L.Lim" <limgl@grouplinks.com> wrote: >> Hi, >> >> I am curently using MS Access and would like to convert my existing Access >> database to Postgresql database (maybe into Postgresql dump file first if >> neccessary). Is there any utility or program that can do that? Please >> advise. >> >> Thank you. >> >> Regards, >> Geok Leng > > > > >======================================================================== >Stephen Davies Consulting scldad@sdc.com.au >Adelaide, South Australia. Voice: 08-8177 1595 >Computing & Network solutions. Fax: 08-8177 0133 > >
В списке pgsql-general по дате отправления: