| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | buggedme(at)riseup(dot)net, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Need help migrating MSSQL2008R2 tables into PGSQL & make PGSQL mimic MSSQL behaviour. |
| Date: | 2024-05-08 14:55:18 |
| Message-ID: | 89d9a7e2bd3513ddd4c31b92ef672f32ee00f8c8.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 2024-05-08 at 00:20 +0000, buggedme(at)riseup(dot)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 version of PostgreSQL, written by Amazon, that provides
a TDS interface to PostgreSQL, so that a program written for Microsoft
SQL Server can connect to it. It works up to a certain extent.
You could use it to migrate data to PostgreSQL, but you'd have to
continue to use Babelfish unless you change your application to speak
the PostgreSQL protocol.
There are other tools to migrate to PostgreSQL, for example
https://github.com/fljdin/mssql_migrator
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2024-05-08 15:17:29 | Re: Unexpected data when subscribing to logical replication slot |
| Previous Message | Marcin Barczyński | 2024-05-08 13:41:55 | How to change NUMERIC type under a domain without rewriting a table? |