Thread: VB: sqlserver to postgresql

VB: sqlserver to postgresql

From
"Mokhtary, Mandana"
Date:

 

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.

 

 

Re: VB: sqlserver to postgresql

From
"Kevin Grittner"
Date:
"Mokhtary, Mandana" <mandana.mokhtary@wspgroup.se> wrote:

> Is there any way to import data atomatically from sql server to
> postgresql.

Any programming environment which connects to both can work.  We
wrote a pretty simple Java program which connected to both databases
through JDBC for our conversions.  There are many other options, of
course.

-Kevin

Re: VB: sqlserver to postgresql

From
Stephen Cook
Date:
On 10/14/2011 4:18 PM, Kevin Grittner wrote:
> "Mokhtary, Mandana"<mandana.mokhtary@wspgroup.se>  wrote:
>
>> Is there any way to import data atomatically from sql server to
>> postgresql.
>
> Any programming environment which connects to both can work.  We
> wrote a pretty simple Java program which connected to both databases
> through JDBC for our conversions.  There are many other options, of
> course.

Depending on your version / edition of SQL Server, you can use SSIS.

-- Stephen

Re: VB: sqlserver to postgresql

From
Rick Albright
Date:
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.