|
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 |
