From: Stephen Cook <sclists@gmail.com>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: pgsql-admin@postgresql.org, Mandana Mokhtary <mandana.mokhtary@wspgroup.se>
Subject: Re: VB: sqlserver to postgresql
Date: Fri, 14 Oct 2011 16:28:19 -0400
Message-ID: <4E989B63.1090108@gmail.com> (raw)
In-Reply-To: <4E9852C80200002500041FE3@gw.wicourts.gov>
References: <6C75D80E19AC6A4FBEB7C7EAE9D65433024079B6@EXC02COL1SE.se.wspgroup.com>
<4E9852C80200002500041FE3@gw.wicourts.gov>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: sclists@gmail.com, Kevin.Grittner@wicourts.gov, mandana.mokhtary@wspgroup.se
Subject: Re: VB: sqlserver to postgresql
In-Reply-To: <4E989B63.1090108@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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