pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedVB: sqlserver to postgresql
4+ messages / 4 participants
[nested] [flat]
* VB: sqlserver to postgresql
@ 2011-10-14 14:04 Mokhtary, Mandana <mandana.mokhtary@wspgroup.se>
2011-10-14 20:18 ` Re: VB: sqlserver to postgresql Kevin Grittner <Kevin.Grittner@wicourts.gov>
2011-10-14 20:35 ` Re: VB: sqlserver to postgresql Rick Albright <rla3rd@gmail.com>
0 siblings, 2 replies; 4+ messages in thread
From: Mokhtary, Mandana @ 2011-10-14 14:04 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: VB: sqlserver to postgresql
2011-10-14 14:04 VB: sqlserver to postgresql Mokhtary, Mandana <mandana.mokhtary@wspgroup.se>
@ 2011-10-14 20:18 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2011-10-14 20:28 ` Re: VB: sqlserver to postgresql Stephen Cook <sclists@gmail.com>
1 sibling, 1 reply; 4+ messages in thread
From: Kevin Grittner @ 2011-10-14 20:18 UTC (permalink / raw)
To: pgsql-admin; Mandana Mokhtary <mandana.mokhtary@wspgroup.se>
"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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: VB: sqlserver to postgresql
2011-10-14 14:04 VB: sqlserver to postgresql Mokhtary, Mandana <mandana.mokhtary@wspgroup.se>
2011-10-14 20:18 ` Re: VB: sqlserver to postgresql Kevin Grittner <Kevin.Grittner@wicourts.gov>
@ 2011-10-14 20:28 ` Stephen Cook <sclists@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Stephen Cook @ 2011-10-14 20:28 UTC (permalink / raw)
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>; +Cc: pgsql-admin@postgresql.org, Mandana Mokhtary <mandana.mokhtary@wspgroup.se>
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: VB: sqlserver to postgresql
2011-10-14 14:04 VB: sqlserver to postgresql Mokhtary, Mandana <mandana.mokhtary@wspgroup.se>
@ 2011-10-14 20:35 ` Rick Albright <rla3rd@gmail.com>
1 sibling, 0 replies; 4+ messages in thread
From: Rick Albright @ 2011-10-14 20:35 UTC (permalink / raw)
To: pgsql-admin
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.
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2011-10-14 20:35 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-10-14 14:04 VB: sqlserver to postgresql Mokhtary, Mandana <mandana.mokhtary@wspgroup.se>
2011-10-14 20:18 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2011-10-14 20:28 ` Stephen Cook <sclists@gmail.com>
2011-10-14 20:35 ` Rick Albright <rla3rd@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox