MIME-Version: 1.0
References: <6f7520e512dcacd47eecb5b37b40554c@riseup.net>
In-Reply-To: <6f7520e512dcacd47eecb5b37b40554c@riseup.net>
From: Greenhorn <user.postgresql@gmail.com>
Date: Wed, 8 May 2024 11:20:05 +1000
Message-ID: <CAF3Y79hs-G6p1s6SD9E6rW6A3m5jVhfQK-YOh143T0pMQ=Z5Vw@mail.gmail.com>
Subject: Re: Need help migrating MSSQL2008R2 tables into PGSQL & make PGSQL
 mimic MSSQL behaviour.
To: buggedme@riseup.net
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000e827d50617e71ac5"
Archived-At: <https://www.postgresql.org/message-id/CAF3Y79hs-G6p1s6SD9E6rW6A3m5jVhfQK-YOh143T0pMQ%3DZ5Vw%40mail.gmail.com>
Precedence: bulk

--000000000000e827d50617e71ac5
Content-Type: text/plain; charset="UTF-8"

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).
>
>
>

--000000000000e827d50617e71ac5
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">How many tables do you have, and what are=
 their sizes? I&#39;m asking because if you&#39;re considering migrating to=
 PostgreSQL, starting from scratch might be cleaner. This approach will als=
o help you gain a deeper understanding of how data types are handled in Pos=
tgreSQL compared to MSSQL.<br></div><br><div class=3D"gmail_quote"><div dir=
=3D"ltr" class=3D"gmail_attr">On Wed, 8 May 2024 at 10:20, &lt;<a href=3D"m=
ailto:buggedme@riseup.net">buggedme@riseup.net</a>&gt; wrote:<br></div><blo=
ckquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left=
:1px solid rgb(204,204,204);padding-left:1ex">I heard PGSQL can act like MS=
SQL behaviour so I&#39;m trying to migrating<br>
tables to try it myself, but I really <br>
have hard time to migrating them.<br>
<br>
I already looked<br>
<a href=3D"https://wiki.postgresql.org/wiki/Microsoft_SQL_Server_to_Postgre=
SQL_Migration_by_Ian_Harding" rel=3D"noreferrer" target=3D"_blank">https://=
wiki.postgresql.org/wiki/Microsoft_SQL_Server_to_PostgreSQL_Migration_by_Ia=
n_Harding</a><br>
but <br>
nothing is useful. For example, &quot;Extension Links&quot; section links a=
re all<br>
PAID links.<br>
<br>
I have *.MDF and *.ldf MSSQL2008R2 DATA files.<br>
<br>
Can anyone please give me a command to how to migrate those data? I do<br>
not have MS&#39; graphic studio GUI but I can <br>
access this database using &quot;Navicat Lite&quot;(IP:Port login).<br>
<br>
<br>
</blockquote></div></div>

--000000000000e827d50617e71ac5--