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:
\h COPY
and
http://www.postgresql.org/docs/current/static/sql-copy.html ... 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.
--
Craig Ringer