469,645 Members | 1,551 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,645 developers. It's quick & easy.

Migrating from SQL Server to Postgres

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
Jul 19 '05 #1
0 2590

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Bernardo Robelo | last post: by
1 post views Thread by pgmoscatt | last post: by
9 posts views Thread by Sean Shanny | last post: by
1 post views Thread by Janez Kostanj¹ek | last post: by
4 posts views Thread by Kaloyan Iliev Iliev | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.