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 ) id 1s4iiX-000WdE-M8 for pgsql-general@arkaria.postgresql.org; Wed, 08 May 2024 14:56:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s4ihX-001TeN-Od for pgsql-general@arkaria.postgresql.org; Wed, 08 May 2024 14:55:24 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s4ihX-001TeF-9Q for pgsql-general@lists.postgresql.org; Wed, 08 May 2024 14:55:23 +0000 Received: from mail-lj1-x22a.google.com ([2a00:1450:4864:20::22a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1s4ihT-0002UN-Sf for pgsql-general@lists.postgresql.org; Wed, 08 May 2024 14:55:23 +0000 Received: by mail-lj1-x22a.google.com with SMTP id 38308e7fff4ca-2e3e18c240fso27304811fa.0 for ; Wed, 08 May 2024 07:55:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1715180119; x=1715784919; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:autocrypt :references:in-reply-to:date:to:from:subject:message-id:from:to:cc :subject:date:message-id:reply-to; bh=IMbSUFDuT7cIPqne8His9HMAunmBciZ6Qd35ZpummcU=; b=u4kphohvUH37iIBPFNhFz+p+IYoJ8vLXUFT0jcXS3CWJJ3lhjmh+CUAm4BwR3S2y5e c1MqVvQ7XhJ3CBOqYW8p3WsTUvpqFWIdaWIeTpAafUpi/7DEnDblzYZ7U7GA4ine3Srg DogKJCzeWCEjeQd2R66myIST7mt+FvrUH2y4sop1YuXTD2z8Ip42JmMHnSDmsLXbbFF8 emTuS44aXijZwwb6PnQ+3qsAHTSQG2x/OKQOl01aP2mIV3TDvWpIiId2eIHyFI50x8rB w2GF6f0c1fR7/J+1rKBEbwwdpgV4UcU9mIq8AiPEs7N6xUPCbNz4HtU78RYNBWlCAX/E VU4Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1715180119; x=1715784919; h=mime-version:user-agent:content-transfer-encoding:autocrypt :references:in-reply-to:date:to:from:subject:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=IMbSUFDuT7cIPqne8His9HMAunmBciZ6Qd35ZpummcU=; b=FXcSUj3EXKVrOHu2p5tDRlcO9Jqp0yxPUyReqdeZGbVwWaRtWH6cOxgAb9rnrKoJ2I 6mC0vylCtK5slzTU3YXOX+wQ55TAXIOe01gwjQkcPZRdr0ieFj9dBt28Cq0iBYDML+Li puTApwkSOSjyNO/GJRSlwKRNqcKZWdmHtjj9QcgLUf3Oi8EvNX0ApzUZP3u53U9oop10 JFQdaCt3v6E6WYNEGK9Gj4dikrIjBL+9a7sO4/qG0rWGdaUW+YFtmgKHSWRhuNDsV9gY Gi8QzKaKzBZSUAm8uKMuCwAWkq0/grxdJ8xytquO8GY5pJBVTulofM3RtZFD5P21vc+1 oECQ== X-Forwarded-Encrypted: i=1; AJvYcCXYM8xeBl6Ifk39y7VQAs1p/6OicsogqMsEq/qDF8d/e55b1I2Qx7Vfg1pDwU27i0RhWoV4CWooiuNUxoS/ySn896BzPxmKqiG6yTO8KHUYXu3v X-Gm-Message-State: AOJu0YwySqeVdcFpnOIY6sPr0FMxnMNvjI0VnvLFBJEiDbD1lRz8HKqQ NgPaumZ282yUhgcpDzXs5x2QplM+z+hGYVCPSgQ8bR5vqkfXwEKTTRAVnyP2VyY= X-Google-Smtp-Source: AGHT+IGfOhbKCOUF6EFRjU9vxvQAQpka/88VcwwWJfJeL+2c7+rnzq+mvo5VJ0G3XhGVmTNWuRzjow== X-Received: by 2002:a05:6512:b28:b0:51a:f689:b4df with SMTP id 2adb3069b0e04-5217cc522e0mr2709198e87.44.1715180119072; Wed, 08 May 2024 07:55:19 -0700 (PDT) Received: from localhost.localdomain ([2001:871:260:69a9:1ffa:720c:adcf:f082]) by smtp.gmail.com with ESMTPSA id e22-20020a056402105600b0057300ba262esm3587563edu.34.2024.05.08.07.55.18 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 08 May 2024 07:55:18 -0700 (PDT) Message-ID: <89d9a7e2bd3513ddd4c31b92ef672f32ee00f8c8.camel@cybertec.at> Subject: Re: Need help migrating MSSQL2008R2 tables into PGSQL & make PGSQL mimic MSSQL behaviour. From: Laurenz Albe To: buggedme@riseup.net, pgsql-general@lists.postgresql.org Date: Wed, 08 May 2024 16:55:18 +0200 In-Reply-To: <6f7520e512dcacd47eecb5b37b40554c@riseup.net> References: <6f7520e512dcacd47eecb5b37b40554c@riseup.net> Autocrypt: addr=laurenz.albe@cybertec.at; prefer-encrypt=mutual; keydata=mQINBGGDwAQBEADgbWy5cKXQld3N2mF+DFyiNFbi2oBl2T+XgxpPF8wTRw2D/u4bBKXP0SYSE/lA86jIVNWWU0gf1KODIkVvgJm2w4vH2VBV1b7ddVViGl1Iu+9zaRnv9wulhnH42KefepXnoean6UT1EzLM0opF/Ik0j+40TxdRtobkBprkQUyHDXWlHc2ffPs3SipyFEP9AVLf7ejRC46CXWDnsqjOBSMEW8Z4HiK/8RrPZBsKLts8dJxKF4pygOdJb0CWk8k/X1jbcfdxo+zOLjOMvJcSJ2pFdJmQHU+JufB3rePziqQ2S9Ur6sccr9XnTC1GVBWN4Lf5VHq+vf+bFJjVwg+2hrySZnAVfcOrxoqFLErr7ug1zN2nM1kcpgA4VWn4gxlJtYNYYq+9WxX5dtvnNANlG3ZCrRKQzl8lxtzoF6Zo7LUhEqPaHDwn7Rvs+IdbOn41lF5UDTJGqmC4gS/bZydW2Fy3YWm4aSaN9fgFf8D+PVkrlKAZB7gBLz1TyHjbcRf85cYF+GKKrDld5SzMB/V60VX3oP/Eo8ikFpyWaqiz1f9X7MBot3/PjJkY+wDzp3nmb19QEcOBuQiSQ4xds2r0HewbuHTAR68u8jNNMGmpm2j4x+g09Jd/WQDjqlTBZ/jEltH41fYCCPWMfljXTOOXu2eLNGdfi7ETZogtwjM9oTtSPQARAQABtCdMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5hdD6JAk4EEwEIADgWIQR0CqhbZGGABqoaSbdi8bhXA2EdmAUCYYPABAIbAwULCQgHAgYVCgkICwIEFgIDAQIeAQIXgAAKCRBi8bhXA2EdmM/6EADK232JCwmBzhlj8h7U9CjG6kx0JHP3uJGv+XfsHtHAlmY/RCwF1BHMEsRlk bT5UrLvJ2jb99bA9QARzhFaxzyn0F/BUKzuIjRGNs/n6d5dNUFA0kOt8sX+TacmC GEyjEBCrVCm4ranBiUyePn9NhHNWnaex7pJyqvMLLdwW9BEMJx0Fqo+DN8ukbXmYRsmhEtd3ue+x/luYmOmJnaGtzInaY5aOJYbW9XqoRIZkZvOCgbi1FfvNmoqWa+3oVxTOgw9RafjJDyW0lTHzKGjbGI5ofMU98l+/hKJFYJqWUF6VpFJY5YIcN/1lf4ZICMwDl+MPIVo/tpq8L10seJL28nLlvw3K+cI+TVW8IW/qL/LyVoDofI3USeOORuYmhpWRhik8JXX6xf3v6GrRilJIPWNFIJbxm1ZblQiQnOw3IOW7T+8nAmPin1HKqM3VrOrJQ2VtShsefNBibNAsr1oFaqcDBkn3yGG8i6CTW+FyO4PZ+/EwNxMVgktxbYdy5AT1/lpXr5tB+phhLIyVfiBvrWs5EThxYMQ/L8Y85c3GMsAy1l/x4h3jqySIYy3SCU9+jc5UVuNnXljbvkEzJ+NLWJ6C1rACFWrMszgPdh5tCrlRY9PpmYll4JbCgb8BtxEIUmR+xr50/ZElEK5iml7Q00KUekCcDt+36PsyGFTXBzNOrkCDQRhg8AEARAAzOZ2tLHlI4rrhG411h6cdCFjBZxuljaFCxFyHn3m6wbGLqwBUWC5k8UrRqjHMz88KcTSaNO7XGAmCqPdWd2SeflPZRnNTbjsVpw7mLdffsBm4JX7kki2Pvk5h0NtYeidXT1PSpc2ri4DutYXuT9uD8RAm1wUDCE5HQNUihT/WH6opt+hskHW21uHao0+y822tG0QQcGMqdQR5Vxdxj89wiEPdqW+HpU/oOZIhrf2E7prduAppxixjHy/o1rcnoznnJvc8D3+YgI9O0LrBMij89dM55pRGbLovTR1oGR3U74sX774+0xmSzeIKwZfiMUz7Atlvfk5SHOsRUFPN2Ux9kaXiiBibQpHFxt7b lDrT4wxdLJ/XCdbPPAyl+lZtOLsaHEEZvYNyTXwZc35dVf3R4/oz20HoG6s7ct8e1 AQygj43XAERzty9SkWgxs8+grp1PrGx6FHVSYRqBM8dS/ZR6yRVwOwJXPyaSSqfIF21DkE4j1y4n+ItSewPGoRp8K/yWCikt6qlkVkO2ASNIiX04fAbtzwVOaNn8ZMRNqyvLc1fED4sr49onE4cAIcBLjcC3KL+w9DUGRQCdziROj5H2Yl/sXGPdMciUHo/Uz2rggc+2th3bQiMhrHWSsBpUkDQp0yWewemstPpPgBL3h2fHKaX8B9oH5Qu/H1IgrOuX8AEQEAAYkCNgQYAQgAIBYhBHQKqFtkYYAGqhpJt2LxuFcDYR2YBQJhg8AEAhsMAAoJEGLxuFcDYR2YuPwQAMkpGtR80pQ1gVsONhdkqj0H2eU66efP/gO3CoyaoIcvrpKYj7C2HipVSmkt1gpByL0X4AMQ/vKuknUz3wd28Ba+G1dCfbVs/Xiusq+SmpUj5rTwmYqdSjWMuCo1R6oS5hdJMdUUJYGMT0QkVlm1KnW8jkmCTl9GzjDxOAsN9O6/6lPzaGFtk9XF+34Bry/N4HKiJkqpC4+UTd0AprPfzJ2jdT64e1F0+W88X8y1bTTgNrHwK4mDiLnlE4SKRuEm54lNhJz//ar86Or5BErzNpM6TL7lk44QS06hwsMrEdKIy8J/SYJPjfzR8tIUnKscclVpOgjKaBqC+0iFiVaRqAgfOlIEiezX6kMh5Q2FIUfqs46qWhhXjRrdKOEoStYAaikdLu5ZXr7vfb0ZaDh+ZwTQtbSMFolyOkecwI81MCdbMfT/1TqIGTOdAj5as9fAakk0jb2pXgUYQ8X1DVTR8ahSDVEaw9VTmWiSvTxvguVJ1Mb7gG4Gmh6aviDTJhfXtH4rPUNXhDLqrTH8JkJjyKROOMakIF68Hjse5vUfUxreBEOtb5r1Coa2Fe7ncJayaSE7ryrDbFqpZ 36UMAx4ulWMyqJajLNGY0DdG8qIsR5nxRhrnK/mrCidZ8F9/D3bWAl4rjtHlsztN59 +AnW5l0HsQcY9ntFL/zEBOaonjdJf Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.50.4 (3.50.4-1.fc39) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2024-05-08 at 00:20 +0000, 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 think you have heard about Babelfish (https://babelfishpg.org/). It is a modified version of PostgreSQL, written by Amazon, that provides a TDS interface to PostgreSQL, so that a program written for Microsoft SQL Server can connect to it. It works up to a certain extent. You could use it to migrate data to PostgreSQL, but you'd have to continue to use Babelfish unless you change your application to speak the PostgreSQL protocol. There are other tools to migrate to PostgreSQL, for example https://github.com/fljdin/mssql_migrator Yours, Laurenz Albe