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 maki

Re: [GENERAL] migrating from MSSQL

2009-05-08 Thread Dave Page
On Fri, May 8, 2009 at 3:48 PM, Joshua D. Drake 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 them. >> > Any ot

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 ha

Re: [GENERAL] migrating from MSSQL

2009-05-08 Thread Bill Moran
In response to 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

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 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

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 t

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 simi

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 experi

[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 some

[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 som