[GENERAL] migrating from MSSQL

2009-05-08 Thread Eugene .
Hi all, I've been tasked with evaluating the feasibility of migrating our in-house application from MSSQL to PostgreSQL. It is fairly old and has lots of stored procedures, which is why we need to think carefully before making the switch. Does anyone else have a similar experience? What are

[GENERAL] migrating from MSSQL

2009-05-08 Thread Eugene .
Hi all, I've been tasked with evaluating the feasibility of migrating our in-house application from MSSQL to PostgreSQL. It is fairly old and has lots of stored procedures, which is why we need to think carefully before making the switch. Does anyone else have a similar experience? What are

Re: [GENERAL] migrating from MSSQL

2009-05-08 Thread John R Pierce
Eugene . wrote: Hi all, I've been tasked with evaluating the feasibility of migrating our in-house application from MSSQL to PostgreSQL. It is fairly old and has lots of stored procedures, which is why we need to think carefully before making the switch. Does anyone else have a similar

Re: [GENERAL] migrating from MSSQL

2009-05-08 Thread Gevik Babakhani
Hi I have migrated a very large database from MSSQL to PG. This was a database of +/- 400 tables. You should note the following. - MSSQL datatypes are not always compatible with PG datatypes. If you do this carefully PG will save you a lot of time. - The timestamp datatype of MSSQL is not

Re: [GENERAL] migrating from MSSQL

2009-05-08 Thread Magnus Hagander
Eugene . wrote: Hi all, I've been tasked with evaluating the feasibility of migrating our in-house application from MSSQL to PostgreSQL. It is fairly old and has lots of stored procedures, which is why we need to think carefully before making the switch. Does anyone else have a similar

Re: [GENERAL] migrating from MSSQL

2009-05-08 Thread Simon Riggs
On Fri, 2009-05-08 at 00:08 -0700, Eugene . wrote: Secondly, which commercial support vendor would you recommend? I found EnterpriseDB and CommandPrompt, but I don't know anything about them. Any other candidates? Those two companies operate mostly in US. There are various other companies in

Re: [GENERAL] migrating from MSSQL

2009-05-08 Thread johnf
On Friday 08 May 2009 12:08:44 am Eugene . wrote: Hi all, I've been tasked with evaluating the feasibility of migrating our in-house application from MSSQL to PostgreSQL. It is fairly old and has lots of stored procedures, which is why we need to think carefully before making the switch.

Re: [GENERAL] migrating from MSSQL

2009-05-08 Thread Bill Moran
In response to johnf jfabi...@yolo.com: On Friday 08 May 2009 12:08:44 am Eugene . wrote: Hi all, I've been tasked with evaluating the feasibility of migrating our in-house application from MSSQL to PostgreSQL. It is fairly old and has lots of stored procedures, which is why we need to

Re: [GENERAL] migrating from MSSQL

2009-05-08 Thread Joshua D. Drake
On Fri, 2009-05-08 at 10:11 +0200, Magnus Hagander wrote: Eugene . wrote: Secondly, which commercial support vendor would you recommend? I found EnterpriseDB and CommandPrompt, but I don't know anything about them. Any other candidates? As a person from Command Prompt :) we do have

Re: [GENERAL] migrating from MSSQL

2009-05-08 Thread Dave Page
On Fri, May 8, 2009 at 3:48 PM, Joshua D. Drake j...@commandprompt.com wrote: On Fri, 2009-05-08 at 10:11 +0200, Magnus Hagander wrote: Eugene . wrote: Secondly, which commercial support vendor would you recommend? I found EnterpriseDB and CommandPrompt, but I don't know anything about

Re: [GENERAL] migrating from MSSQL

2009-05-08 Thread David Fetter
On Fri, May 08, 2009 at 12:21:51AM -0700, Eugene . wrote: Hi all, I've been tasked with evaluating the feasibility of migrating our in-house application from MSSQL to PostgreSQL. It is fairly old and has lots of stored procedures, which is why we need to think carefully before making the