MySQL HELL on RedHat Linux 7.2
-
Hello, the CPians around the world.;) One time, I try to export some sql statement generated by SQL Server to MySQL on RedHat Linux 7.2 However, I got a bunch of error messages from MySQL Server. I found that some syntax of SQL statement generated by SQL Server would be not supported by MySQL. First time, I try to delete [dbo] from SQL file, but I notice that some value type will not be supported by MySQL. Does anyone know any tools to overcome this kind of HELL? X| Thank you in advance. -Masaaki Onishi (eCoolSoft)- ASP.NET Web and Windows Application Development by C# and MFC. eCoolWebPanelBar(BETA) is availabe now. http://www.ecoolsoft.com
-
Hello, the CPians around the world.;) One time, I try to export some sql statement generated by SQL Server to MySQL on RedHat Linux 7.2 However, I got a bunch of error messages from MySQL Server. I found that some syntax of SQL statement generated by SQL Server would be not supported by MySQL. First time, I try to delete [dbo] from SQL file, but I notice that some value type will not be supported by MySQL. Does anyone know any tools to overcome this kind of HELL? X| Thank you in advance. -Masaaki Onishi (eCoolSoft)- ASP.NET Web and Windows Application Development by C# and MFC. eCoolWebPanelBar(BETA) is availabe now. http://www.ecoolsoft.com
Everyone has their own SQL syntax... You might want to try PostgreSQL[.org] instead. You can use it as a back-end to MS Access, so it should be more compaitble than MySQL. If you're using SQL server, PostgreSQL is a better match for you anyway. (And no, I know of no tools)
-
Everyone has their own SQL syntax... You might want to try PostgreSQL[.org] instead. You can use it as a back-end to MS Access, so it should be more compaitble than MySQL. If you're using SQL server, PostgreSQL is a better match for you anyway. (And no, I know of no tools)
No thanks, postgresql spammer. Get a real database.
-
No thanks, postgresql spammer. Get a real database.
Indeed I am a PostgreSQL 'spammer'. I do this because when people think open source database they think MySQL is the flag ship. Indeed it is not. PostgreSQL can compete with Oracle on Features while having respectible speed. It's just the most popular because it's always been an easy install under most platforms. Am I to assume going to assume you prefer the worm-ridden MS SQL server? I think it might be good to mention now that I also think Oracle is good as well, but since this guy was using a MySQL database, it'd be a good assumption he want to stay cheap and free. What do you suggest is a 'real' database?
-
Indeed I am a PostgreSQL 'spammer'. I do this because when people think open source database they think MySQL is the flag ship. Indeed it is not. PostgreSQL can compete with Oracle on Features while having respectible speed. It's just the most popular because it's always been an easy install under most platforms. Am I to assume going to assume you prefer the worm-ridden MS SQL server? I think it might be good to mention now that I also think Oracle is good as well, but since this guy was using a MySQL database, it'd be a good assumption he want to stay cheap and free. What do you suggest is a 'real' database?
Scorp1us wrote: What do you suggest is a 'real' database? Indexed cards and a filing cabinet? Sorry... :-O
David Wulff