CODEWITHSUNDEEP
sql-serverpostgresqlsynchronizationmigration
user163947
user163947

Reputation:

Synchronization of sql server 2000 and postgresql 8.3

the scenario:

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

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)

Upvotes: 3

Views: 1578

Answers (1)

Todd
Todd

Reputation: 35990

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.

Upvotes: 2

Related Questions