pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedOLEDB for PostgreSQL
7+ messages / 7 participants
[nested] [flat]
* OLEDB for PostgreSQL
@ 2021-04-16 10:32 mustafa.pekgoz@forenda.com.tr
0 siblings, 3 replies; 7+ messages in thread
From: mustafa.pekgoz@forenda.com.tr @ 2021-04-16 10:32 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: OLEDB for PostgreSQL
@ 2021-04-16 12:31 Google FezaCakir <fezacakir@gmail.com>
parent: mustafa.pekgoz@forenda.com.tr
2 siblings, 0 replies; 7+ messages in thread
From: Google FezaCakir @ 2021-04-16 12:31 UTC (permalink / raw)
To: mustafa.pekgoz@forenda.com.tr; pgsql-admin@lists.postgresql.org
Please look at this:
https://www.postgresql.org/ftp/odbc/versions/
Cum, 2021-04-16 tarihinde 13:32 +0300 saatinde,
mustafa.pekgoz@forenda.com.tr yazdı:
> 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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: OLEDB for PostgreSQL
@ 2021-04-16 14:25 Thomas Kellerer <shammat@gmx.net>
parent: mustafa.pekgoz@forenda.com.tr
2 siblings, 1 reply; 7+ messages in thread
From: Thomas Kellerer @ 2021-04-16 14:25 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
mustafa.pekgoz@forenda.com.tr schrieb am 16.04.2021 um 12:32:
> 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.
I don't think there is a free OleDB provider, but there seems to be at least one commercial: https://www.pgoledb.com/
I don't really know the whole OleDB/.Net/ODBC world (it seems, Microsoft changes its strategy around that every other year) - but there is a free .Net provider: https://www.npgsql.org/ not sure if that is of any help
And obviously there is an ODBC driver.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: OLEDB for PostgreSQL
@ 2021-04-16 21:42 Jonah H. Harris <jonah.harris@gmail.com>
parent: Thomas Kellerer <shammat@gmx.net>
0 siblings, 1 reply; 7+ messages in thread
From: Jonah H. Harris @ 2021-04-16 21:42 UTC (permalink / raw)
To: Thomas Kellerer <shammat@gmx.net>; +Cc: pgsql-admin@lists.postgresql.org
On Fri, Apr 16, 2021 at 10:25 AM Thomas Kellerer <shammat@gmx.net> wrote:
> mustafa.pekgoz@forenda.com.tr schrieb am 16.04.2021 um 12:32:
> > 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.
>
> I don't think there is a free OleDB provider, but there seems to be at
> least one commercial: https://www.pgoledb.com/
>
> I don't really know the whole OleDB/.Net/ODBC world (it seems, Microsoft
> changes its strategy around that every other year) - but there is a free
> .Net provider: https://www.npgsql.org/ not sure if that is of any help
>
> And obviously there is an ODBC driver.
>
Back in the day, this was possible via the "Microsoft OLE DB Provider For
ODBC drivers" and using the Postgres ODBC driver. Is the generic
Microsoft-provided OLE DB provider for ODBC not still around?
--
Jonah H. Harris
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: OLEDB for PostgreSQL
@ 2021-04-16 21:52 Kenneth Marshall <ktm@rice.edu>
parent: Jonah H. Harris <jonah.harris@gmail.com>
0 siblings, 0 replies; 7+ messages in thread
From: Kenneth Marshall @ 2021-04-16 21:52 UTC (permalink / raw)
To: Jonah H. Harris <jonah.harris@gmail.com>; +Cc: Thomas Kellerer <shammat@gmx.net>; pgsql-admin@lists.postgresql.org
On Fri, Apr 16, 2021 at 05:42:16PM -0400, Jonah H. Harris wrote:
>
> Back in the day, this was possible via the "Microsoft OLE DB Provider For
> ODBC drivers" and using the Postgres ODBC driver. Is the generic
> Microsoft-provided OLE DB provider for ODBC not still around?
>
> --
> Jonah H. Harris
Looks like it still is:
https://docs.microsoft.com/en-us/sql/ado/guide/appendixes/microsoft-ole-db-provider-for-odbc?view=sq...
Regards,
Ken
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: OLEDB for PostgreSQL
@ 2021-04-19 13:10 aditya desai <admad123@gmail.com>
parent: mustafa.pekgoz@forenda.com.tr
2 siblings, 1 reply; 7+ messages in thread
From: aditya desai @ 2021-04-19 13:10 UTC (permalink / raw)
To: mustafa.pekgoz@forenda.com.tr, Pgsql Performance <pgsql-performance@lists.postgresql.org>
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
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: OLEDB for PostgreSQL
@ 2021-04-21 01:45 Pavan Pusuluri <pavan.pusuluri@gmail.com>
parent: aditya desai <admad123@gmail.com>
0 siblings, 0 replies; 7+ messages in thread
From: Pavan Pusuluri @ 2021-04-21 01:45 UTC (permalink / raw)
To: aditya desai <admad123@gmail.com>; +Cc: mustafa.pekgoz@forenda.com.tr, Pgsql Performance <pgsql-performance@lists.postgresql.org>
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
>>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2021-04-21 01:45 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-04-16 10:32 OLEDB for PostgreSQL mustafa.pekgoz@forenda.com.tr
2021-04-16 12:31 ` Google FezaCakir <fezacakir@gmail.com>
2021-04-16 14:25 ` Thomas Kellerer <shammat@gmx.net>
2021-04-16 21:42 ` Jonah H. Harris <jonah.harris@gmail.com>
2021-04-16 21:52 ` Kenneth Marshall <ktm@rice.edu>
2021-04-19 13:10 ` aditya desai <admad123@gmail.com>
2021-04-21 01:45 ` Pavan Pusuluri <pavan.pusuluri@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox