473,551 Members | 2,851 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Migrating Access to Postgres

Hi,
I am interested in migrating Microsoft Access database to Postgres
database. But I do not have idea of like initiating. Maybe some tool
exists for this problem.
Thanks you.
Bernardo



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

Nov 12 '05 #1
4 8503
On Wed, Oct 01, 2003 at 09:23:44AM -0600, Bernardo Robelo wrote:
Hi,
I am interested in migrating Microsoft Access database to Postgres
database. But I do not have idea of like initiating. Maybe some tool
exists for this problem.


Have a look at http://gborg.postgresql.org/project/...rojdisplay.php

Cheers,

Patrick

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #2
On Wednesday 01 October 2003 16:23, Bernardo Robelo wrote:
Hi,
I am interested in migrating Microsoft Access database to Postgres
database. But I do not have idea of like initiating. Maybe some tool
exists for this problem.


pgadmin (v3) is a useful tool:
http://www.pgadmin.org/pgadmin3/index.php

There is some advice here:
http://techdocs.postgresql.org

You might find the odbc driver useful:
http://gborg.postgresql.org/project/...rojdisplay.php

I prefer to use the ODBC driver to link to tables in PG and gradually migrate
that way. A lot of people say pgadmin is great for migrating, though I've not
used it for that.

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #3
Hello .. i did the migration and my advice is that you forget about the automatic translation tools...

I took the access database and recreated all af the tables and relationships between them manually in postgres. I also added all the necessary indexes at design time ..
Basiclly you have to open each table in access in desgn mode and recreate it in postgres (maybe first write it in a text file) with sql commands ...eg:

create table foo (a serial primary key, b varchar) ......

After that you have to migrate the queries and recreate them as views in PG...

Then i dumped all the access tables to csv files and reimported them in pg with the copy command. Another solution to export the data from access to PG would be to link all the pg tables in access and execute an insert query from access.... This is a faster solution but sometimes access can run out of memory or you can get differences and errors in the datatypes which are very annoying...

I kept access only as a frontend and beleive me this solution gave us a huge boost in production in our company ...

Best Rgeards,

Fabrizio Mazzoni

On Wed, 1 Oct 2003 09:23:44 -0600 (CST)
"Bernardo Robelo" <br*****@agssa. net> wrote:
Hi,
I am interested in migrating Microsoft Access database to Postgres
database. But I do not have idea of like initiating. Maybe some tool
exists for this problem.
Thanks you.
Bernardo



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 12 '05 #4

--- Fabrizio Mazzoni <ve*******@libe ro.it> wrote:
Hello .. i did the migration and my advice is that
you forget about the automatic translation tools...
I have used the "migration wizard" that comes as a
plugin for PgAdminII, and was very happy with the
result. Yes, you can do everything by hand, but why?

I took the access database and recreated all af the
tables and relationships between them manually in
postgres. I also added all the necessary indexes at
design time ..
Basiclly you have to open each table in access in
desgn mode and recreate it in postgres (maybe first
write it in a text file) with sql commands ...eg:

create table foo (a serial primary key, b varchar)
......

After that you have to migrate the queries and
recreate them as views in PG...

Then i dumped all the access tables to csv files and
reimported them in pg with the copy command. Another
solution to export the data from access to PG would
be to link all the pg tables in access and execute
an insert query from access.... This is a faster
solution but sometimes access can run out of memory
or you can get differences and errors in the
datatypes which are very annoying...

I kept access only as a frontend and beleive me this
solution gave us a huge boost in production in our
company ...

Best Rgeards,

Fabrizio Mazzoni

On Wed, 1 Oct 2003 09:23:44 -0600 (CST)
"Bernardo Robelo" <br*****@agssa. net> wrote:
Hi,
I am interested in migrating Microsoft Access

database to Postgres
database. But I do not have idea of like

initiating. Maybe some tool
exists for this problem.
Thanks you.
Bernardo



---------------------------(end of

broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to

ma*******@postg resql.org

---------------------------(end of
broadcast)---------------------------
TIP 7: don't forget to increase your free space map

settings
_______________ _______________ ____
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
2697
by: Al Rosenthal | last post by:
I am trying to migrate from SQL Server on windows NT to a Linux server running Postgres. The table definitions are no problem and the data migrates well using bcp and COPY. The problem is that most of the functionality of the client programs were built into stored procedures. This worked well in that any change of policy or functionality was...
8
5130
by: wlcna | last post by:
mysql v4.0.16: I had been using mysql with innodb and thought that was fine, until i used it for something requiring a few - perhaps slightly involved - joins, and have now seen the performance become totally unacceptable. I have a query that takes over 35 seconds using mysql and innodb, for reasons that are completely a mystery to me, in...
0
1499
by: Jesse | last post by:
Hi all, I need some help with Access database and Postgres Database i am trying to link some Acces tables to Postgres tabels but id doesn't seem to work. I have a Postgres running on a server at schoool and i have to login thru port 4040 that isn't the problem. home i use Access i have a complet database and thru the ODBC driver i
4
1725
by: Kaloyan Iliev Iliev | last post by:
Dear friends, I have the following problem. libvar=# select version(); version ---------------------------------------------------------------- PostgreSQL 7.2.3 on i386-pc-bsdi4.0.1, compiled by GCC 2.7.2.1 (1 row)
4
2603
by: Collin Peters | last post by:
I have searched the Internet... but haven't found much relating to this. I am wondering on what the best practices are for migrating a developmemnt database to a release database. Here is the simplest example of my situation (real world would be more complex). Say you have two versions of your application. A release version and a...
10
2349
by: Hank | last post by:
We have just recently migrated the data from our Access 2000 backend to Postgres. All forms and reports seem to run correctly but, in many cases, very slowly. We do not want to switch over until we can speed things up. We would like to start implementing Stored Procedures so we can do Server-Side processing. Can anyone recommend a book...
3
4741
by: henry62 | last post by:
Hi I'm trying to migrate a universe database to postgres, so far I've exported the tables from universe using uvexport into a comma sep. text file. I've converted the file to CSV format and all's well apart from a table that contains dates. Date fields in the exported file are shown as 5 digit numbers eg. 10655 which should = 3/3/97. Postgres...
64
4520
by: John | last post by:
Hello there, Im cursing my place of employment...and its taken me a month to realise it... The scenario: Ive just stepped into a role to migrate an access database to VB.Net. The access database runs on terminal services and supports approximatly 25-30 users. It is crapping out big time, corrupted data, changes to the front end are...
1
3089
by: Teboo | last post by:
Hi, I'm migrating a database into postgres what steps do I need to take? I have installed postgres database. Some Oracle data type is not the same as in postgres, What migration tools can I use to make it easier? Thanking you.
0
7565
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
8002
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7522
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7847
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6106
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5406
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3534
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
1097
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
804
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.