MS-SQL to PostgreSQL

[Shawn Tayler]

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?

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

As you can see from my questions I am not a Database guru.  I learned
PostgreSQL as I needed as it was handy.

Suggestions as to where to look or some Sage advise?

Shawn