Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1peGOR-0001Sj-87 for pgsql-general@arkaria.postgresql.org; Mon, 20 Mar 2023 14:21:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1peGOQ-0007dV-6N for pgsql-general@arkaria.postgresql.org; Mon, 20 Mar 2023 14:21:46 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1peGOP-0007d8-RS for pgsql-general@lists.postgresql.org; Mon, 20 Mar 2023 14:21:45 +0000 Received: from mout.gmx.net ([212.227.17.21]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1peGON-0002XQ-CS for pgsql-general@lists.postgresql.org; Mon, 20 Mar 2023 14:21:44 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=s31663417; t=1679322100; i=shammat@gmx.net; bh=xHp9OTiKzQX9yF80VCZZ7odQl+5jbwAkXcSMQYXzzXc=; h=X-UI-Sender-Class:Subject:To:References:From:Date:In-Reply-To; b=rDFqZD9e+//DMn0zzPwuDKsN0EUtt+/0f/R56OJlNXyWFa3+GlwJjJMG/VHSK81PJ hrAK9hkHIqmvX0+/1v/yKccjPVPhIpRSe2nllNkJv39mA2EEVxQfJVM72EOIXwJVU+ Mp8b7Taf4S9G0SkJJBsoBnV445weURuoen9iIHWwqRO427C2Jt62BSHWmmgthIFaQG 1C8FNnNIstu0cnIdkF6xiuAV8MppR77I2o7ZFXpTsVFQ+BlkAIi3kboTkDzcdV4d7C C5la4COVJJME8pufKy59fJT2Fo6dabQeZxM6CdNNmbDE1dCRA0pcncomfm8cjVmbHT EMk04EJJwPJLQ== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [10.1.34.101] ([185.40.248.10]) by mail.gmx.net (mrgmx104 [212.227.17.168]) with ESMTPSA (Nemesis) id 1Msq24-1qSv4W0Fpo-00tAUn for ; Mon, 20 Mar 2023 15:21:40 +0100 Subject: Re: Oracle to PostgreSQL Migration To: pgsql-general@lists.postgresql.org References: From: Thomas Kellerer Message-ID: <11205ccd-566a-e5bd-2d8f-a4aad6b24821@gmx.net> Date: Mon, 20 Mar 2023 15:21:39 +0100 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Language: de-DE Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K1:BcuYHKx53Km+5SGiwbun0udt6z1SAliM41dcimZViqWDS2QvePD eMZWbmdK7xZx9aLCrFYeHOoKLpQma/WNqAGbYv/AXYAe59iU//SY8unTE3H2UfZSywyFtWx 6M/9nWWsY0yrVJPJX+GhKIj0IhqBC/svHAkYJwFxtB3riZoao22xeoKPHZPW5nL60TNfam4 APOA2M+7rjg97wcNHgTaw== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:emQe0UF9Ksc=;g+i921UXdmqpJNfjEo7Rpdw5sBA XwZkjDh0jLnWP2oAF0rJtpdZiGnFYKHDNU8TRxLyVkfEP2lHBMD8u2FgTg7LmfFfUHmP9SbBT 7fikqr787NGt/jA4Eon14x1CDzhOcGud2WOUAMpQMlommBGGSjJCK1DF0/sFGfx8LIn8pjKsF AmWAZu0md785SHYBMYqcVZ897TcJ47j492Y8igFbdMer4OVTrZVC+0i9mZpC1A6h7LUDa31Uf NNTppw0mxSKuECXGFtvFFcXqiBUyWwUz32nX2mfmAGtkyHRcz1nXUU+8YLHnTFNhk764DD2uD mKbc/vBnZipoZmQEd+y35kMC6IY7KiG3wHF8NeXxdLvyQnnTmqESJYIgSmwHpjiWNkcEpudAo EQXoXgjMjGIHKTrtrBwBZByv0C1z3gHhYHlma/4IKkemzFSIdLHEzzZVMhFo3a7ZdhaNB1lgw EbS/yTR699jm05jF0BED3CgYUBhuHnCZu5ZFhYSCy+xR5diFPqrpHjP20LfH0a9j53XfFOFNK 0H01DdU6g+nh8E+uhqKB+pn0f1rVbqGR2N3s0EHaxN0OyaIKQyONd/6smOFzi4jh1lzJo8iVk +VtJ6hkUG8nW9LOSJJNDqcuUfKqD8AyKG9yIpZAWwpXSRa1i+qu/6r39JQDsgt/DEPQSU0xSG aZnJr2C6oWCyh04bDv+MWXYR+oibTSur2wZsPQroUQ3/lBP7o1GVRYmXD9fv6MmC2WZnsmyGk soFnDvlp8ytzuJvv/XFc3Z0PxcGL1t7b7JJrdxZH0phPA3Vm9dFCJfmHoKAXX88/l3M1SdgxS Ra891iLyryVWi9yQTekC2X2flSi26anY6HZ7BItO7hnYsyz/jejMnlIp3AEUpnFLCl/ZgKr+P hX16uYJzEhZMBPKrLOyFmnIsS+RG9jcPtTv+mS7FOGJ19Ek5lId2HS2nmebVARepFirchC2cd 7jiUfEOeoccB8PMOrCx0z66NoNw= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Inzamam Shafiq schrieb am 20.03.2023 um 13:57: > We have an Oracle DB which is around 1TB and we want to migrate to > PostgreSQL that have a new table structure, so we want to perform > data transformation and real time CDC from Oracle to PostgreSQL. Do > we have any good open source tool to achieve this with No Coding > involved.?? You could try debezium, but I don't know how good it works and if it qualifies as "no coding involved"