Thread: need help

need help

From
Kakek
Date:
i know from your web  that you have developed aplication to migrate access
database to other database.
and i am a student who will face final project.i want to develop
aplication for database migration,so i need your help to share idea how to
migrate one database to other database specially on data dependency
analisys.and what must be considered if we want to migrate unrelational DB
to relational Db or Relational DB to Relational DB.Or you give me
information where i can find resources about database migration algorithm.
thanks

best regard

arif




Re: need help

From
"Dave Page"
Date:

> -----Original Message-----
> From: Kakek [mailto:arif@se.its-sby.edu]
> Sent: 24 May 2002 20:01
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] need help
>
>
>
> i know from your web  that you have developed aplication to
> migrate access database to other database. and i am a student
> who will face final project.i want to develop aplication for
> database migration,so i need your help to share idea how to
> migrate one database to other database specially on data
> dependency analisys.and what must be considered if we want to
> migrate unrelational DB to relational Db or Relational DB to
> Relational DB.Or you give me information where i can find
> resources about database migration algorithm. thanks
>

Hi,

We do have some code that performs this function, however it isn't
really suitable reference for a final project in my opinion. The code we
have was never really developed in the sense that your project would
presumably need to be. Our code just sort of evolved over a number of
years and had new features hacked into it as required by various
developers. There certainly was never any real analysis of the problem
made, nor any prototyping or formal development process followed.

That aside, if you wish to take a look at the source code, it can be
found here:
http://cvs.pgadmin.org/cgi-bin/viewcvs.cgi/pgadmin2/plugins/migration/

If you have any specific questions, please feel free to post them to the
list.

Regards, Dave.