LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > Programming
User Name
Password
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.

Notices


Reply
  Search this Thread
Old 09-29-2005, 01:50 AM   #1
paddyjoy
Member
 
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?

Paddy
 
Old 09-29-2005, 11:42 AM   #2
tekkieman
Member
 
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.
 
  


Reply


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 01:48 AM
Question about GCC linking procedures... vinculum Programming 3 09-26-2005 08:20 AM
Download, extract, and installation procedures MarcusG Slackware 4 02-01-2005 02:54 PM
steps and procedures archangel Linux - General 1 08-07-2004 12:48 AM
Qt and installation procedures? Infamous Tim Linux - Software 4 04-21-2002 02:09 AM

LinuxQuestions.org > Forums > Non-*NIX Forums > Programming

All times are GMT -5. The time now is 08:40 AM.

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