public inbox for [email protected]
help / color / mirror / Atom feedFrom: Greenhorn <[email protected]>
To: [email protected]
Cc: [email protected]
Subject: Re: Need help migrating MSSQL2008R2 tables into PGSQL & make PGSQL mimic MSSQL behaviour.
Date: Wed, 8 May 2024 11:20:05 +1000
Message-ID: <CAF3Y79hs-G6p1s6SD9E6rW6A3m5jVhfQK-YOh143T0pMQ=Z5Vw@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
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, <[email protected]> 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).
>
>
>
view thread (3+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Need help migrating MSSQL2008R2 tables into PGSQL & make PGSQL mimic MSSQL behaviour.
In-Reply-To: <CAF3Y79hs-G6p1s6SD9E6rW6A3m5jVhfQK-YOh143T0pMQ=Z5Vw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox