Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pyq1f-0000WV-KA for pgsql-admin@arkaria.postgresql.org; Tue, 16 May 2023 08:27:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pyq1c-0006uE-QT for pgsql-admin@arkaria.postgresql.org; Tue, 16 May 2023 08:27:16 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pyq1c-0006u5-EZ for pgsql-admin@lists.postgresql.org; Tue, 16 May 2023 08:27:16 +0000 Received: from mout.gmx.net ([212.227.17.22]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1pyq1V-0006ML-Gk for pgsql-admin@lists.postgresql.org; Tue, 16 May 2023 08:27:15 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=s31663417; t=1684225628; i=shammat@gmx.net; bh=sQDpFDekMNQVJAWttGHYTrLzJ0vvS1P7BcmsMkIw12E=; h=X-UI-Sender-Class:Subject:To:References:From:Date:In-Reply-To; b=FrGg28AHhZkMyy3oUGKtNiRNFE0bQhG0k+pDE72B9BYes19dk1+AJ9oo3Efuc5SLg JEJpzFTyBx5QP21LiKOufQH2LZTJVhtFusMrJV7Dx4M1PIY5xrzMPM5I/MChDFKjzm M5KSgU8INdjya/d9z1MivitxZget68R0NGaqQ+5S4WjY9pwQhwmlnYHEAJItTbtZMi TscLE3jLJQARXbdJqfTNICNcFcQLjYtZMIYn68fgkV3GvToKGb0q1IIq7LLOHHTuhB 3eB00DmH490dK2tpxCDS46GDQ4Shb8bOCUbqQN/v/sedXRaMOkA6V45a+v3e2K79BW n6ngM+yOI1TOQ== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [10.8.0.19] ([185.40.248.10]) by mail.gmx.net (mrgmx104 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MHG8m-1puO32254q-00DG3h for ; Tue, 16 May 2023 10:27:08 +0200 Subject: Re: Migrating MSSQL 2017 to Postgresql To: pgsql-admin@lists.postgresql.org References: From: Thomas Kellerer Message-ID: <38a08485-3598-574a-05f3-e3591ff06776@gmx.net> Date: Tue, 16 May 2023 10:27:07 +0200 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Language: de-DE Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:CDYvgzQl8DvF7DJK+k+d5q81S3HduJzvWOuT4Qzn6GqjpCZFeG9 qOPAgjhIqiiNpdx/KTDdhIb1zDEVWrI1KZm4rDLICQ4bFZ76hM+YVJAgGOTRBNqDcNZObjX pYQsX/i3u4YZxA4b6mKZC7O0A2JfoI/NO+vTRMA8CfbUpTsFcoSicaR+uYlch3NBWtVlIjw uVUDpU+0nl09eLFWYuDWw== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:hYGEe5PIgh8=;vaOAIUW/gDJhBTb/F+2EsObsgms Xt8yhGPJqi9h3taFjS6jMygUald4mKLVakZNRvMre78CnbV5uvO0/ywvV4/ndXckCeyxshmTW Kvk2HhDsftXI16CCarO5I4d1vKJNSXWmig/oWEXwVSumuZFO/xT5H1WN/VKzfLZvNLESa4AgA i3C/dwm9BVKBq1fuf8bEvJh/3ApO4UR9VX+CehB2EB2RRxMr3HtaWCG3ka9BYWW3iUBKeSoT7 KaC9KcsiJjZCElDGEAaro/wgbISKr48U+TLVGTEzEKYEa4AW9qAtD0LPy2zgaLE9zYcjYYOUy l4tghsDbaWfgg6CmCcLf4E1JZipcCdwesy44GYQphIB4guhalBBSk9umlcL0Mq/jlUaA0/1Hh FtXMQ2lJdZEXtozzZQ5AOpTZtHr4toFJXF5tsI+5foRousctqmoK5DJb4zwpvsNVWi15AHesy ROhZyMI2B5CqN0HEXfMjFOWZ26bZ2xMPINnCQBTSaV+oTTdWGxmXKSHE+lHbtKwl+muILQLxs KIbpSL1lXLMMN1e/ZMS0CJXdi3ERnF2ymthO1QJQDBLq7vmwshbQrHXYsOldavrn2n4FHGcwi Em+gqgGuLCuvr0Goj8sd3tvgJk2NQmgMUhLLbimKFAsDwZAv+ma2WJ77nKKvhj0H6tbIpexRV QDOLTgC9/+1xNp6zVkj4R6BeVwdnHntWaXv3nhtgWifljKF99hvJqXm+GmGQGIZ0+4TpTQJp7 BfJKfxYyYvrNumWQz9O9IBgAXWdhJJESuyrKiqDtd2Oy3d87qRc83NIYNn+o271AAB/kKIDM/ /zSBHOWBlsM8da9S5TkmISDFt8rF9IKPsCkUiTV/j4Jur6qNI2wLFqdMNvaGUsESh9wergqZ/ ngt/k5ajqBSqu3nrpaWUSNcC33gUH1KTAnrBtGWe6Unj4SR3BSwfFpthHtuHlwrhxbL8/BMw7 rVf2qg== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Vishak Raj schrieb am 16.05.2023 um 09:39: > I need to migrate my data saved in mssql server 2017 to postgresql > > The mssql server is in a docker image running on ubuntu > > I got this blog-[https://dev.to/abhinavgupta1997/migrating-database-from= -sql-server-mssql-to-postgresql-1mje] for this migration > > But I want to do the migration using the command line only. the above li= nk shows the migration using GUI app > > Could you please share the instructions for migrating the mssql server t= o postgresql using ubuntu terminal > > There are not much about the migration using command line I have never used it, but you could try: http://dalibo.github.io/sqlserver2pgsql/