SQL Plus (oracle) and SQL (mysql)
Hello, I have two servers: one is oracle database and another one is mysql database. We developed two web application using cold fusion running on each one Server 1: oracle database with cold fusion application server 2: mysql database with cold fusion application My question is if we decide to switch server 1 to server 2 (oracle database to mysql) or server 2 to server1 (mysql to oracle). Then, what happen to sqlplus (oracle) and sql (mysql) using with application. You can say what are # between sqlplus (oracle) and sql (mysql) Thank you so much, DT __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SQL Plus (oracle) and SQL (mysql)
On Monday 31 July 2006 06:26 am, Phong Nguyen wrote: My question is if we decide to switch server 1 to server 2 (oracle database to mysql) or server 2 to server1 (mysql to oracle). Then, what happen to sqlplus (oracle) and sql (mysql) using with application. You can say what are # between sqlplus (oracle) and sql (mysql) If you change servers it should be as simple as changing connection strings (ie. what host). Not sure if that quite answers your question. -- Chris White PHP Programmer/DBranded Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SQL Plus (oracle) and SQL (mysql)
On Mon, 31 Jul 2006 06:26:01 -0700 (PDT) Phong Nguyen [EMAIL PROTECTED] wrote: My question is if we decide to switch server 1 to server 2 (oracle database to mysql) or server 2 to server1 (mysql to oracle). Then, what happen to sqlplus (oracle) and sql (mysql) using with application. You can say what are # between sqlplus (oracle) and sql (mysql) Well, sqlplus is just an Oracle client program that lets you run SQL queries against the Oracle db. I think what you are really after is what the differences between Oracle SQL and MySQL SQL are. A couple things come to mind: 1.) For CREATE TABLE, Oracle uses VARCHAR2, MySQL has VARCHAR 2.) For MySQL you need to create your tables as InnoDB tables if you are using transactions or foriegn keys (which I hope you are for a production application) 3.) MySQL does not support Oracle's notion of Sequences - in MySQL you do have AUTO_INCREMENT columns, but they are not as robust as sequences. 4.) MySQL does not support CHECK constraints inside CREATE TABLE clauses. I'm sure there are others, but as long as your application uses pretty generic SQL and you are not getting into Oracle-specific stuff you should be ok. Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]