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 4 8519
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
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
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
--- 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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
propagated immediatly and didn't require update of the clients.
My problem is how to replicate...
|
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 a result set consisting of
only a handful of items.
|
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
|
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)
|
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
development version. After a month of developing you are ready to
release a new version. There have...
| |
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 that would help us learn how to
use sprocs or pass-through queries? I apologize if my terminology...
|
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 doesn't recognise this format, or I'm not doin it right! , can enyone help me with this.
|
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 difficult for someone unfamiliar with the system (me), the table
structure is bad...really bad....there is...
|
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.
|
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 usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 most users, this new feature is actually very convenient. If you want to control the update process,...
| |
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |