Re: Oracle to Postgres-Licensed GUI tool

Mark Kirkwood <mark.kirkwood@xxxxxxxxxxxxxxx> · Fri, 23 Nov 2018 13:21:24 +1300



    I don't think so. I have a standard AWS
      account and DMS is available under 'services'.
    

    The only major restriction I see is
      this: either the source or target db must be running inside AWS
      (either EC2 or RDS).
    See https://aws.amazon.com/dms/faqs/
    

    regards
    Mark

    
    On 23/11/18 1:13 PM, Pepe TD Vo wrote:

    
        I
            think you need to pay for a full license for using
          DMS
         
        
               On Thursday,
                  November 22, 2018 5:15 PM, Mark Kirkwood
                  <mark.kirkwood@xxxxxxxxxxxxxxx> wrote:

                
                    You can
                      use AWS DMS (Data Migration Services) to actually
                      more the data after setting up the destination
                      schema via SCT. As usual with AWS there are quirks
                      and limitations (particularly at the Oracle end of
                      things), but it is an option.

                    
                    regards
                    Mark

                    
                      On
                        21/11/18 7:21 AM, Paul Carlucci wrote:

                      
                      Moving data is a completely different tool,
                        whereasnSCT only converts and migrates the DDL.
                      

                        On Tue, Nov 20, 2018, 1:18 PM
                          <soumik.bhattacharjee@xxxxxxx
                          wrote:

                        
                              Okay,
                                  I was of the idea that it always needs
                                  to be RDS and there’s a limit of data
                                  that can be migrated in trial version.
                               
                              Thanks,
                                  will checkout that.
                               
                               
                              From:
                                  Paul Carlucci <paul.carlucci@xxxxxxxxx>
                                  

                                  Sent: Tuesday, November 20,
                                  2018 7:16 PM

                                  To: Bhattacharjee, Soumik <soumik.bhattacharjee@xxxxxxx>

                                  Cc: pgsql-admin@xxxxxxxxxxxxxx

                                  Subject: Re: Oracle to
                                  Postgres-Licensed GUI tool
                               
                              
                                Try
                                  the AWS Schema Conversion Tool, it's
                                  free and doesn't require either
                                  endpoint to be an RDS instance.
                              
                               
                                  On
                                    Tue, Nov 20, 2018, 1:10 PM <soumik.bhattacharjee@xxxxxxx
                                    wrote:
                                
                                
                                      Hello There,
                                       
                                      Anyone came
                                          across any Licensed GUI tool
                                          to migrate database schemas
                                          from Oracle to Postgres.
                                       
                                      +including
                                          Packages, Procedures etc..
                                       
                                      + Any idea of
                                          License costs if available.
                                       
                                       
                                      Thanks