[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: OLEDB for PostgreSQL
From:       Pavan Pusuluri <pavan.pusuluri () gmail ! com>
Date:       2021-04-21 1:45:16
Message-ID: CAOLHn8a7114hUi-TH4NwxOnP_BO_W6hmCf_Tm=EOHafsSa0H8Q () mail ! gmail ! com
[Download RAW message or body]

I have been using SSIS for migrating data only for non-aws stuff.

If your target is on AWS, you can use SCT nd DMS.

You might also want to look into the link....https://youtu.be/YKJub0zVztE


Regards
Pavan


On Mon, Apr 19, 2021, 8:10 AM aditya desai <admad123@gmail.com> wrote:

> Hi Mustafa,
> You can look into the SQLine tool. We recently used to migrate MSSQL to
> PostgreSQL. For procedures/functions etc you need to have good amount of
> understanding of TSQL and PL-PGSQL. SQLine will convert 60-80% of you TSQL
> code. Some manual effort is required at the end.
>
> Regards,
> Aditya.
>
> On Fri, Apr 16, 2021 at 4:03 PM <mustafa.pekgoz@forenda.com.tr> wrote:
>
>> Hello,
>>
>>
>>
>> We want to start migration to POSTGRESQL13 from  MSSQL SERVER  but we
>> couldnt find any solution for oledb drivers. Please help us to find a
>> solution or any workaround if possible.
>>
>>
>>
>>
>>
>>
>>
>> Thanks.
>>
>> Mustafa
>>
>

[Attachment #3 (text/html)]

<div dir="auto"><div>I have been using SSIS for migrating data only for non-aws \
stuff.<div dir="auto"><br></div><div dir="auto">If your target is on AWS, you can use \
SCT nd DMS.</div><div dir="auto"><br></div><div dir="auto">You might also want to \
look into the link....<a \
href="https://youtu.be/YKJub0zVztE">https://youtu.be/YKJub0zVztE</a><br></div><div \
dir="auto"><br></div><div dir="auto"><br></div><div dir="auto">Regards</div><div \
dir="auto">Pavan</div><br><br><div class="gmail_quote"><div dir="ltr" \
class="gmail_attr">On Mon, Apr 19, 2021, 8:10 AM aditya desai &lt;<a \
href="mailto:admad123@gmail.com">admad123@gmail.com</a>&gt; \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 \
.8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi Mustafa,<div>You \
can look into the SQLine tool. We recently used to migrate MSSQL to PostgreSQL. For \
procedures/functions etc you need to have good amount of understanding of TSQL and \
PL-PGSQL. SQLine will convert 60-80% of you TSQL code. Some manual effort is required \
at the end.</div><div><br></div><div>Regards,</div><div>Aditya.</div></div><br><div \
class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Apr 16, 2021 at 4:03 PM \
&lt;<a href="mailto:mustafa.pekgoz@forenda.com.tr" target="_blank" \
rel="noreferrer">mustafa.pekgoz@forenda.com.tr</a>&gt; wrote:<br></div><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div lang="TR"><div><p \
class="MsoNormal">Hello,<u></u><u></u></p><p class="MsoNormal"><u></u>  <u></u></p><p \
class="MsoNormal">We want to start migration to POSTGRESQL13 from   MSSQL SERVER   \
but we couldnt find any solution for oledb drivers. Please help us to find a solution \
or any workaround if possible.<u></u><u></u></p><p class="MsoNormal"><u></u>  \
<u></u></p><p class="MsoNormal"><u></u>  <u></u></p><p class="MsoNormal"><u></u>  \
<u></u></p><p class="MsoNormal"><span>Thanks.<u></u><u></u></span></p><p \
class="MsoNormal"><span>Mustafa</span><u></u><u></u></p></div></div></blockquote></div>
 </blockquote></div></div></div>



[prev in list] [next in list] [prev in thread] [next in thread]