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