Migrating a Microsoft-SQL database to Postgres

Migrating a Microsoft-SQL database to Postgres

am 09.07.2005 16:10:04 von Josef Springer

--------------020100060109020605080407
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

i want to migrate a MS-SQL database to postgres. I have a SQL-script for
the tables (definitions, indices a.s.o.), created by the
MS-Enterprise-Manager. How can i create a postgres database with this
script. Does a tool exist for reading such a script ?
--

Best Regards,
Josef Springer

-- the software company --

Orlando-di-Lasso Str. 2
D-85640 Putzbrunn

Tel. ++49(0)89 600 6920
Fax ++49(0)89 600 69220
mailto Josef.Springer@joops.com
Website http://www.joops.com


--------------020100060109020605080407
Content-Type: multipart/related;
boundary="------------030105090807090908020709"


--------------030105090807090908020709
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit





Hi,



i want to migrate a MS-SQL database to postgres. I have a SQL-script for
the tables (definitions, indices a.s.o.), created by the MS-Enterprise-Manager.
How can i create a postgres database with this script. Does a tool exist
for reading such a script ?

--




Signature

Best Regards,

Josef Springer



 -- the software company --


Orlando-di-Lasso Str. 2

D-85640 Putzbrunn





















Tel. ++49(0)89 600 6920
Fax ++49(0)89 600 69220
mailto
Website





--------------030105090807090908020709
Content-Type: image/jpeg;
name="image120.jpg"
Content-Transfer-Encoding: base64
Content-ID:
Content-Disposition: inline;
filename="image120.jpg"

/9j/4AAQSkZJRgABAQEAxgDGAAD/2wBDAAEBAQEBAQEBAQEBAQEBAQEBAQEB AQEBAQEBAQEB
AQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQH/2wBDAQEBAQEB AQEBAQEBAQEB
AQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEB AQEBAQH/wAAR
CAA9ANwDASIAAhEBAxEB/8QAHQAAAwADAQEBAQAAAAAAAAAAAAgJBgcKBQQD Av/EADgQAAEE
AgECAgcIAgICAwEAAAUDBAYHAggJAAFY2RIWGBl4mJkKERMUFTm31iK5NjcX ISQydrb/xAAU
AQEAAAAAAAAAAAAAAAAAAAAA/8QAFBEBAAAAAAAAAAAAAAAAAAAAAP/aAAwD AQACEQMRAD8A
fTQTQTRKZaJaVS+X6ValSqWSrUrXGSSiUSTXGnTkikkiOU7DSZs8fNk4a6JG DRgk6ckShQi5
cPiD5wu7drrOFlFMm193Bx4eAzTD5XKP/o3Rxwft4aF/Bhq5/B8G6c/oEw93 Bx4eAzTD5XKP
/o3R7uDjw8BmmHyuUf8A0bqaXPwzs2kNOJvthQF/7C0xZ8VnVZtS6UHvSzhk KOx+QlBkBXGp
12rIXsKArJZPBZXu6igaNLvX7YgSLLkn5J7m7b/iXh551pXrleNhW9eVyWtc 1NRibzKTWxcF
gzQf2cTJBpJO40HCSshWggFEJ2zQFjyoyNN5GuxRVwIGXfZ67wUDd3u4OPDw GaYfK5R/9G6U
qG6CaJOt7djog50q1KcRMHqVpVJAkXX1xp1aOh5FKri37GSg8LCKQ3IaPNSQ bDYgOPlGjZF8
YYxWNtCK7huDGJtbCdJhBv3D9o/gw0L/AJw5H+gPdwceHgM0w+Vyj/6N0e7g 48PAZph8rlH/
ANG6ZC1bQg1J1rOrdsw+0i9f1xFjMxlx9737/gjgYJks/eq4JYdu6zt2omj+ XHj2uCr0k/Wb
D2KC7xygjnBvTmz9peZgnOthZJaFo6laAx6YmoNStQ0XKHNdXVd5CPZt0yk3 tK6gaXaXBY22
/NKjVIzWRwAxcHe70EoTc5QpzIZiFVPdwceHgM0w+Vyj/wCjdHu4OPDwGaYf K5R/9G6VK5uN
ewoLDzE10D2x2jpO9o2N7lYjGLH2Dsm/aLsYyMao5Yxyx4JfZ+xWSKUl7tVG OElEOR6sbdlF
CKbF6Oa4CO3ocTHJ8I5E6ulguZxdKsdn6MfsotfVY9uzhuzRKqKPh6MvijUg qqTQjpYmHLMX
oQgq6Kw42zXBlHj9uoGNmg8ffvQTRKG6Jbqy+IaValRWWRXUrY6SReURvXGn QcijciB07MiY
Q8BNjIa1JBzQck1bERZQc5bvh75ug7aLouEU1MW193Bx4eAzTD5XKP8A6N0c j/7eG+nwYbR/
wfOenP6BMPdwceHgM0w+Vyj/AOjdHu4OPDwGaYfK5R/9G6ULlV5OSumS1Ra6 a+xQVaG7W0Js
PF6WhJnNTONRZtI5EhEBs7mrdq5avXbR/I11AsVDpuWLcuRHnH78kgNjT5mR zeBcZz+VRNgX
3K2v2t2Cu0sx/OSw3Ddi7eoKqY0ff9k1yDGqqro+S1rFwoAct6bJg6NCCJUq 3TwdkU2mHdmJ
Fgw3u4OPDwGaYfK5R/8ARuj3cHHh4DNMPlco/wDo3UhdmtgtlOEm2Kjmk/t+ 29vuOO6JUrAJ
NjcpNKdbBa7TlduuYbOA9qLs2RyxQpIGyLlwIGYuyDx6wisgBZPhJbswkpno qikpjs5i8bm0
QMMJFE5gADymLyAWvi5GHY7IBzYsEMDnOP8Ai4YExrts9aL4/wCKrddNTt/6 y7dBJqG6CaJO
t7djog50q1KcRMHqVpVJAkXX1xp1aOh5FKri37GSg8LCKQ3IaPNSQbDYgOPl GjZF8YYxWNtC
K7huDGJtW193Bx4eAzTD5XKP/o3RBv3D9o/gw0L/AJw5H+nP6BMPdwceHgM0 w+Vyj/6N0e7g
48PAZph8rlH/ANG658ftBEhvjT2W6jSPWXa3aeqRl7zKwonYUXZbBWtJA2bo Y+gDsUcjqcxl
UgXjyqSUoONXIlg4wAdkcBGA4UOwZr4u3r240g3Q1s1+sO8tNOSndaU2nUMV M2IvAdkpXW95
RKxgsOHOzJuPjxr+rBOAeSOwyBDuJ7ZNSwowTQGilRwxVz+uswpH7uDjw8Bm mHyuUf8A0bpS
t1dBNEorTsNJxfSrUqNknW2ugkbckQOuNOh3ziOzLe3XGIS8Cu7HQ1u4WCyq JnDcXkgtRTJi
cjpgoEJoOhpB22W/jhe5NCHJXredk87joyMXbT8gHwu1GsfwURjMgzKjcyUZ m8fYruHboQ1k
TVqSavwrhy57MTQUnmyX7jHLFFBuN9P+j4N8Z/HB/sP1c6A93Bx4eAzTD5XK P/o3R7uDjw8B
mmHyuUf/AEbpz+p/coO5jvQnSi39jggcbIZrH24OM12DMZqYiHs6mpxjHAbo skgq3cPBUf7P
nUoKDWrlo5Kjgboa3esFXeL1uGZe7g48PAZph8rlH/0bo93Bx4eAzTD5XKP/ AKN0kOtHH2Qv
ShaqvfY7dDcyyL4t+vojaj2eVhs7YdRwWCvJ7Hh8nbBqfr+sSgCuxsYCIk0W 7Fd/HC6R7NFQ
m4aoMnyYdp4uo8S3Wpjk+nVE7FbKzfY+iwumxiY62yiXC4uDNKCylx14HkrK xfVEKCazGzow
sMYi3swMJP3j2PvxhQf3C5yU4GSB+PdwceHgM0w+Vyj/AOjdN5w81vXdR5cj 9e1RAoXWMAj+
/wCF/QYPXsWBwuHhP1bjq4+ThT9IjMbYjQo39SNEiJch+SZI/nChB6QcfiO3 S6ynp9ZDxd/8
x5N/j/iv+tbjr6BD+OD9vDQv4MNXP4Pg3Tn9Jhxwft4aF/Bhq5/B8G6bg+fC RQCblEmLDwMc
jYgkfkB0s7RYCgoQOzWIlSxN85zTbsh45g2cPHrtdTBFu2RVWVzxwwyy7BEX 7R3+05en/wCz
pH+XIj05/FJ+2ro18MdR/wD8iO6mjznX/S2yHC7b1p0XZcTs+vzdhVCKGyaK k03jJUqJt+LJ
kxKyWfZF4xKseyOazgY+bNnybXuk87t/yi6KylYuOaCSCstBtNIHLGLoVKI1 rPS7GRiHzfu1
fBTmcBBuioN8h3UU/DehXzhcW7/z79snDRTPtjh2y7YYg53SYQb9w/aP4MNC /wCcOR/pz+kw
g37h+0fwYaF/zhyP9BLr7TdOJFEeMQmFBuXDZjZN7VRB5V2b+l27OI63Tk8+ xbOM8Vku+DdS
QwaP5Z/4uMVMsMEc0fQVyWRcbhLBjI9xWaXMBLbBq1cVe9OKpJ44Y45k5PNp VJTTnv2wxwx7
5vDBZ+8Uy79u+eai+eamWamWWeWRcumnJfebQy56RiCKC1ltmoqxapScZ4JJ vJ9AXuJpiBxV
VURboLTEPibhLZ47WSZj3EjSIus8UGinfpMvs6eyg2ztER2uMkVXDXhp5K5V VVjQc4muwlQo
G+lchOwsmQDPE0nQ9q3SdFoFm3Wx7OGpmBFkHaLbLJviqF+euJzRN+5qj7T1 tNBoYrmOjdmS
fZhhKh2P4eKDtsZD4XS6SxSRTSRwwSnAVk8afcn+Ig3w7o91FO+auavZ5NZp E64iEnn87kAu
KQuGAiknlUlNOsGYkEACs1iBQoQcqf4otWTNBVdXL7ssu+OHo4Y555Y49+VL g1oeXbOb3bj8
u0wAEAdZWVN7ZjmuKRtDJJ6fRmM0yyJn2WK+X5rsygkIDDoB3f4p4sCZc7IW DPLBaNvmyIdA
vI/+3hvp8GG0f8Hznpz+kw5H/wBvDfT4MNo/4PnPTn9BxQuDD62PtaAATOO+ JQXBJETDxMau
mnm1DMa+0ukk0jnZompk59DLCYpryvJTvn+JiXIOnKGLLv8AgoNu17rjr5Wa wO8e/MZq5yuJ
iiS2v1izWEx655IIav1cYRJkIS4p+bNnyA/BfLHGS0r6Uij7dLDDOTmAcyHq N+6yeTh/2AhD
YeShREjjpUedj58WwNgjYh43ICjAcq0SfjCox+0UVavh5Bkug7ZPGyqjdy2W SWRUzTzxy7hF
T7RZGBB/iS2NKkkPxnsJkNFyePqfcl3/ACpd3eleQxZf71ElM8fSAy421+9H JFX/AOT93dXu
j3VRV9r7PjNpBN+J7WhaRvcyLqMLWlCR7xbv3yX7x+M2vM2MdZK9/wD1j6AY N+SBsu2GOHbE
cNZ45+mtiqqouX2jy5nBDVyA6JVc1cTjYfci1q9BxqrY/wBsXclIQqISlrK8 zWTXHLti0aOr
AAQ0IwcEc2jNz6Rt7g67No4WUbVm49tV0dKdM6B1o/NtSJet4X6MvJsu+ebI jPpUWJTSfO2C
quOK6wvOYyI0mHzXxxW7CE2KeaaXodksA/ODfuH7R/BhoX/OHI/05/SYQb9w /aP4MNC/5w5H
+nP6Dkk+1RL4tm3HY5yTXVxb3DaC+STZFRy5UxSTqVTum3bo45qrr59sfRSR SxyUVU744YY5
ZZdu3el28/JFg515tCrdX9adx7p2Os2FSCuovA1tNNnYGwhRSagVRGUrnZqx 6piYXuEjTIsq
ZySAvzKBdVkggq+GAnyklZzV+1Nqpp+7k/EUww+65bNV7+nnjj9yaf8A4i/E U7+l37fdgn6e
Pp5//XD0sfS79vv7ff1r9BCLgL44rO4/dZJs7vVBuGui/JYHl0lhTMi1KJwK MRkS4GRCMlXo
9w8FO5R+KVkRk6sJduWLZMsND9l1nQlysrQ7fT/o+DfGfxwf7D9XOnP6TDfT /o+DfGfxwf7D
9XOgc/pTt4tSITvNq7a2sc8IugQuxRDLsKlDBtg8fxGWx4sxkkRk7Zpku0/P YCZCKYLERfZ4
x7Gg/ciFUetUSKq2DY9JLv8AbT9tNKGE3w+XYNYqEu/X+NWK9INcneA6sJ3b 0Rh1ilWqOGWG
f6kIiJosVG98cu33vmaGGX+GeXfsHJPX+0PKz9n0OjKY2PrjLYTTLAw5Hwcn iSIO4Ug1cr93
GXapLawFuyEAfufRVfd6usILmz7Z9ijoNGRmZB1JV+pzRzevTLkbbMLyoYui 6tOv4kah8hh8
vaog7drGOT8rFDR0IbBtyD5k8j8hNQGLOUJEDeno67fR/BqwMpvkSrHB4zIW vbggbkOfFQ6z
6ysCPo/mhpVmGmUHmkWNtUnTfJVq6TIgpCCKslUHTfPLB2wet1EXCWSieWGf fj/heo0Z0e+0
nUVWem+ZIVW1jVKfs+zIAIfrkQtbRGURS0mcrhBlZdw4XbRbsXhsQm8aHnXG WY4pJIawF91M
kY/goHZn1kPF3/zHk3+P+K/61uOvrHush4u/+Y8m/wAf8V/1rcdfQIfxwft4 aF/Bhq5/B8G6
aibQyL2NDJdXs3DNZFC55GD8Ml8ffd1sWR2LygU7CHwzzu3VQcdmpMU+dsnH dBZFbskvn3SV
Tz9HPtKLQSG72utEtKnMQ2O1KBxNxqVrivFwkk0quKVSIPHVqdhqgQWflAzf uGjZIaHjcmzQ
oeHRCKsTD5Fci0jYNu4TGNW19RuQ/wAUemHyGXh5j/QJbr7wYam6/Nl4ezsH YizKK7W8LvQf
rXaE6ipalELMAskmcfkRcJHoDGJFLP0LFuy7Ng8mk5OOF0hILtLwsndiUXud oekw9RuQ/wAU
emHyGXh5j/R6jch/ij0w+Qy8PMf6Bz+kwg37h+0fwYaF/wA4cj/R6jch/ij0 w+Qy8PMf61iK
1v3tD3NPbxbbX6lKSyxKxqSqDY5fRS4so61jtMyq7JfF3otonyHJEkDT8lfE vQPuHZd8xdMR
sbSHDhbhmTcmAo71Py8+NXXO5rcQ2Kj7uzdctk00OzN5sDrNN8qvsaQjfwUG +YuaoKi5BBZ+
yWRZsEF8ZzC5Eus0HshyjjIah2Z9809RuQ/xR6YfIZeHmP8AR6jch/ij0w+Q y8PMf6DRki4t
IHb6odrtjs1tvt7CwhLEq2qO3rDhMVp4g/ZvlXYZ9KILQ9a0+jNXgvH8t2Tx mRA8MzXRXzRG
NGT90OzpVHo7H4iCDxeKAw8YjMeGswwCOx4YyCggYgchg1Hig4gag2HjBrFq km2ZsWTdBq1Q
TwRQSwTwxx7KR6jch/ij0w+Qy8PMf6PUbkP8UemHyGXh5j/QHI/+3hvp8GG0 f8Hznpz+pxXZ
rfvbfFNW3R0v2v1KGxO5qxntUSgjG9FLiZyJhHbEipWIG3oF2T5DjA1qaajT DlcW4IiCjFB8
mgq7HPm+KjZXZ3qNyH+KPTD5DLw8x/oGdsKu4JbMKkdcWdEI7PYFLxqgiTxC WCWZyPnByueC
vdsRGP0lmy+Ka6SLpvnkn+K1doN3jZRF0girhOmHcWwCmWKsX1m3H3b1uq/J 8o4YU9CLLrqe
13FGK6jldwNgTa+qjt2SQ5uou4/FxSYSVVljljmoqwXcq/mcN8+o3If4o9MP kMvDzH+j1G5D
/FHph8hl4eY/0Hn65cfGuuts9kNzh2U0tXYaXNVGEq2OviYP7RugwMUTRQ7i G8lKJthsWC9m
zdu07hoQCjApRm3btF2ards3TSd/pMPUbkP8UemHyGXh5j/R6jch/ij0w+Qy 8PMf6Ag37h+0
fwYaF/zhyP8ATn9TiFa372h7mnt4ttr9SlJZYlY1JVBscvopcWUdax2mZVdk vi70W0T5DkiS
Bp+SviXoH3Dsu+YumI2NpDhwtwzJuTGzvUbkP8UemHyGXh5j/QaA234hdYt6 JSAlu0Mvvyy3
8Rbl2cOG52W1jUbiLI65aOiyEfjMTjIQIyVI5DhaRElkyWMFG4gSkUIvcRrP ujQSrK5Xq6MN
oplYlj2MyHotGowjZxkPJJEyZs22LZNutI2UfDGDmauOGKrkhJnZwsuv6Sih Dv6efbJevUbk
P8UemHyGXh5j/R6jch/ij0w+Qy8PMf6Bz+kw30/6Pg3xn8cH+w/Vzo9RuQ/x R6YfIZeHmP8A
Wsbb1v3tuaKiohKNr9SmA0PZ1J2u2XA6KXE1fKSKh7mgV4xBkuqR5DijfIKS lldhB0kbptkn
zyOuijQYRDkl2hdiFHel12k1dqrcKqFaSusc9N1sQmEElkijzN8uNwkqcDlg uXNI8TeM80X6
QUw8EoMjHYa6YkFR6rhJo+aq59lsddeo3If4o9MPkMvDzH+j1G5D/FHph8hl 4eY/0GjgHFxD
qqF9ovrDthutqzXaaeTZnVNbXFH53XANm7eNlyicTEbD1/dRiGLuEk3X5LOK yAQyHP3ipDEe
4+9Zs43ZqfoTQuoBOfzODdpxYNyW07SeWtsDdcsXsa7LC7t+6XdozOzB00YI Mw7X8u2/CAxs
SBCZZs2Kq49Zdi0VQ/X1G5D/ABR6YfIZeHmP9HqNyH+KPTD5DLw8x/oHP6yH i7/5jyb/AB/x
X/Wtx19If6jch/ij0w+Qy8PMf6bzh5Y2INy5H2VrymFzSfo7/hf16TV7AjlY w8l+Jx1cfKwv
9Ig8ksi3DQT8mFUHDyH52wpB+pFGr0u3/SWhBAGNBQ+OD9vDQv4MNXP4Pg3T n9aipPjB3toe
mqko6Ib2alEonTNYwKqIuRknHXcTyRP47XcVFRAI9PuxnJiHGujToaHbLlHA 4QLYrvlF1Wg5
i3yTbJbO9hjkP8cGmH047w80LoIZaynOSl4QpOdmsbWOvIfx1aqSeyqVuONK wcBct2yae363
vON+uUmAiO1f7LgY8CrQkNSKkWoJlg5GR6xwYUHNWE4in0VcX3vtpTTvIxG7 oAMpV7zuQ22B
t8hcNH/oDQPtlDmeqQmyJHVbPEyDOtadIlm9YgnRT9El0VQMGRTmQshjcnjc X2GOQ/xwaYfT
jvDzQuj2GOQ/xwaYfTjvDzQugnhPB1rRezarjNlOrtZa1YU4W7G++vpW+bOk pTYcnL8cXIic
TyGsZBsqzgbCJEVCMCOMSEcjyD9qZZTMsyTHwoMut8yfbpSElAAlVdruJ0se 3piQaGP7OZ2r
WE9y147akW+XsBvbcgj4EXdsTqgdsMMjjWHTGxxgGcEzioQAUJE40Rij0zZ/ 2GOQ/wAcGmH0
47w80Lo9hjkP8cGmH047w80LoIvSRhup2j2xdZuDd9VxLTVzaLxuve1Zt57c cQiVRSnaOv4r
eNxVVsZOB5uTSB+Wqk5IXFsVpPGYBxSI6BGJQgHfQGRoTspmKVr7szOwdcJD K4TaNbRGlLRc
VZskDiFfyR+JvSXtK2uF3OrNjLBsGIH3+ugxaG1iYqI6NR7pTCUXG4hpHLGX V8iOe1w9hjkP
8cGmH047w80Lo9hjkP8AHBph9OO8PNC6CVdfzzc8fLIhcluVnZSlP7EzA5H5 tVARcoYnmucE
sNOIR7XIkLikK7JyiPPYQmMIvNmSKDdU5HpVcEqlq8nbQOlI+yaZbEojcIeV 8ijz83sEs2rg
21YamYHZvchwURDldN6tOFVIWxPnyAy0/wAK7j89QbkiTeXug8zQdR4a6YuY 0wGCqT+wxyH+
ODTD6cd4eaF0ewxyH+ODTD6cd4eaF0Ekqzk11ucIfluF7WIyKKa064FK9Rpi F3uu8JWQrWLU
1fpC41NdYs9tYLbImfsMhuEPsFYTA3wRwNYR0AclZKYMmvzBPeAS2QUQnHJb PIS1FG9vpFHS
NuwVq6D2NW0elVVNNd43tWLjAQU6hZiXw01Oko7mwVilpC8RoiXygKUl4edw l/Xb2GOQ/wAc
GmH047w80Lo9hjkP8cGmH047w80LoI+vrI2vsGJ3dIZDH9laFTZ7xQ0Wwije qZXZndpT8W0/
pDtNYkPdVKREW2aouX7HoWCiEuzXRtJTzmRuUHj4cMhLueIAdk1Vja831/2Q alQmyYAhCMZC
TosgVsO/GZkyRTqpFVgOhWNh13R2zB0aPmCayrgDd7S1kiMlKKIRifSgI2ag ovTn2GOQ/wAc
GmH047w80Lo9hjkP8cGmH047w80LoI522rsfBNWePw9GW2xBidTWyqZfbZsO 7zaKYShuEI6p
XCTmqc3GVgOnNuVvH0rlShOJljCI8DYjZf8AoQR+0YtXKjbvn7qc3S8qaGrx ANeYQD7SEfY7
DvYrF9sDlqCNfXVeSldwVrQdtZX4m0SztazmcECzJGoIvIzgevyUnLQvFvN+ yT0dU32GOQ/x
waYfTjvDzQuj2GOQ/wAcGmH047w80LoJgziRz5GAWvnq4nuk6eYSfXBQL/5i iVmdoyPIFth4
w2sxnCE7vBIbPFEFq9dln1jrq4GadjUFTa9oY+AkWclaJY5trIt5w8quFKCN 5OsMbcYW88ig
Pek4tMzg7LaMMRpbGjG7ZZcSRxdW2s3eTPvW8XY5rGDyGEjyYCCPZit3b1h9 hjkP8cGmH047
w80Lo9hjkP8AHBph9OO8PNC6CYz41udAdm9NaQPM7GsipkbWtV9L9k40GFKx ya1Ax1lutSJR
bZRgAatUIHZgC1+9dpIyJiDDVxaRRMAbja8ekr4zW4NUKUk3KsfjNdojWUxb mVOOLUSV2Ivc
YIhFJe4vtzZ16o3jGa6xncM/8ZCtki0DaxVR1lbSi8WhhRlXaE2gziOTF1II 9ej2GOQ/xwaY
fTjvDzQuj2GOQ/xwaYfTjvDzQug11SJkeeqmEExrO1GDdUKkiqzu4RJglrNy DVRVqUSm7GWN
2xPuaxJIu+yr1livGSKf4T+HPH0TcBXayV2tJLHHXddSdujthnFZsh1dZawC KOGX/hBpCl6v
NnthErFluqEIntrBZwzn+BMWsMnTPGCOYIhD84rHCxIhO3fVGfYY5D/HBph9 OO8PNC6PYY5D
/HBph9OO8PNC6CHiM936xnGvk4Dx/YztC6ep/aueWBAJfH/WBxsIHgexdSQy AxuRPBlZVm5Q
taY64SWxZ3QkXNRKE2WdlEWA5zuOu3yc4Tz829pnvwoE2NsqOsL7YsrBC6YT mpazi0KsVw5r
OEE9z2cKsGINmUCiRCw21gmdZgiNk7AgwzItPq7UnMkGMk0RkaAOMbq+wxyH +ODTD6cd4eaF
0ewxyH+ODTD6cd4eaF0EVWEv3Mxi21C0JYXMsIdV7Sxqlklo3sO7cRiwMLSM BrFED8dk62h9
6m3Z+JZBSL1mFbyaFAI0CXIZZgTR1VzIXUKE9oENzdbxJpPDKlCNKbTPJ+rX wiVOIOnOBh/W
zCscJ4aKM1R4s6qPI2N3gjFR+zcFmyc0Ubt3uItfJo63sMch/jg0w+nHeHmh dHsMch/jg0w+
nHeHmhdB9/WQ8Xf/ADHk3+P+K/61uOvrD/YY5D/HBph9OO8PNC6azRvVKxNW hGwjm17hhd0T
/YbYBK9Dx6vadOUfDwH5DX+gtfhcWEQySXPfJpb8ELQw6QEDb2fKfnikhet2 4ga0Yodlw//Z

--------------030105090807090908020709--

--------------020100060109020605080407--

Re: Migrating a Microsoft-SQL database to Postgres

am 09.07.2005 18:19:26 von Andreas Kretschmer

Josef Springer schrieb:

> Hi,
>=20
> i want to migrate a MS-SQL database to postgres. I have a SQL-script fo=
r=20
> the tables (definitions, indices a.s.o.), created by the=20

This is a german mailing list, and you are from germany. Also ab jetzt
deutsch, fällt mir leichter.


> MS-Enterprise-Manager. How can i create a postgres database with this=20
> script. Does a tool exist for reading such a script ?

Mir ist kein Automatismus bekannt, der das kann. Versuch einfach mal,
das in psql einzulesen. Wenn Fehler kommen, dann halt händisch das
Script anpassen. M$ ist leider bekannt, gern mal eigene, von anerkannten
Normen abweichende Dinge zu tun; Du wirst also einiges per Hand machen
müssen.

Falls unlösbare Probleme auftauchen, wielleicht hier oder in #postgresq=
l
oder ähnlichen Orten nachfragen, meiner Erfahrung und Meinung nach ist
die PG-Community sehr, sehr hilfsbereit.

PS.: das sollte gleich mal so als allgemeines Danke gelten ;-)


Andreas
--=20
Diese Message wurde erstellt mit freundlicher Unterstützung eines freil=
au-
fenden Pinguins aus artgerechter Freilandhaltung. Er ist garantiert fre=
i
von Micro$oft'schen Viren. (#97922 http://counter.li.org) GPG 7F4584D=
A
Was, Sie wissen nicht, wo Kaufbach ist? Hier: N 51.05082°, E 13.56889°=
;-)

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend