Thread: DataBase

DataBase

From
srihari
Date:
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

Re: DataBase

From
"Jim"
Date:
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