pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedMssql to postgres migration
6+ messages / 4 participants
[nested] [flat]
* Mssql to postgres migration
@ 2024-03-28 17:57 Rajesh Kumar <rajeshkumar.dba09@gmail.com>
0 siblings, 2 replies; 6+ messages in thread
From: Rajesh Kumar @ 2024-03-28 17:57 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Hi
Is it possible to migrate from mssql to postgres?
Any links available?
Can I setup postgres DA like location1: 1 master and 1 slave and location2:
1 master and 1 slave ?
Is there a better way to set up DA?
I am very very new to these topics..I have searched enough in internet.
Could not find the right source.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Mssql to postgres migration
@ 2024-03-28 18:07 Ron Johnson <ronljohnsonjr@gmail.com>
parent: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
1 sibling, 1 reply; 6+ messages in thread
From: Ron Johnson @ 2024-03-28 18:07 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Thu, Mar 28, 2024 at 1:57 PM Rajesh Kumar <rajeshkumar.dba09@gmail.com>
wrote:
> Hi
>
> Is it possible to migrate from mssql to postgres?
>
> Any links available?
>
> Can I setup postgres DA like location1: 1 master and 1 slave and
> location2: 1 master and 1 slave ?
>
>
What's DA?
>
> Is there a better way to set up DA?
>
> I am very very new to these topics..I have searched enough in internet.
> Could not find the right source.
>
I'd search for an MS-SQL Foreign Data Wrapper for Postgresql.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Mssql to postgres migration
@ 2024-03-28 18:08 Rajesh Kumar <rajeshkumar.dba09@gmail.com>
parent: Ron Johnson <ronljohnsonjr@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Rajesh Kumar @ 2024-03-28 18:08 UTC (permalink / raw)
To: Ron Johnson <ronljohnsonjr@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Thanks. Sorry DR Disaster recovery
On Thu, 28 Mar 2024, 23:37 Ron Johnson, <ronljohnsonjr@gmail.com> wrote:
> On Thu, Mar 28, 2024 at 1:57 PM Rajesh Kumar <rajeshkumar.dba09@gmail.com>
> wrote:
>
>> Hi
>>
>> Is it possible to migrate from mssql to postgres?
>>
>> Any links available?
>>
>> Can I setup postgres DA like location1: 1 master and 1 slave and
>> location2: 1 master and 1 slave ?
>>
>>
> What's DA?
>
>
>>
>> Is there a better way to set up DA?
>>
>> I am very very new to these topics..I have searched enough in internet.
>> Could not find the right source.
>>
>
> I'd search for an MS-SQL Foreign Data Wrapper for Postgresql.
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Mssql to postgres migration
@ 2024-03-28 18:08 Holger Jakobs <holger@jakobs.com>
parent: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
1 sibling, 1 reply; 6+ messages in thread
From: Holger Jakobs @ 2024-03-28 18:08 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Am 28.03.24 um 18:57 schrieb Rajesh Kumar:
> Hi
>
> Is it possible to migrate from mssql to postgres?
>
> Any links available?
>
> Can I setup postgres DA like location1: 1 master and 1 slave and
> location2: 1 master and 1 slave ?
>
>
> Is there a better way to set up DA?
>
> I am very very new to these topics..I have searched enough in
> internet. Could not find the right source.
Yes, of course a migration is possible. Any migration is.
Unfortunately, there are less tools available compared to the migration
from Oracle. Just have a look at the foreign data wrappers for these
systems. The Oracle FDW is well maintained, documented and has many
features. The MS SQL FDW is old, not well documented and is lacking many
features. It can't even write or push down anything.
Some tool that might help are:
* pgLoader
* sqlserver2pgsql
M$ people like to call the product "Microsoft SQL Server" just "SQL
Server", as if it was THE SQL Server and PostgreSQL, Oracle or DB2
weren't SQL Servers.
There is a Schema Conversion Tool by AWS in case you want to migrate to
PostgreSQL on AWS. Maybe it's possible to go this way and then continue
to on-premise PostgreSQL.
With PostgreSQL you always have 1 Primary (formerly called Master) and
any number of Secondaries (formerly called Slaves). So no, you cannot
have two Primaries, whether in a single or in two separate locations.
Keeping several Primaries completely in Sync and continuously
maintaining ACID makes everything so slow that it is hardly a sensible
solution.
"Multi-Master" promises a lot, but keeps little.
Kind Regards,
Holger
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
chat with me on Signal messenger
<https://signal.me/#eu/GpIP259bBne_JiBYJFvbZCLYJELhB-92nJfncACL1LUeBOphfXFFgLYYVXv_AGhg;
Attachments:
[image/png] SkJ8gBgoAxb5WfIM.png (551B, ../../c0c3d835-93e3-aeb7-34df-eaadfd8d507a@jakobs.com/3-SkJ8gBgoAxb5WfIM.png)
download | view image
[application/pgp-signature] OpenPGP_signature (202B, ../../c0c3d835-93e3-aeb7-34df-eaadfd8d507a@jakobs.com/4-OpenPGP_signature)
download
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Mssql to postgres migration
@ 2024-03-28 18:13 Rajesh Kumar <rajeshkumar.dba09@gmail.com>
parent: Holger Jakobs <holger@jakobs.com>
0 siblings, 1 reply; 6+ messages in thread
From: Rajesh Kumar @ 2024-03-28 18:13 UTC (permalink / raw)
To: Holger Jakobs <holger@jakobs.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
So , is it better to have DR set up like the follows instead of multimaster?
Location1: 1 master and 1 standby
Location2: 1 standby
?
On Thu, 28 Mar 2024, 23:39 Holger Jakobs, <holger@jakobs.com> wrote:
> Am 28.03.24 um 18:57 schrieb Rajesh Kumar:
>
> Hi
>
> Is it possible to migrate from mssql to postgres?
>
> Any links available?
>
> Can I setup postgres DA like location1: 1 master and 1 slave and
> location2: 1 master and 1 slave ?
>
>
> Is there a better way to set up DA?
>
> I am very very new to these topics..I have searched enough in internet.
> Could not find the right source.
>
> Yes, of course a migration is possible. Any migration is.
>
> Unfortunately, there are less tools available compared to the migration
> from Oracle. Just have a look at the foreign data wrappers for these
> systems. The Oracle FDW is well maintained, documented and has many
> features. The MS SQL FDW is old, not well documented and is lacking many
> features. It can't even write or push down anything.
>
> Some tool that might help are:
>
> - pgLoader
> - sqlserver2pgsql
>
> M$ people like to call the product "Microsoft SQL Server" just "SQL
> Server", as if it was THE SQL Server and PostgreSQL, Oracle or DB2 weren't
> SQL Servers.
>
> There is a Schema Conversion Tool by AWS in case you want to migrate to
> PostgreSQL on AWS. Maybe it's possible to go this way and then continue to
> on-premise PostgreSQL.
>
> With PostgreSQL you always have 1 Primary (formerly called Master) and any
> number of Secondaries (formerly called Slaves). So no, you cannot have two
> Primaries, whether in a single or in two separate locations.
>
> Keeping several Primaries completely in Sync and continuously maintaining
> ACID makes everything so slow that it is hardly a sensible solution.
>
> "Multi-Master" promises a lot, but keeps little.
>
> Kind Regards,
>
> Holger
> --
>
> Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
>
> chat with me on Signal messenger
> <https://signal.me/#eu/GpIP259bBne_JiBYJFvbZCLYJELhB-92nJfncACL1LUeBOphfXFFgLYYVXv_AGhg;
>
Attachments:
[image/png] SkJ8gBgoAxb5WfIM.png (551B, ../../CAJk5AtaM75By1vPHAb=dhbNmnF8tJUozn7NOVn==LaRyk7jQgw@mail.gmail.com/3-SkJ8gBgoAxb5WfIM.png)
download | view image
[image/png] SkJ8gBgoAxb5WfIM.png (551B, ../../CAJk5AtaM75By1vPHAb=dhbNmnF8tJUozn7NOVn==LaRyk7jQgw@mail.gmail.com/4-SkJ8gBgoAxb5WfIM.png)
download | view image
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Mssql to postgres migration
@ 2024-03-28 20:54 Eduardo Barbachan <eduardobarbachandb@gmail.com>
parent: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Eduardo Barbachan @ 2024-03-28 20:54 UTC (permalink / raw)
To: Rajesh Kumar <rajeshkumar.dba09@gmail.com>; +Cc: Holger Jakobs <holger@jakobs.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
Yes, it is possible.
I've performed some and strongly recommend pgloader to perform the
translation part. It's an excellent tool.
Em qui., 28 de mar. de 2024 às 15:14, Rajesh Kumar <
rajeshkumar.dba09@gmail.com> escreveu:
> So , is it better to have DR set up like the follows instead of
> multimaster?
>
> Location1: 1 master and 1 standby
> Location2: 1 standby
>
> ?
>
> On Thu, 28 Mar 2024, 23:39 Holger Jakobs, <holger@jakobs.com> wrote:
>
>> Am 28.03.24 um 18:57 schrieb Rajesh Kumar:
>>
>> Hi
>>
>> Is it possible to migrate from mssql to postgres?
>>
>> Any links available?
>>
>> Can I setup postgres DA like location1: 1 master and 1 slave and
>> location2: 1 master and 1 slave ?
>>
>>
>> Is there a better way to set up DA?
>>
>> I am very very new to these topics..I have searched enough in internet.
>> Could not find the right source.
>>
>> Yes, of course a migration is possible. Any migration is.
>>
>> Unfortunately, there are less tools available compared to the migration
>> from Oracle. Just have a look at the foreign data wrappers for these
>> systems. The Oracle FDW is well maintained, documented and has many
>> features. The MS SQL FDW is old, not well documented and is lacking many
>> features. It can't even write or push down anything.
>>
>> Some tool that might help are:
>>
>> - pgLoader
>> - sqlserver2pgsql
>>
>> M$ people like to call the product "Microsoft SQL Server" just "SQL
>> Server", as if it was THE SQL Server and PostgreSQL, Oracle or DB2 weren't
>> SQL Servers.
>>
>> There is a Schema Conversion Tool by AWS in case you want to migrate to
>> PostgreSQL on AWS. Maybe it's possible to go this way and then continue to
>> on-premise PostgreSQL.
>>
>> With PostgreSQL you always have 1 Primary (formerly called Master) and
>> any number of Secondaries (formerly called Slaves). So no, you cannot have
>> two Primaries, whether in a single or in two separate locations.
>>
>> Keeping several Primaries completely in Sync and continuously maintaining
>> ACID makes everything so slow that it is hardly a sensible solution.
>>
>> "Multi-Master" promises a lot, but keeps little.
>>
>> Kind Regards,
>>
>> Holger
>> --
>>
>> Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
>>
>> chat with me on Signal messenger
>> <https://signal.me/#eu/GpIP259bBne_JiBYJFvbZCLYJELhB-92nJfncACL1LUeBOphfXFFgLYYVXv_AGhg;
>>
>
--
Att.
Eduardo Barbachan
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2024-03-28 20:54 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-03-28 17:57 Mssql to postgres migration Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2024-03-28 18:07 ` Ron Johnson <ronljohnsonjr@gmail.com>
2024-03-28 18:08 ` Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2024-03-28 18:08 ` Holger Jakobs <holger@jakobs.com>
2024-03-28 18:13 ` Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2024-03-28 20:54 ` Eduardo Barbachan <eduardobarbachandb@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