472,351 Members | 1,613 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,351 software developers and data experts.

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 2647

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Bernardo Robelo | last post by:
Hi, I am interested in migrating Microsoft Access database to Postgres database. But I do not have idea of like initiating. Maybe some tool...
by: pgmoscatt | last post by:
I have just installed PostGres on to my Mandrake 9.2 system. I installed using the RPMs on the MD install CDs. I notice that when I start the PC...
by: Sean Shanny | last post by:
To all, I restarted postgres this morning to make a configuration file change take effect and when I looked at the serverlog to make sure things...
by: David A. Ulevitch | last post by:
Hi fellow pgsql users, I am helping my university's student union get back up and running after some major server issues they had. They had...
by: Janez Kostanjček | last post by:
Hello everyone, this is my first post to postgres mailing list. System that I use: I am using Postgres under last CygWin published on...
by: Kaloyan Iliev Iliev | last post by:
Dear friends, I have the following problem. libvar=# select version(); version...
by: Collin Peters | last post by:
I have searched the Internet... but haven't found much relating to this. I am wondering on what the best practices are for migrating a...
by: henry62 | last post by:
Hi I'm trying to migrate a universe database to postgres, so far I've exported the tables from universe using uvexport into a comma sep. text file....
by: Teboo | last post by:
Hi, I'm migrating a database into postgres what steps do I need to take? I have installed postgres database. Some Oracle data type is not the...
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.