Skip site navigation (1) Skip section navigation (2)

Re: Moving data from SQL Server to Postgres via VFP ODBC Driver

From: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
To: calvin smith <calvinsmith266(at)hotmail(dot)com>
Cc: pgsql-odbc <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Moving data from SQL Server to Postgres via VFP ODBC Driver
Date: 2010-08-09 18:50:59
Message-ID: AANLkTikE6=6XTKAU8qfU5cifJQMu6jRfE3wvCPQEEs3N@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-odbc
On Mon, Aug 9, 2010 at 11:31 AM, calvin smith
<calvinsmith266(at)hotmail(dot)com> wrote:

> Thank you for your reply. Actually I am dumping the data from SQLServer into
> Visual FoxPro memory variables on a record by record basisĀ  and then
> checking the datatype for each memory variable.. If the data type is VFP
> character I am trimming the value so that I KNOW that what is going into my
> Insert statement is trimmed data.

I haven't used VFP.  Is it an ETL tool?

Another ETL tool to consider (its open source) that is JDBC based can
be found here:
http://sourceforge.net/projects/pentaho/files/Data%20Integration/4.0.0-stable/

Also, I don't know if you seen these migration resources:
http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#Microsoft_SQL_Server

Hopefully there is something useful there.

Also don't forget to reply-all so that the mailing list is included so
that others can reply.

-- 
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

In response to

pgsql-odbc by date

Next:From: Tom LaneDate: 2010-08-09 19:03:14
Subject: Re: Moving data from SQL Server to Postgres via VFP ODBC Driver
Previous:From: Richard BroersmaDate: 2010-08-09 17:59:30
Subject: Re: Moving data from SQL Server to Postgres via VFP ODBC Driver

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group