[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] VB: sqlserver to postgresql
From:       Rick Albright <rla3rd () gmail ! com>
Date:       2011-10-14 20:35:24
Message-ID: 4E989D0C.5090609 () gmail ! com
[Download RAW message or body]

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 <http://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.
>


[Attachment #3 (text/html)]

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#ffffff" text="#000000">
    you can use dbi-link<br>
    <br>
    <a class="moz-txt-link-freetext" \
href="http://pgfoundry.org/projects/dbi-link">http://pgfoundry.org/projects/dbi-link</a><br>
  <br>
    On 10/14/2011 10:04 AM, Mokhtary, Mandana wrote:
    <blockquote
cite="mid:6C75D80E19AC6A4FBEB7C7EAE9D65433024079B6@EXC02COL1SE.se.wspgroup.com"
      type="cite">
      <meta http-equiv="Content-Type" content="text/html;
        charset=ISO-8859-1">
      <meta name="Generator" content="Microsoft Word 14 (filtered
        medium)">
      <style><!--
/* Font Definitions */
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri","sans-serif";
	mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:purple;
	text-decoration:underline;}
span.E-postmall17
	{mso-style-type:personal;
	font-family:"Calibri","sans-serif";
	color:windowtext;}
span.E-postmall18
	{mso-style-type:personal-reply;
	font-family:"Calibri","sans-serif";
	color:#1F497D;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-size:10.0pt;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
      <div class="WordSection1">
        <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
        <p class="MsoNormal">Hi all<o:p></o:p></p>
        <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
        <p class="MsoNormal"><span lang="EN-US">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 \
<o:p></o:p></span></p>  <p class="MsoNormal"><span lang="EN-US">without any problem \
to  postgresql.<o:p></o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US"><o:p>&nbsp;</o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US">I would appreciate it if
            anyone help me.<o:p></o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US"><o:p>&nbsp;</o:p></span></p>
        <p class="MsoNormal" style="margin-bottom: 12pt;"><span
            style="font-size: 10pt; font-family:
            &quot;Arial&quot;,&quot;sans-serif&quot;;">V&auml;nliga
            h&auml;lsningar<br>
            <br>
            Mandana Mokhtary<br>
            Geografisk IT och m&auml;tningsteknik<br>
            <br>
          </span><span style="font-size: 12pt; font-family: &quot;Times
            New Roman&quot;,&quot;serif&quot;;"><o:p></o:p></span></p>
        <p class="MsoNormal" style=""><b><span style="font-size: 10pt;
              font-family: &quot;Arial&quot;,&quot;sans-serif&quot;;">WSP
              Samh&auml;llsbyggnad<br>
            </span></b><span style="font-size: 10pt; font-family:
            &quot;Arial&quot;,&quot;sans-serif&quot;;">SE-121 88&nbsp;
            Stockholm-Globen<br>
            Bes&ouml;k/visit: Arenav&auml;gen 7<br>
            Tel/phone: +46 (0)8 688 60 00<br>
            Fax: +46 (0)8 688 69 99<br>
            Mobil/mobile: +46 (0)70 297 48 10<br>
            <a moz-do-not-send="true" \
href="http://www.wspgroup.se/">www.wspgroup.se</a><br>  <br>
          </span><span style="font-size: 7.5pt; font-family:
            &quot;Arial&quot;,&quot;sans-serif&quot;;">WSP &auml;r ett
            globalt analys- och teknikf&ouml;retag som erbjuder
            konsulttj&auml;nster f&ouml;r h&aring;llbar samh&auml;llsutveckling inom \
Hus  &amp; Industri, Transport &amp; Infrastruktur samt Milj&ouml;
            &amp; Energi. <br>
            <br>
          </span><span style="font-size: 7.5pt; font-family:
            &quot;Arial&quot;,&quot;sans-serif&quot;;" lang="EN-US">CONFIDENTIAL
            <br>
            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.</span><span
            style="font-size: 12pt; font-family: &quot;Times New
            Roman&quot;,&quot;serif&quot;;" lang="EN-US"><o:p></o:p></span></p>
        <p class="MsoNormal" style="margin-bottom: 12pt;"><span
            style="font-size: 12pt; font-family: &quot;Times New
            Roman&quot;,&quot;serif&quot;;" lang="EN-US"><o:p>&nbsp;</o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US"><o:p>&nbsp;</o:p></span></p>
      </div>
    </blockquote>
    <br>
  </body>
</html>



[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic