MS-SQL to PostgreSQL

[Bill Campbell]

On Thu, Jun 29, 2006, 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?
>
>Is there a way to "connect" a table within my Postgres boxen that could
>represents data on the MS_SQL machine?

I think you can access M$-SQL using ODBC clients.  The python
sqlobject system provides an object wrapper around various sql
back ends includine mssql and postgresql, and, of course, there
are python libraries to access both of these back ends directly
(and I presume perl CPAN modules as well).

Bill
--
INTERNET:   bill at Celestial.COM  Bill Campbell; Celestial Software LLC
URL: http://www.celestial.com/  PO Box 820; 6641 E. Mercer Way
FAX:            (206) 232-9186  Mercer Island, WA 98040-0820; (206) 236-1676

``The children who know how to think for themselves spoil the harmony of
the collective society that is coming, where everyone would be
interdependent.''  1899 John Dewey, educational philosopher, proponent of
modern public schools.