Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1s4V2q-004bQY-SM
	for pgsql-general@arkaria.postgresql.org; Wed, 08 May 2024 00:20:28 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1s4V2n-00621B-D6
	for pgsql-general@arkaria.postgresql.org; Wed, 08 May 2024 00:20:26 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <buggedme@riseup.net>)
	id 1s4V2m-0061ys-K0
	for pgsql-general@lists.postgresql.org; Wed, 08 May 2024 00:20:25 +0000
Received: from mx0.riseup.net ([198.252.153.6])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <buggedme@riseup.net>)
	id 1s4V2h-001wtM-LN
	for pgsql-general@lists.postgresql.org; Wed, 08 May 2024 00:20:23 +0000
Received: from fews02-sea.riseup.net (fews02-sea-pn.riseup.net [10.0.1.112])
	(using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)
	 key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256)
	(No client certificate requested)
	by mx0.riseup.net (Postfix) with ESMTPS id 4VYwlQ0jJNz9tN9
	for <pgsql-general@lists.postgresql.org>; Wed,  8 May 2024 00:20:18 +0000 (UTC)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=riseup.net; s=squak;
	t=1715127618; bh=OGXDJ3Ao7jUiQ2qbaKeJLhkTMoW28HuuzbSniRFn9s8=;
	h=Date:From:To:Subject:From;
	b=XSq0FQWlzW3fFzRyCvoChviQ75kHD75i8igl0odo2I/5EEglzIBzvfffd6TJ65BS+
	 rQJEGvmswQAut9LrS1kPi/ehFSL9gejWA6IZ1glqrxFSo2zCbeH9k5Gy8FvKKDMBVL
	 l4cSFv/tRTYy6hbFrtpEQdqZrk9CAWzJdpsw1fBk=
X-Riseup-User-ID: 8153EFCF2D81CFFF8C92649CE9129D65E11C6B37F34E802194736E6B9B754132
Received: from [127.0.0.1] (localhost [127.0.0.1])
	 by fews02-sea.riseup.net (Postfix) with ESMTPSA id 4VYwlP6tTWzFq03
	for <pgsql-general@lists.postgresql.org>; Wed,  8 May 2024 00:20:17 +0000 (UTC)
MIME-Version: 1.0
Date: Wed, 08 May 2024 00:20:17 +0000
From: buggedme@riseup.net
To: pgsql-general@lists.postgresql.org
Subject: Need help migrating MSSQL2008R2 tables into PGSQL & make PGSQL mimic
 MSSQL behaviour.
Message-ID: <6f7520e512dcacd47eecb5b37b40554c@riseup.net>
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/6f7520e512dcacd47eecb5b37b40554c%40riseup.net>
Precedence: bulk

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