[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::dbintegrator_public_public

Title:	DB Integrator Public Conference
Notice:	Database Integration - today! Kit/Doc info see note 36
Moderator:	BROKE::ABUGOV

Created:	Mon Sep 21 1992
Last Modified:	Fri Jun 06 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	1171
Total number of notes:	5187

1124.0. "Existing SQL Module Language for MS SQL Server" by ORAREP::NEOV00::KLOPEZ (Ay Caramba!) Fri Feb 07 1997 11:04

     Hello,
    
    Our customer would like to move from Rdb to MS SQL Server. They
    cannot do this on one step, they currently have a lot of programms written
    in C with the SQL module language.
    
    From the SPD:
    
        "The SQL module language processor allows SQL statements and
         multistatement procedures to be grouped into modules" 
    
    Could they use their existing programms to access a SQL Server Database?
    
    Thanks in advance,
    
    Katya

T.R	Title	User	Personal Name	Date	Lines
1124.1	Same code for Oracle?	ORAREP::NEOV00::KLOPEZ	Ay Caramba!	`Fri Feb 07 1997 11:50`	12
	It's me again, I forgot to ask: Could this same programs be used to access an Oracle Database (instead of MS SQL Server) with the DBI GW for Oracle? What we are trying to find out is which database would be easier to move without (mayor) changes in the code the customer has. Thanks, Katya
1124.2	gateway will work	BROKE::SERRA	You got it, we JOIN it....DBI	`Fri Feb 07 1997 14:03`	13
	you can use the rdb transparent gateways to help in a migration scenario. if the apps are high volume, high tps then obviously a gateway in the middle will impact performance. ms sql server or Oracle7, i'll help with that choice. We probably work better with Oracle7. Does anyone think I answer that question differently ! thanks steve
1124.3	Thanks!	ORAREP::NEOV00::KLOPEZ	Ay Caramba!	`Fri Feb 07 1997 17:28`	11
	I agree with you! I think that if we convince the customer that integration would be better with Oracle7 than with MS SQL server I guess the customer will have no choice ... In any case they would need the gateways and they would also need to contact you if they want a try, and you could work for a better integration with DBI GW for Oracle. Regards, Katya
1124.4		ORAREP::HERON::GODFRIND	Oracle Rdb Engineering	`Thu Feb 13 1997 05:32`	5
	Be aware that the SQL module language is also available with oracle7 (called SQL*Module). One customer moved its sqlmod-based application from rdb to oracle with little changes. /albert
1124.5	Why move to Oracle7 rather than MS SQL Server	ataxp1.at.oracle.com::GEDER	Gottfried Eder	`Thu Feb 27 1997 08:20`	12
	Katya, If the customer thinks he must move away from Rdb, Oracle7 is the much safer choice if the application is to be kept unchanged. Two important technical points to scare anyone from moving to MS or Sybase: - Rdb and Oracle7 do row level locking, MS and Sybase don't - Rdb and Oracle7 provide read consistency without locks, MS and Sybase don't This translates to an unpredictible risk of concurrency problems with those products, a risk that doesn't exist with Oracle7! -- Gottfried