Converting from pgsql to sqlserver?

From: armindo(dot)dias(at)dhvmc(dot)pt
To: pgsql-hackers(at)postgresql(dot)org
Subject: Converting from pgsql to sqlserver?
Date: 2001-09-26 11:04:27
Message-ID: C18247C87B33D411804100805F8BC38A7E1C7A@ptli03.fbo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Greetings.
I don´t know if this is the right place to ask this, sorry if this don't
belong here.
I begun this week working in a new firm. They use linux and PostgreSQL as
the database for the Intranet site and for the management of CV's and
Knowledge Management (they have an on-line system to manage and search
information about workers of the firm and projects they have).

They now want to convert from the current linux/postgresql platform to
Windows and SQLServer. I've never worked before with linux or PostgreSQL so
i know nothing about the capabilities of this combo.

My question are:

- the PostgreSQL database has a lot of information. Is it possible to
migrate the data of the PostgreSQL to SQLServer in Windows? What do i need
to do?

- is it possible to migrate the tables relationships (the relational schema)
of the DB to SQLServer or do i have to build the DB from scratch?

Thanks for reading,
Armindo Dias

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Janardhana Reddy 2001-09-26 11:23:27 PERFORMANCE IMPROVEMENT by mapping WAL FILES
Previous Message Christopher Kings-Lynne 2001-09-26 08:58:52 time without time zone