Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Non-*NIX Forums > Programming
User Name
Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.


  Search this Thread
Old 09-29-2005, 02:50 AM   #1
Registered: Apr 2005
Location: Sydney
Distribution: FC5
Posts: 174

Rep: Reputation: 30
SQL Stored Procedures

I have spent a lot of time recently working with an application which has about 90% of it's code/buisness logic contained in MS T-SQL stored procedures. This of course makes it a nightmare for porting to any other database system. So my question is if you we're making a database application from scratch what would be the best way to get around this problem so that you could support many different databases, postgres, oracle, db2, mssql etc.. without having to rewrite the stored procedures for each system?

Old 09-29-2005, 12:42 PM   #2
Registered: Dec 2004
Location: Northern CA
Distribution: Mepis 6.5
Posts: 123

Rep: Reputation: 15
If the SQL is not anything too unique, I would say there's nothing wrong with using stored procedures, as long as they are ANSI SQL, and not T-SQL or PL/SQL. Then, they should be usable anywhere.

A second option would be to use a middle tier business object to handle the database access/entry, then all you would need to do is configure the ODBC/JDBC source for the different database engines.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems with multiple procedures jaimese Programming 5 10-28-2005 02:48 AM
Question about GCC linking procedures... vinculum Programming 3 09-26-2005 09:20 AM
Download, extract, and installation procedures MarcusG Slackware 4 02-01-2005 03:54 PM
steps and procedures archangel Linux - General 1 08-07-2004 01:48 AM
Qt and installation procedures? Infamous Tim Linux - Software 4 04-21-2002 03:09 AM > Forums > Non-*NIX Forums > Programming

All times are GMT -5. The time now is 12:54 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration