Search Postgresql Archives

Re: migrate Sql Server database to PostgreSql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.pawanshr0963@xxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux