http://techdocs.postgresql.org/
about halfway down has a section 'Converting from other Databases to
PostgreSQL'
this might help with some of the issues.
if you use system DSN's (file/user/whatever) you should be able to just
create a new one using the ODBC driver to postgresql, and write directly
in... the biggest problem you'll have that way is the table creation - since
unless you used pure ANSI standard SQL datatypes, postgresql probably won't
handle certain types that SQLserver/MSAccess would use.
----- Original Message -----
From: "srihari" <sriharir@infics.com>
To: <pgsql-odbc@postgresql.org>
Cc: <malleswararao@infics.com>
Sent: Wednesday, January 22, 2003 10:16 PM
Subject: [ODBC] DataBase
> Hi There,
>
> I Kindly request you to go through the following Query.
>
> We have developed many stand alone Applications with Different databases
> like MSAccess,SQLServer for our internal office maintenance purpose.
>
> Now we are planning to migrate all these databses to a Single database.
> i.e Without Distrubing or altering the exsited applications. for this we
> decided to use a single database i.e. PostgreSQL. all the transactions of
> stand alone applications must update same databse.
>
>
> If you alreday come across such a project kindly give me suggestions and
> steps to complete my project.
> Thanks&Rgds
> srihari
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html