Saturday, March 21, 2009

Data Transfer from MS Access to EnterpriseDB's PostGres

EnterpriseDB sits atop Postgres, the well known open source database server and leverages it to provide enterprise capabilities to Postgres users.

Out of the box EnterpriseDB's Migration Studio supports migration from SQL Server, Postgres and Sybase only. In this article, the Microsoft Integration Services is used to transfer a table form Microsoft Access 2003 to a database  on the EnterpriseDB Postgres server.

MS SQL Server Integration Services 2008 is a great product that handles various ETL Processes very effectively. However, sometimes its error messages can be confusing as you will see in this article. For example, where as the task execution has failed in this example, the data transfer has taken place.

Read on,

Transferring a table in a MS Access 2003 database to PostGres using SQL Server Integration Services 

This is a subscription site and you can login as guest and read free or join as a member using link for SSWUG.ORG on the main page.

If you are new to EnterpriseDB you may also want to read my other article first

Installation and basic features of EnterpriseDB

No comments: Protection Status