From: | "Jim" <jim(at)fortunet(dot)com> |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: DataBase |
Date: | 2003-01-23 15:44:07 |
Message-ID: | 011a01c2c2f6$44404040$500210ac@fortunet |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)infics(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Cc: <malleswararao(at)infics(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Jim | 2003-01-23 15:51:50 | Re: Scalability in PostgreSQL |
Previous Message | Andreas Pflug | 2003-01-23 12:43:47 | Trying to debug psqlODBC |