Re: VB: sqlserver to postgresql

Rick Albright <rla3rd@xxxxxxxxx> · Fri, 14 Oct 2011 16:35:24 -0400



    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.