Re: VB: sqlserver to postgresql

From: Stephen Cook <sclists(at)gmail(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: pgsql-admin(at)postgresql(dot)org, Mandana Mokhtary <mandana(dot)mokhtary(at)wspgroup(dot)se>
Subject: Re: VB: sqlserver to postgresql
Date: 2011-10-14 20:28:19
Message-ID: 4E989B63.1090108@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 10/14/2011 4:18 PM, Kevin Grittner wrote:
> "Mokhtary, Mandana"<mandana(dot)mokhtary(at)wspgroup(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2011-10-14 20:32:00 Re: Contents of WAL files
Previous Message Kevin Grittner 2011-10-14 20:18:32 Re: VB: sqlserver to postgresql