MIME-Version: 1.0
From: Puspendu Panda <puspendupanda@gmail.com>
Date: Wed, 19 Mar 2025 23:37:29 +0530
Message-ID: <CABj6V64i-YMNRMZ2gh4U=dPrLiL4=hvUQE-0n+g1EcJP0NVROg@mail.gmail.com>
Subject: Postgres incremental database updates thru CI/CD
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000009ef7190630b5e50c"
Archived-At: <https://www.postgresql.org/message-id/CABj6V64i-YMNRMZ2gh4U%3DdPrLiL4%3DhvUQE-0n%2Bg1EcJP0NVROg%40mail.gmail.com>
Precedence: bulk

--0000000000009ef7190630b5e50c
Content-Type: text/plain; charset="UTF-8"

Hi ,
As my organization started working on postgres database,We are facing some
difficulties in creating CI/CD pipeline for deployment updated script(the
updated changes after base line database) .Earlier we used sql server
database and in sqlserver we have one option called DACPAC(Data-tier
Application Package) thru which we can able to generate update script and
thru CI/cd pipeline we automate deployment process  in destination database
(customer).
But in Postgres I didn't find any such tool like DACPAC .
As we need this process to incrementally update the customer database  can
you help us in this regard .
Thanks & Regards,
Puspendu

--0000000000009ef7190630b5e50c
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi ,<div>As my organization started working=C2=A0on postgr=
es database,We are facing some difficulties=C2=A0in creating=C2=A0CI/CD pip=
eline for deployment updated script(the updated changes after base line=C2=
=A0database) .Earlier we used sql server database and in sqlserver=C2=A0we =
have one option called DACPAC(<span style=3D"color:rgb(0,29,53);font-family=
:&quot;Google Sans&quot;,Arial,sans-serif">Data-tier Application Package</s=
pan>) thru which we can able to generate update script and thru CI/cd pipel=
ine we automate deployment process=C2=A0 in destination database (customer)=
.</div><div>But in Postgres I didn&#39;t find any such tool like DACPAC .</=
div><div>As we need this process to=C2=A0<span style=3D"color:rgb(0,29,53);=
font-family:&quot;Google Sans&quot;,Arial,sans-serif">incrementally update =
the customer database=C2=A0 can you help us in this regard .</span></div><d=
iv><span style=3D"color:rgb(0,29,53);font-family:&quot;Google Sans&quot;,Ar=
ial,sans-serif">Thanks=C2=A0&amp; Regards,</span></div><div><span style=3D"=
color:rgb(0,29,53);font-family:&quot;Google Sans&quot;,Arial,sans-serif">Pu=
spendu</span></div></div>

--0000000000009ef7190630b5e50c--