Re: Data migration to sql server 2008

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