Re: DataBase - Mailing list pgsql-odbc

From Jim
Subject Re: DataBase
Date
Msg-id 011a01c2c2f6$44404040$500210ac@fortunet
Whole thread Raw
In response to DataBase  (srihari <sriharir@infics.com>)
List pgsql-odbc
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


pgsql-odbc by date:

Previous
From: srihari
Date:
Subject: DataBase
Next
From: "Jim"
Date:
Subject: Re: Scalability in PostgreSQL