Re: migrate Sql Server database to PostgreSql

Hi,

At the company we work for, we migrated from Oracle to PostgreSQL
"community edition". We have no regrets. PostgreSQL allowed us to expand,
we configured it so now we have a better performance compared to before,
and we even have streaming replication to mirror our main database.

By the way, to perform the migration from Oracle to PostgreSQL we used
OmniDB [1], an open source web tool for database management and migration,
written by ourselves. OmniDB supports many well-known RDBMS system, among
them Oracle, PostgreSQL and MS SQL Server.

However, OmniDB can only migrate tables, data, indexes, unique constraints,
primary and foreign keys. In our case, we had hundreds of procedures and
functions, and they were manually translated.

[1] http://www.omnidb.com.br/en_index.aspx

Em 17h18 Qua, 18/01/2017, PAWAN SHARMA <er(dot)pawanshr0963(at)gmail(dot)com> escreveu:

> Hello All,
>
> I am using postgres 9.5 enterprise edition.
>
> i want to to how to migrate Sql Server database to PostgreSql. what are
> the things required for migration and what are the cron and prons of
> migration.
>
> -Pawan
>
--

William Ivanski - Microsoft MVP