From: | Bill Moran <wmoran(at)potentialtech(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: migrating from MSSQL |
Date: | 2009-05-08 13:48:49 |
Message-ID: | 20090508094849.893a27ac.wmoran@potentialtech.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
In response to johnf <jfabiani(at)yolo(dot)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 think carefully before making
> > the switch. Does anyone else have a similar experience? What are some of
> > the things to watch out for?
> >
> > Secondly, which commercial support vendor would you recommend? I found
> > EnterpriseDB and CommandPrompt, but I don't know anything about them. Any
> > other candidates?
I took a project to do this under contract a few years ago. Quite
frankly, it was an interesting and trouble-free project. Any
competent programmer should be able to handle it for you. The cost
involved is going to depend on the amount of procedures to convert.
Of course, I did it all by hand. If someone out there has a program
to convert, it would probably reduce the cost. But I also had the
ability to optimize some of the SPs as I converted them.
--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/
From | Date | Subject | |
---|---|---|---|
Next Message | A. Kretschmer | 2009-05-08 13:59:54 | Re: Remote access |
Previous Message | George Weaver | 2009-05-08 13:38:33 | Remote access |