Re: Converting from pgsql to sqlserver?

Hi Armindo,

Ian Harding has written a guide for converting from MS SQL Server to
PostgreSQL.  I know this is the opposite of what you want, but it might
be useful as it highlights some of the areas of difference between these
products :

http://techdocs.postgresql.org/techdocs/sqlserver2pgsql.php

Hope that's useful.

:-)

Regards and best wishes,

Justin Clift


armindo.dias@dhvmc.pt wrote:
> 
> 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
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

-- 
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."    - Indira Gandhi