By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,779 Members | 1,275 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,779 IT Pros & Developers. It's quick & easy.

Migrating from SQL Server to Postgres

P: n/a
I am trying to migrate from SQL Server on windows NT to a Linux server
running Postgres. The table definitions are no problem and the data
migrates well using bcp and COPY. The problem is that most of the
functionality of the client programs were built into stored procedures.
This worked well in that any change of policy or functionality was
propagated immediatly and didn't require update of the clients.

My problem is how to replicate stored procedures. Functions don't work
since I need to return result sets and not single values. Using views, I
can achieve some of the results, however the more involved procedures return
results based on queries (or subqueries).

Review of the documents on postgres.org and google searches don't really
provide any solutions.
Does anyone have any ideas how I might approach this problem?

Thanks in advance.

Al Rosenthal
ar********@AtlantaHand.com
Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.