Synchronization of sql server 2000 and postgresql 8.3

Question

the scenario:

Two databases(each has a database named, for example testdb):

• MS Sql Server 2000
• Postgresql 8.3

I need to synchronize these two testdbs, actually the direction is from SqlServer to Postgresql.

The structure of testdb on SqlServer may change occasionally. I only need tables and data of testdb synchronized, exclude indexes, views or other foos.

I've already read this article: Microsoft SQL Server to PostgreSQL Migration by Ian Harding, but it seems to be a one-off solution. And I found this procedures: Generate Scripts for SQL Server Objects automatically, but I think it's still hard to make the steps in the article automatically.

Is it possible to make the synchronization automatically in another way?(By batch/scripts or noncommercial tools)

Answer 1

You've probably already though of this but...you can create a DTS package to export the data from SQL Server and move it some intermediate location. Then a cron job would execute a script to import the data into Postgres.