From: | Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it> |
---|---|
To: | Thom Brown <thombrown(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: MSSQL to PostgreSQL |
Date: | 2009-07-31 13:24:58 |
Message-ID: | 20090731152458.76fb316e@dawn.webthatworks.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, 31 Jul 2009 13:47:39 +0100
Thom Brown <thombrown(at)gmail(dot)com> wrote:
> Hi all,
> We're migrating the contents of an old MSSQL server to PostgreSQL
> 8.3.7, so a full conversion is required. Does anyone know of any
> guides which highlight common gotchas and other userful
> information?
http://wiki.postgresql.org/wiki/Microsoft_SQL_Server_to_PostgreSQL_Migration_by_Ian_Harding
These were the places I read when I had to migrate some MS SQL DB to
Postgresql.
I admit I mostly did it by exporting csv from MS SQL[1],
refactoring the schema and rewriting from scratch functions... but
those were the places where I read the info I needed.
[1] suddenly MS SQL became unable to export proper csv so I remember
I wrote an rudimentary odbc2csv tool as well. Since it was inspired
by an even more rudimentary work of a colleague I'll ask if he can
release it under GPL if you'll find yourself in the need of such a
beast.
You may also find useful FreeTDS
http://www.freetds.org/
http://www.webthatworks.it/d1/page/odbc,_freetds_and_microsoft_sql_(and_php)
and dblink
http://www.postgresonline.com/journal/index.php?/archives/44-Using-DbLink-to-access-other-PostgreSQL-Databases-and-Servers.html
http://www.postgresql.org/docs/8.3/static/dblink.html
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2009-07-31 13:29:24 | Re: Can I have a look at your TuningWizard generated config file? |
Previous Message | Jennifer Trey | 2009-07-31 13:18:30 | Re: Can I have a look at your TuningWizard generated config file? |