transitioning from MS SQL Server to Postgres
-----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-----
I can give one suggestion: DTS is your friend. At least for migration
of data. One other thought though, if you want to make any changes to
your db layout, do them in MS SQL while you still can. Pgsql is not
friendly to changes in db structure (dropping columns, changing data
types, etc). If you have a lot of changes to be done use the query
analyzer. DTS is too painful to do large scale changes in a migration.
Also, another reason for changing the data with MS SQL before importing
to pgsql is that it will take sometime when DTS is transfering the data
(at least an hour). When you do your migration the way to do is is
install the Pgsql ODBC driver on the MS SQL server, set it up, and
define it as you other data source in DTS.
Geoff
Andrew G. Hammond wrote:
Show quoted text
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1I 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.orgiEYEARECAAYFAjvyh9kACgkQCT73CrRXhLHwOwCfT5AJl9xGy1YXrW0U7pcMHGg5
Zn4An0VCdAotkTEQkhie73kVDr4+EQ5I
=/EOH
-----END PGP SIGNATURE--------------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
-- Start of PGP signed section.
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?
Sure, try http://techdocs.postgresql.org.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026Just 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:
Show quoted text
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1I 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.orgiEYEARECAAYFAjvyh9kACgkQCT73CrRXhLHwOwCfT5AJl9xGy1YXrW0U7pcMHGg5
Zn4An0VCdAotkTEQkhie73kVDr4+EQ5I
=/EOH
-----END PGP SIGNATURE--------------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Techdocs has this article:
http://techdocs.postgresql.org/techdocs/sqlserver2pgsql.php
"Andrew G. Hammond" <drew@xyzzy.dhs.org> writes:
Show quoted text
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---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster