Re: Data migration to sql server 2008

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