just had a 10lb chunk bit outta my butt

Post #300,950 by boxley 12/10/08 7:33:27 PM Reply	just had a 10lb chunk bit outta my butt my a snippet of sql that returns one thing from mysql (where product was developed) and slightly different from oracle (where it is deployed) is there a master list of such things that I can see if there is more of this? thanx, bill
Post #300,951 by static 12/10/08 7:51:08 PM Reply	Dunno about a master list. But you could try <a href="http://troels.arvin.dk/db/rdbms/">this</a> for a starting point. Developing and deploying against different database products is hugely crazy, IMO. Wade.
Post #300,955 by boxley 12/10/08 10:16:24 PM Reply	not quite that bad originsl developed on mysql ported by request by original developers to oracle, still a mistake unless development is simultaneous in all target rdbms's used to do that back in the day
Post #300,957 by a6l6e6x 12/10/08 10:55:53 PM Reply	Tis too! I worked on a project that ran with SQL Server. It's behavior, i.e. what it returned to a query, changed in subtle ways because of some parameter change the DBA made that did not change the tables in any way. Broke the system until resolved! Granted this was SQL Server, but it's tough enough to deal with the idiosyncrasies of one database. And they all have their idiosyncrasies! Alex
Post #300,952 by Another Scott 12/10/08 8:02:42 PM Reply	:-( It sounds like that old LRPDism about RedBrick. :-( I can't offer any specific knowledge. I assume you know about Oracle's Migration Workbench: http://www.oracle.co...kbench/index.html The tool apparently knows about MySQL 3, 4 and 5.0: http://www.oracle.co...ntofdirection.htm Good luck! Cheers, Scott.
Post #300,956 by boxley 12/10/08 10:16:50 PM Reply	thanx, looks promising

Welcome to IWETHEY!