Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: 05 October 2004 16:03 > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: Migrating from Oracle to mySql [online stats] > > > Hi, > I am also doing migration from oracle 7.3 to mysql 4.0 classic. > > May i know how to handle Oracle Views, stored procedures/triggers in MySQL > 4.0 ?. If I remember correctly Views don't appear till 8.0 so why do you need them? Any way the specific answer to your question is "you can't". Views and stored procedures aren't handled by MySQl till 5.x - see earlier thread. > May i know how to create database, table space, roll back segments, users, > allocating tables to table spaces (as we do in oracle) in mysql 4.0 with > out innodb?. > Your best bet is 1) Read the MySQL manual and understand what it does do and what it doesn't 2) Get a copy of MySQLCC and install this on your PC. 3) Use MySQLCC to create the database and modify your Oracle scripts to create the tables. As there and no transactions without innodb you don't need to worry about rollback segments etc. > Can we write into multiple tables in mysql 4.0?. If so how?. What do you mean? > I have a backup to my database, after that i added some new columns to > some tables and created one more new table. Now, i want to restore the old > data without distrubing the new changes. Could you please help me how to > do this in mysql?. Depends what format your data is stored in. ************************************************************************************** ALCHEMETRICS LIMITED (ALCHEMETRICS) Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX Tel: +44 (0) 118 902 9000 Fax: +44 (0) 118 902 9001 This e-mail is confidential and is intended for the use of the addressee only. If you are not the intended recipient, you are hereby notified that you must not use, copy, disclose, otherwise disseminate or take any action based on this e-mail or any information herein. If you receive this transmission in error, please notify the sender immediately by reply e-mail or by using the contact details above and then delete this e-mail. Please note that e-mail may be susceptible to data corruption, interception and unauthorised amendment. Alchemetrics does not accept any liability for any such corruption, interception, amendment or the consequences thereof. ************************************************************************************** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
