PostgreSQL Database Migration to SQL Server

Question

Hi All,

I am really new to these Database stuffs.

I am doing a feasibility study on whether there is a migration that is possible from postgres Database to SQL Server .

First ,

Kindly suggest me the ways through which this task can be accomplished ?

Requirement :

Looking for this migration to happen on a daily basis , preferably automated .

If manual migration is the only option available , Where do I start to get things kicked off ?

Answer 1

Here is what you have to do:

1. Find PostgreSQL ODBC drivers and install them.
2. Create new SSIS package.
3. Setup ADO.NET connection based on the PostgreSQL ODBC driver.
4. Insert SSIS Data Flow Task.
5. Inside the task setup ADO.NET Source component (SQL 2008) or DataReader Source component (SQL 2005).
6. Inside the task setup OLE DB Destination component.
7. Connect the source to destination component.

That's should be it.

---

SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Answer 2

Thank you so much for the information , that should be helping me bigtime .

Is it something i have to manually follow every time

or

it can be made like an automated batch which can do the migration daily ?

Answer 3

Thank you so much for the information , that should be helping me bigtime .

Is it something i have to manually follow every time

or

it can be made like an automated batch which can do the migration daily ?

After you create the SSIS package, you can schedule to execute it daily with the SQL Job Agent.

---

SSIS Tasks Components Scripts Services | http://www.cozyroc.com/