Migration tools/plan from oracle 7.3 to Mysql 4.0

[<lakshmi.narasimharao]

Hi,
         I am new to MySql. Could you please let me know the different migration tools avialable for the migration of oracle 7.3 database to mysql 4.0 classic version. Out of those which one is the best in performance and cost wise. As per my knowledge views, stored procedures and triggers are not supported in MySql 4.0. Is it correct?. If so, what are all the alternatives for converting the views, stored procedures and triggers in oracle 7.3 to MySql 4.0. I will be very happy for  giving me a very good explanation on this.
 
Thanks,
Narasimha
 

	-----Original Message----- 
	From: Bob Afifi [mailto:bobafifi@stripped] 
	Sent: Mon 8/16/2004 10:13 PM 
	To: mysql@stripped 
	Cc: 
	Subject: Update MySQL row using URL link?
	
	

	I currently update MySQL rows using phpMyAdmin.
	For example, dropping the following into the
	phpMyAdmin GUI:
	
	UPDATE mysql_db SET publish = 1 WHERE Date =
	'Sunday, August 15, 2004 21:04:32'
	
	Since I get the update info in an e-mail send
	whenever the form is submitted, I'd like to turn
	querys like the above encoded into a URL -
	bypassing phpMyAdmin - which when clicked, will
	update the row.
	
	I found this article last night: "Make SQL
	Queries over HTTP with XML with VS.NET "
	(http://www.aspfree.com/c/a/ASP/Make-SQL-Queries-over-HTTP-with-XML-with-VSNET/
	)
	
	"SELECT CustomerId, CompanyName FROM Customer"
	
	http://localhost/sql?sql=select%20CustomerId,%20CompanyName%20from%20Customers%20FOR%20XML%20AUTO
	
	=====
	
	The above looks very much like what I have in
	mind, but for MySQL.  Anybody know how to do
	this?
	
	Many thanks in advance,
	
	-Bob
	
	--
	MySQL General Mailing List
	For list archives: http://lists.mysql.com/mysql
	To unsubscribe:    http://lists.mysql.com/mysql?unsub=1mharao@stripped
	
	





Confidentiality Notice 

The information contained in this electronic message and any attachments to this message are intended
for the exclusive use of the addressee(s) and may contain confidential or privileged information. If
you are not the intended recipient, please notify the sender at Wipro or Mailadmin@stripped immediately
and destroy all copies of this message and any attachments.