Re: Need help migrating MSSQL2008R2 tables into PGSQL & make PGSQL mimic MSSQL behaviour.

2024-05-08 Thread Laurenz Albe
On Wed, 2024-05-08 at 00:20 +, bugge...@riseup.net wrote: > I heard PGSQL can act like MSSQL behaviour so I'm trying to migrating > tables to try it myself, but I really have hard time to migrating them. I think you have heard about Babelfish (https://babelfishpg.org/). It is a modified versio

Re-2: Need help migrating MSSQL2008R2 tables into PGSQL & make PGSQL mimic MSSQL behaviour.

2024-05-07 Thread Sacha Kerres
You can use this tool: https://www.sqlmanager.net/products/postgresql/datapump It allows easy migration..  Original Message processed by david® Re: Need help migrating MSSQL2008R2 tables into PGSQL & make PGSQL mimic MSSQL behaviour. 8. Mai 2024, 03:20 Uhr Von Greenhorn An b

Re: Need help migrating MSSQL2008R2 tables into PGSQL & make PGSQL mimic MSSQL behaviour.

2024-05-07 Thread Greenhorn
How many tables do you have, and what are their sizes? I'm asking because if you're considering migrating to PostgreSQL, starting from scratch might be cleaner. This approach will also help you gain a deeper understanding of how data types are handled in PostgreSQL compared to MSSQL. On Wed, 8 May

Need help migrating MSSQL2008R2 tables into PGSQL & make PGSQL mimic MSSQL behaviour.

2024-05-07 Thread buggedme
I heard PGSQL can act like MSSQL behaviour so I'm trying to migrating tables to try it myself, but I really have hard time to migrating them. I already looked https://wiki.postgresql.org/wiki/Microsoft_SQL_Server_to_PostgreSQL_Migration_by_Ian_Harding but nothing is useful. For example, "Extensi