Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 2824AB5DC1F for ; Fri, 14 Oct 2011 17:35:35 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 00694-02-2 for ; Fri, 14 Oct 2011 20:35:28 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from mail-vw0-f46.google.com (mail-vw0-f46.google.com [209.85.212.46]) by mail.postgresql.org (Postfix) with ESMTP id BB9F3B5DC0A for ; Fri, 14 Oct 2011 17:35:27 -0300 (ADT) Received: by vws1 with SMTP id 1so1361163vws.19 for ; Fri, 14 Oct 2011 13:35:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:subject:references :in-reply-to:content-type; bh=pfJyozOLSk5RAFE+pZ6swFCZQ8xHccl0/i4H6FPX3uw=; b=QOpsMlPUNdE+YmaTgewTANxQNygU88OoyV0c8wZcLlFe/df1SLhfxZDmypNalU7wPG HpODvJMX8sddBbM9YSD2zWgAHZnEBr8gHw847aYTGE2ObbzKYmapkSnTFRjVgIsodevi u7A0iPdoiwg4omU5xGpME3zm2MPzjUuqJ9smU= Received: by 10.52.174.38 with SMTP id bp6mr10500834vdc.75.1318624527471; Fri, 14 Oct 2011 13:35:27 -0700 (PDT) Received: from [192.168.0.100] (pool-98-110-20-244.cmdnnj.fios.verizon.net. [98.110.20.244]) by mx.google.com with ESMTPS id em2sm8771319vdc.2.2011.10.14.13.35.24 (version=SSLv3 cipher=OTHER); Fri, 14 Oct 2011 13:35:25 -0700 (PDT) Message-ID: <4E989D0C.5090609@gmail.com> Date: Fri, 14 Oct 2011 16:35:24 -0400 From: Rick Albright User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.23) Gecko/20110921 Lightning/1.0b2 Thunderbird/3.1.15 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: VB: sqlserver to postgresql References: <6C75D80E19AC6A4FBEB7C7EAE9D65433024079B6@EXC02COL1SE.se.wspgroup.com> In-Reply-To: <6C75D80E19AC6A4FBEB7C7EAE9D65433024079B6@EXC02COL1SE.se.wspgroup.com> Content-Type: multipart/alternative; boundary="------------050808060203070209070402" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.888 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201110/81 X-Sequence-Number: 38533 This is a multi-part message in MIME format. --------------050808060203070209070402 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit you can use dbi-link http://pgfoundry.org/projects/dbi-link On 10/14/2011 10:04 AM, Mokhtary, Mandana wrote: > > Hi all > > Is there any way to import data atomatically from sql server to > postgresql. We are using sql server which connects to our measuring > instruments. I would like to know how I can insert data > > without any problem to postgresql. > > I would appreciate it if anyone help me. > > Vänliga hälsningar > > Mandana Mokhtary > Geografisk IT och mätningsteknik > > *WSP Samhällsbyggnad > *SE-121 88 Stockholm-Globen > Besök/visit: Arenavägen 7 > Tel/phone: +46 (0)8 688 60 00 > Fax: +46 (0)8 688 69 99 > Mobil/mobile: +46 (0)70 297 48 10 > www.wspgroup.se > > WSP är ett globalt analys- och teknikföretag som erbjuder > konsulttjänster för hållbar samhällsutveckling inom Hus & Industri, > Transport & Infrastruktur samt Miljö & Energi. > > CONFIDENTIAL > This e-mail is confidential to the named recipient. If you have > received a copy in error, please destroy it. You may not use or > disclose the contents of this e-mail to anyone, nor take copies of it. > The only copies permitted are (1) by the named recipient and (2) for > the purposes of completing successful electronic transmission to the > named recipient and then only on the condition that these copies, with > this notice attached, are kept confidential until destruction. > --------------050808060203070209070402 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit you can use dbi-link

http://pgfoundry.org/projects/dbi-link

On 10/14/2011 10:04 AM, Mokhtary, Mandana wrote:

 

Hi all

 

Is there any way to import data atomatically from sql server to postgresql. We are using sql server which connects to our measuring instruments. I would like to know how I can insert data

without any problem to postgresql.

 

I would appreciate it if anyone help me.

 

Vänliga hälsningar

Mandana Mokhtary
Geografisk IT och mätningsteknik

WSP Samhällsbyggnad
SE-121 88  Stockholm-Globen
Besök/visit: Arenavägen 7
Tel/phone: +46 (0)8 688 60 00
Fax: +46 (0)8 688 69 99
Mobil/mobile: +46 (0)70 297 48 10
www.wspgroup.se

WSP är ett globalt analys- och teknikföretag som erbjuder konsulttjänster för hållbar samhällsutveckling inom Hus & Industri, Transport & Infrastruktur samt Miljö & Energi.

CONFIDENTIAL
This e-mail is confidential to the named recipient. If you have received a copy in error, please destroy it. You may not use or disclose the contents of this e-mail to anyone, nor take copies of it. The only copies permitted are (1) by the named recipient and (2) for the purposes of completing successful electronic transmission to the named recipient and then only on the condition that these copies, with this notice attached, are kept confidential until destruction.

 

 


--------------050808060203070209070402--