From: Craig Ringer <ringerc@ringerc.id.au>
To: karthi keyan <karthi2itnet@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Data migration to sql server 2008
Date: Fri, 10 Aug 2012 13:19:56 +0800
Message-ID: <502499FC.6050505@ringerc.id.au> (raw)
In-Reply-To: <CAM-vHqJhXsY_i=+-uqpO=i=5s669xqvcyvYgmd-bCohR=N+uTw@mail.gmail.com>
References: <CAM-vHq+wi0jckw+-mHFJeX98FGutkmSPcDnYR75yHinqtHixrg@mail.gmail.com>
<50220DC1.8030007@ringerc.id.au>
<CAM-vHqKAfzcdQ3jt6iSZw5beU86v=aNAc7FbhcYjEJ+_ZOcUQw@mail.gmail.com>
<5023B1EF.8060709@ringerc.id.au>
<CAM-vHqJhXsY_i=+-uqpO=i=5s669xqvcyvYgmd-bCohR=N+uTw@mail.gmail.com>
On 08/10/2012 12:35 PM, karthi keyan wrote:
>
>
> Actually my need is import data from PostgreSQL , and the same
> process into sql server.
>
I'm guessing you didn't see what I wrote in reply to your message, where
I said:
You haven't really shown enough information. In particular, where does
this 'Postgre' variable/table/whatever come from? What is it?
You should look at the PostgreSQL server logs to see if PostgreSQL is
sending an error when you attempt the connection and if so, what it is.
Consider also setting log_statement = 'all' in postgresql.conf so you
can see exactly what queries this "openquery" tool runs against PostgreSQL.
By the way, the easiest way to do this sort of thing is usually to
COPY tablename TO '/some/file.csv' CSV
from PostgreSQL, then load that file into MS SQL server. That's trivial
to script with vbscript or whatever you prefer, using psql to get the
data out of PostgreSQL.
--
Craig Ringer
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ringerc@ringerc.id.au, karthi2itnet@gmail.com
Subject: Re: Data migration to sql server 2008
In-Reply-To: <502499FC.6050505@ringerc.id.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox