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

Поиск
Список
Период
Сортировка
От Greenhorn
Тема Re: Need help migrating MSSQL2008R2 tables into PGSQL & make PGSQL mimic MSSQL behaviour.
Дата
Msg-id CAF3Y79hs-G6p1s6SD9E6rW6A3m5jVhfQK-YOh143T0pMQ=Z5Vw@mail.gmail.com
обсуждение исходный текст
Ответ на Need help migrating MSSQL2008R2 tables into PGSQL & make PGSQL mimic MSSQL behaviour.  (buggedme@riseup.net)
Список pgsql-general
Дерево обсуждения
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 2024 at 10:20, <buggedme@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 already looked
https://wiki.postgresql.org/wiki/Microsoft_SQL_Server_to_PostgreSQL_Migration_by_Ian_Harding
but
nothing is useful. For example, "Extension Links" section links are all
PAID links.

I have *.MDF and *.ldf MSSQL2008R2 DATA files.

Can anyone please give me a command to how to migrate those data? I do
not have MS' graphic studio GUI but I can
access this database using "Navicat Lite"(IP:Port login).


В списке pgsql-general по дате отправления:

Предыдущее
От: buggedme@riseup.net
Дата:
Сообщение: Need help migrating MSSQL2008R2 tables into PGSQL & make PGSQL mimic MSSQL behaviour.
Следующее
От: "Sacha Kerres"
Дата:
Сообщение: Re-2: Need help migrating MSSQL2008R2 tables into PGSQL & make PGSQL mimic MSSQL behaviour.