Subject: Re: Oracle to Postgres conversion suggestions?
To: pgsql-admin@postgresql.org
References: <25a7213d-23ce-dabb-c2e7-d3e3fa26e855@catalyst.net.nz>
 <20170310085435.jmqt7utuwbss4p6n@office.hexack.fr>
From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
Message-ID: <80113f69-b986-5da5-2034-76989aba55a2@catalyst.net.nz>
Date: Tue, 14 Mar 2017 15:35:00 +1300
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101
 Thunderbird/45.7.0
MIME-Version: 1.0
In-Reply-To: <20170310085435.jmqt7utuwbss4p6n@office.hexack.fr>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Thanks - yes (briefly). While it looks good (and appears to be able to 
do spatial data too)...the size of the source Oracle db means we need 
replication ability to catchup the changes that were being made while 
the migration was in progress.

In theory DMS can do this.

regards

Mark

On 10/03/17 21:54, Stéphane KANSCHINE wrote:
> Le ven. 10 mars, vers 21:42, Mark Kirkwood exprimait :
>
>> Hi,
>
> Hi,
>
>> I've been asked to help with one of these. I'm a bit wary, as I'm thinking
>> this is actually a really high risk endeavor. Any thoughts on toolkits that
>> might make this easy?
>
> Do you look at ora2pg¹ ?
>
> It's a good tool, that estimates the migration cost, migrate what it
> can automatically (schema, constraints, data ) and let you do the hard
> job : port your stored procedures and your applications if you didn't
> use a good ORM.
>
> ¹ http://ora2pg.darold.net/
>
> Regards
>


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin