[ADMIN] VB: sqlserver to postgresql

[Mokhtary, Mandana]

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: [phone]
Fax: [phone]
Mobil/mobile: [phone]
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.

[Kevin Grittner]

Post by Mokhtary, Mandana
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

[Stephen Cook]

Post by Kevin Grittner

Post by Mokhtary, Mandana
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

[Rick Albright]

you can use dbi-link

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

Post by Mokhtary, Mandana
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: [phone]
Fax: [phone]
Mobil/mobile: [phone]
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.