Just remembered something else: DON'T use the money type on either db
(MS or Pgsql). The odbc driver for pgsql does NOT detect it properly
and causes the migration to fail.
Geoff
Andrew G. Hammond wrote:
>-----BEGIN PGP SIGNED MESSAGE-----
>Hash: SHA1
>
> I know I saw an article recently about transitioning from MS SQL Server to
>Postgres, but I have no idea where. Anyone have any pointers?
>
>- --
>Andrew G. Hammond mailto:drew@xyzzy.dhs.org http://xyzzy.dhs.org/~drew/
>56 2A 54 EF 19 C0 3B 43 72 69 5B E3 69 5B A1 1F 613-389-5481
>5CD3 62B0 254B DEB1 86E0 8959 093E F70A B457 84B1
>"To blow recursion you must first blow recur" -- me
>-----BEGIN PGP SIGNATURE-----
>Version: GnuPG v1.0.6 (GNU/Linux)
>Comment: For info see http://www.gnupg.org
>
>iEYEARECAAYFAjvyh9kACgkQCT73CrRXhLHwOwCfT5AJl9xGy1YXrW0U7pcMHGg5
>Zn4An0VCdAotkTEQkhie73kVDr4+EQ5I
>=/EOH
>-----END PGP SIGNATURE-----
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>