MS-SQL to PostgreSQL

[David Bandel]

On 6/29/06, Shawn Tayler <stayler at xmtservices.net> 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?

you'll need the iobc connector.  Not a big deal.  Or use Perl.  I
believe it has a Sybase/MSSQL connector.  If not, it has an iobc
connector.

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

I don't understand the question.

>
> 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?

MSSQL is based on the Sybase SQL engine, so its views, triggers, and
stored procedures look like Sybase.

HTH,

David A. Bandel
-- 
Focus on the dream, not the competition.
            - Nemesis Air Racing Team motto