- Sri
William M.Conlon wrote:
If cost is not an issue, Oracle sure looks great (but I would read the fine print on the license).
Though I use MySQL, many in the open source community are a little peeved about changes being made to the MySQL license. Instead, take a look at Postgre SQL, which may already have most of the features you would be waiting for, and which is open source.
Regarding migration, MySQL has a couple of quirks:
Timestamp columns: the first timestamp column in a table gets auto updated, no matter what.
If you have one varchar in a table, all character types become varchar.
On Wednesday, August 11, 2004, at 03:09 PM, Wilcox, Jamileh (HSC) wrote:
We run all of our databases on MS-SQL2000 or MS Access. (I've been slowly working towards moving all the Access databases to SQL.)
We're considering changing database servers. Under discussion so far are Oracle and MySQL. The campus has a site license for Oracle, so purchase cost isn't much of a factor. I've been researching MySQL and it looks a bit limited (no stored procs yet, no scheduler/jobs/etc.), but the new version due out next year has a several of those features added (although I'm not sure *when* in 2005 it'll be available).
How difficult is it to switch to MySQL or Oracle from MS-SQL? I realize there will be some conversion issues in any db migration (i.e., SQL language variations, datatype variations, etc.), but there appear to be tools available to assist with that. I'm mostly concerned about the learning curve and how long it would take to come up to speed on a new db.
Does anyone have experience with such a migration, or experience with using more than one of these dbs? Any info or advice would be most appreciated!
Thanks.
jamileh
-- ****************** Internet Email Confidentiality ***********************
Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Maxys Corporation or its affiliates shall be understood as neither given nor endorsed by it. **************************************************************************
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
