[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-sql
Subject: RE: How to handle application connectivity change when moving from Oracle to Postgres in GCP
From: "Mike Sofen" <msofen () runbox ! com>
Date: 2023-09-10 18:32:50
Message-ID: 09d101d9e415$35b46040$a11d20c0$ () runbox ! com
[Download RAW message or body]
This is a multipart message in MIME format.
From: kunwar singh <krishsingh.111@gmail.com> Sent: Sunday, September 10, 2023 10:43 \
AM
To: pgsql-sql@lists.postgresql.org
Subject: How to handle application connectivity change when moving from Oracle to \
Postgres in GCP
Hi Listers,
Say we have this App->DB connectivity Model.
APP1
Contains synonyms which point to objects under APP1.
APPOWN
Contains the tables, indexes
And it is a Java application that connects to APP1.
Now when the database is switched from Oracle 19c onprem to CloudSQL Postgres say \
v15.
Questions that I have:
1. What needs to be done at the database end in terms of schema setup in order to \
ensure the application is able to connect to the relevant tables without any \
concerns?
2. Do I need to create users APP1 and APPOWN in postgres? If so, what privileges are \
required to be assigned to these?
3. How to tie them with service accounts?
4. With which username/service account does the application make connection to the \
database?
I still don't understand user/schema concepts in postgres tbh as I'm still a noob :)
--
Cheers,
Kunwar
Kunwar,
Since you mentioned CloudSQL (Google Cloud's db platform for postgres, mysql, and sql \
server), I recommend contacting your rep at Google Cloud on this topic. They just \
went GA on their DMS product (Data Migration Service) for Oracle to CloudSQL-Postgres \
migrations (and AlloyDB shortly) – pretty good timing. DMS converts schema and \
code, understands most permissions and security pieces, and most importantly, has \
great tech support. Usually there is no charge for using DMS (Google underwrites the \
cost since you're migrating to their platform).
Mike
[Attachment #3 (text/html)]
<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" \
xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type \
content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 \
(filtered medium)"><style><!-- /* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.gmailsignatureprefix
{mso-style-name:gmail_signature_prefix;}
span.EmailStyle25
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link="#0563C1" \
vlink="#954F72" style='word-wrap:break-word'><div class=WordSection1><div \
style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p \
class=MsoNormal style='margin-left:.5in'><b>From:</b> kunwar singh \
<krishsingh.111@gmail.com> <b>Sent:</b> Sunday, September 10, 2023 10:43 \
AM<br><b>To:</b> pgsql-sql@lists.postgresql.org<br><b>Subject:</b> How to handle \
application connectivity change when moving from Oracle to Postgres in \
GCP<o:p></o:p></p></div><p class=MsoNormal \
style='margin-left:.5in'><o:p> </o:p></p><div><div><p class=MsoNormal \
style='margin-left:.5in'>Hi Listers,<o:p></o:p></p></div><div><p class=MsoNormal \
style='margin-left:.5in'><o:p> </o:p></p></div><div><p class=MsoNormal \
style='margin-left:.5in'>Say we have this App->DB connectivity \
Model.<o:p></o:p></p></div><div><p class=MsoNormal \
style='margin-left:.5in'><o:p> </o:p></p></div><div><p class=MsoNormal \
style='margin-left:.5in'>APP1<o:p></o:p></p></div><div><p class=MsoNormal \
style='margin-left:.5in'>Contains synonyms which point to objects under \
APP1.<o:p></o:p></p></div><div><p class=MsoNormal \
style='margin-left:.5in'><o:p> </o:p></p></div><div><p class=MsoNormal \
style='margin-left:.5in'>APPOWN<o:p></o:p></p></div><div><p class=MsoNormal \
style='margin-left:.5in'>Contains the tables, indexes<o:p></o:p></p></div><div><p \
class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div><div><p \
class=MsoNormal style='margin-left:.5in'>And it is a Java application that connects \
to APP1.<o:p></o:p></p></div><div><p class=MsoNormal \
style='margin-left:.5in'><o:p> </o:p></p></div><div><p class=MsoNormal \
style='margin-left:.5in'>Now when the database is switched from Oracle 19c onprem to \
CloudSQL Postgres say v15.<o:p></o:p></p></div><div><p class=MsoNormal \
style='margin-left:.5in'>Questions that I have:<o:p></o:p></p></div><div><p \
class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div><div><p \
class=MsoNormal style='margin-left:.5in'>1. What needs to be done at the database end \
in terms of schema setup in order to ensure the application is able to connect to the \
relevant tables without any concerns? <o:p></o:p></p></div><div><p \
class=MsoNormal style='margin-left:.5in'>2. Do I need to create users APP1 and \
APPOWN in postgres? If so, what privileges are required to be assigned to \
these?<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'>3. How to \
tie them with service accounts?<o:p></o:p></p></div><div><p class=MsoNormal \
style='margin-left:.5in'>4. With which username/service account does the application \
make connection to the database?<o:p></o:p></p></div><div><p class=MsoNormal \
style='margin-left:.5in'><o:p> </o:p></p></div><div><p class=MsoNormal \
style='margin-left:.5in'>I still don't understand user/schema concepts in \
postgres tbh as I'm still a noob :) <o:p></o:p></p><div><p \
class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div></div><div><p \
class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div><div><p \
class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div><p \
class=MsoNormal style='margin-left:.5in'><span class=gmailsignatureprefix>-- \
</span><o:p></o:p></p><div><p class=MsoNormal \
style='margin-left:.5in'>Cheers,<br>Kunwar<o:p></o:p></p><p \
class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p \
class=MsoNormal>Kunwar, <o:p></o:p></p><p class=MsoNormal>Since you mentioned \
CloudSQL (Google Cloud's db platform for postgres, mysql, and sql server), I \
recommend contacting your rep at Google Cloud on this topic. They just went GA on \
their DMS product (Data Migration Service) for Oracle to CloudSQL-Postgres migrations \
(and AlloyDB shortly) – pretty good timing. DMS converts schema and code, \
understands most permissions and security pieces, and most importantly, has great \
tech support. Usually there is no charge for using DMS (Google underwrites the cost \
since you're migrating to their platform). <o:p></o:p></p><p \
class=MsoNormal><o:p> </o:p></p><p \
class=MsoNormal>Mike<o:p></o:p></p></div></div></div></body></html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic