Re: [ADMIN] Data migration to sql server 2008

2012-08-09 Thread Craig Ringer
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 thi

Re: [ADMIN] Data migration to sql server 2008

2012-08-09 Thread Craig Ringer
[Replying via mailing list] On 08/09/2012 08:24 PM, karthi keyan wrote: Thank you for u r reply. I have establish the same by sql server *linked server method* .its is working fine. But right now i am facing the problem of . -- Query i used in sql Select * from openquery(Postgre,' dblin

Re: [ADMIN] Data migration to sql server 2008

2012-08-07 Thread Craig Ringer
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 t

[ADMIN] Data migration to sql server 2008

2012-08-07 Thread karthi keyan
hello admin, I am using Postgresql for my application development, which is very robust and secure to use. For some interlink application purpose , i need to *migrate data into Sql server 2008*. So please refer me, or give some samples, how i can migrate the data Regards Karthik