Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 31872B5DC19
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri, 14 Oct 2011 17:28:20 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 60334-04 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri, 14 Oct 2011 20:28:13 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.8.0-rc2
Received: from mail-qw0-f46.google.com (mail-qw0-f46.google.com
	[209.85.216.46])
	by mail.postgresql.org (Postfix) with ESMTP id B4183B5DC13
	for <pgsql-admin@postgresql.org>; Fri, 14 Oct 2011 17:28:13 -0300 (ADT)
Received: by qadb15 with SMTP id b15so1182116qad.19
	for <pgsql-admin@postgresql.org>; Fri, 14 Oct 2011 13:28:13 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type:content-transfer-encoding;
	bh=Ee2NGtww8VVaYwWixNrnrfmCJlea44UZZ4vgc7JWqC4=;
	b=FJ73RbV2eihPJygWiAUe7ylwteDDm8KYJMq9kWJ4/yX50Vws1I04hrK/aS/AJ/bqm1
	pPm8CkBLN/aOJ9x+vvYxxws+KSeJRZCReMcBNLs7t5uAyrJq/7U903guo3R76ce36HR8
	g0MXElA7ul4fX/zZ+/LMH9E2/1+HW2fovK3UU=
Received: by 10.224.70.142 with SMTP id d14mr6309576qaj.66.1318624093528;
	Fri, 14 Oct 2011 13:28:13 -0700 (PDT)
Received: from [192.168.1.4] (ool-182c6755.dyn.optonline.net. [24.44.103.85])
	by mx.google.com with ESMTPS id
	bh18sm13078652qab.8.2011.10.14.13.28.12
	(version=TLSv1/SSLv3 cipher=OTHER);
	Fri, 14 Oct 2011 13:28:12 -0700 (PDT)
Message-ID: <4E989B63.1090108@gmail.com>
Date: Fri, 14 Oct 2011 16:28:19 -0400
From: Stephen Cook <sclists@gmail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
	rv:7.0.1) Gecko/20110929 Thunderbird/7.0.1
MIME-Version: 1.0
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
CC: pgsql-admin@postgresql.org,
	Mandana Mokhtary <mandana.mokhtary@wspgroup.se>
Subject: Re: VB: sqlserver to postgresql
References: 
 <6C75D80E19AC6A4FBEB7C7EAE9D65433024079B6@EXC02COL1SE.se.wspgroup.com>
	<4E9852C80200002500041FE3@gw.wicourts.gov>
In-Reply-To: <4E9852C80200002500041FE3@gw.wicourts.gov>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001
X-Spam-Level: 
X-Archive-Number: 201110/78
X-Sequence-Number: 38530

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