Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jIxO7-0006oB-VR for pgsql-admin@arkaria.postgresql.org; Mon, 30 Mar 2020 16:35:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jIxO6-0002mo-Kd for pgsql-admin@arkaria.postgresql.org; Mon, 30 Mar 2020 16:35:46 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jIxO6-0002mh-Ah for pgsql-admin@lists.postgresql.org; Mon, 30 Mar 2020 16:35:46 +0000 Received: from mail-qt1-x831.google.com ([2607:f8b0:4864:20::831]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jIxO4-0007ya-9G for pgsql-admin@postgresql.org; Mon, 30 Mar 2020 16:35:45 +0000 Received: by mail-qt1-x831.google.com with SMTP id e14so15646575qts.2 for ; Mon, 30 Mar 2020 09:35:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=content-transfer-encoding:from:mime-version:subject:date:message-id :references:cc:in-reply-to:to; bh=zYEAEE/Dqj+SNK6WTjq+i7ATRnkRDCE2YNeF/TFHI6w=; b=aeEQhyY0i/da298tiry3E2K+HYp2mo+KQAaA9d3JuLUK8w6/6Mzt2rMK2A/oCggBF5 radQyx+zGK/HITerg9lQXkgTcMoBUhDrOVf8nemJvmzf65ToTq2+BaoPbTExXZh5N+X0 4KDxC4AYIMfdDuTzm+gV/Ni+FFLRQR5miDYF4hRaZE4QpDOckvS2gDceij2slzyWpaox fuDVWssPqjNRvtIj9I1jt/1M/byFkxQYRVtly+Ck02QQtFQ4tHI7IkDNIOqXzE20OO9+ mvGZWDtL4nPaTCjCGWW1gmd39EL6Um6EzZg8YSDOisOoZbBwZEYyYX966/mbEwYSjPV4 L9aQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:content-transfer-encoding:from:mime-version :subject:date:message-id:references:cc:in-reply-to:to; bh=zYEAEE/Dqj+SNK6WTjq+i7ATRnkRDCE2YNeF/TFHI6w=; b=MAaLLg8Z0s0UhYAGrTH4Vhrq1U85DKTJ/R6Ryu8Q1Di3NXV/pu6Ka7DXDIymVde/Es w6H60QiH7BjH473DA/BHBw3LdkBp6KTSj/IkGOtCYbxNvtBHYYikjCtm6yqwgiEsFQDQ UnooSA00RnlH2yTl1Prvf26TFCd+6+21DSG3zH/LQ5agNwn9oSNQ5NLt7eyxh1eF1/+d 2ifJh93q496eDMfvGnT9VN2bAOREuNzxgQpkSdhHVWEivz4VTt5+o0tbQM2plfzEkXay ZkkHoTKuJrkXnD6FTy02siVNtZTd4HuCQBl9Bnz77Zo4C+S4nrZxTXPlOjSZugkIzk4z OTCg== X-Gm-Message-State: ANhLgQ2nmodZp8U8W6LzpKaeCzVxPmo4t8VtkO6iY00vE1kibPdP8LJh 3DpXF57WU9M2jsv7P1IItfc= X-Google-Smtp-Source: ADFU+vsV2ahppZo4syHr6Sv1ZTIOWPBu4iBVYUV8WuWJLbX6itFESfo2bBgPYoDcInHU51+xEJsLTg== X-Received: by 2002:ac8:6942:: with SMTP id n2mr843771qtr.238.1585586142305; Mon, 30 Mar 2020 09:35:42 -0700 (PDT) Received: from ?IPv6:2603:900a:2104:36cb:c990:4c5f:811d:9e72? ([2603:900a:2104:36cb:c990:4c5f:811d:9e72]) by smtp.gmail.com with ESMTPSA id x4sm10265908qkj.124.2020.03.30.09.35.41 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 30 Mar 2020 09:35:41 -0700 (PDT) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable From: srijith s Mime-Version: 1.0 (1.0) Subject: Re: Migration Help. Date: Mon, 30 Mar 2020 12:35:39 -0400 Message-Id: <3244A82A-42FD-42DC-B021-308B25040240@gmail.com> References: Cc: pgsql-admin In-Reply-To: To: Dhandapani Shanmugam X-Mailer: iPhone Mail (17C54) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk I did a POC and it went well , I used a tool called full convert it migrate t= ables index constraints data and all , for security you have to write some s= cripts to convert ad groups to roles etc=20 Sent from my iPhone > On Mar 25, 2020, at 12:47 PM, Dhandapani Shanmugam wrote: >=20 > =EF=BB=BF > Hi All, >=20 > I am working on DB2 migration to PostgreSQL, so would like to know if any o= ne have experience to share there stories and any recommendation. I worked o= n ora2pg and it will give a nice assessment report which will help to plan t= he migration strategy. In DB2 can we generate similar report to understand t= he complexity of migration?=20 >=20 > -D=20