MS-SQL to PostgreSQL

[Kurt Wall]

On Thu, Jun 29, 2006 at 05:46:53AM -0700, Shawn Tayler wrote:
> Hi Guys,
> 
> 
> I have been tracking a system inventory using some simple PostgreSQL and
> scripting.  The assets are soon to being track in an Asset Mgmt app on
> MS-SQL.  Unfortunaley the new system does not provide some of the
> reporting and views that I have created to help with the management side
> of it.  What I would like to be able to do is query the MS-Sql system and
> draw off certain table contents to use in my reporting on PostgreSQL.
> 
> Questions:
> 
> Is there a command line app that can pull data from a MS_SQL server that
> runs on Linux, ala psql?

I'm almost certain the PostgreSQL has an ODBC driver that you can use
to query the MSSQL database.

> Is there a way to "connect" a table within my Postgres boxen that could
> represents data on the MS_SQL machine?

ODBC.

Kurt