On 08/07/2012 07:06 PM, karthi keyan wrote:
> For some interlink application purpose , i need to *migrate data into
> Sql server 2008*.
The simplest way is usually to connect with psql and export CSV data with:
\copy (SELECT ....) to '/path/to/file.csv' csv
or for a whole table:
\copy tablename to '/path/to/file.csv' csv
For usage of COPY see:
... then load that CSV into MS SQL Server 2008 like you would anything else.
A more complicated but more powerful way is to use an ETL tool like
Pentaho or Talend to connect to both databases and merge/convert data.
pgsql-admin by date
|Next:||From: Stuart Bishop||Date: 2012-08-08 15:51:15|
|Subject: Streaming replication failover with 3 servers|
|Previous:||From: Craig Ringer||Date: 2012-08-08 02:38:52|
|Subject: Re: Data corruption after SAN snapshot|