Well, it is pretty damn funny. I've migrated from MS SQL to MySql before and it generally isn't too bad. There are various migration tools available, I like the ones from Red Gate. MySql has some funkiness that comes into play if you want to combine foreign keys and full text indexing from what I recall, though that may have gone away in more recent versions. There are also data type differences that you might want to take a look at, like you would think that timestamp (in mysql) would be a datetime type but it isn't, so be sure to read up on them and you should be fine.
If you are still looking at options, you might also want to look at PostGres. PostGres is a solidly enterprise-level db (hot swap backup, all sorts of replication options, partitioning, etc), is free, truly open source and doesn't have the strangeness that comes along with MySql being governed by Oracle. It's good stuff. Cheers, Judah On Mon, May 9, 2011 at 4:12 PM, Gerald Guido <gerald.gu...@gmail.com> wrote: > > > Russ Michaels wrote: >> >> don't forget that MSSQL express is also free and more powerful than mysql > > >>Jordan Michaels <jor...@viviotech.net> wrote: > >> I find the "more powerful" comment humorous. > > This should be fun to watch :) I am making some popcorn. Anyone want some? > > G! > > On Mon, May 9, 2011 at 6:52 PM, Jordan Michaels <jor...@viviotech.net>wrote: > >> >> I find the "more powerful" comment humorous. >> >> SQL Express limits are here: >> http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx >> >> Migration from MS SQL to MySQL documentation is here: >> >> http://dev.mysql.com/doc/migration-toolkit/en/mysql-migration-toolkit-indepth-sourcedb-mssql.html >> >> I've done it several times with no issues. >> >> -Jordan >> >> On 05/09/2011 03:38 PM, Russ Michaels wrote: >> > >> > don't forget that MSSQL express is also free and more powerful than mysql >> > community edition so there is no need to migrate to MySQL unless your >> also >> > moving to Linux. >> > There are however free migration tools on the mysql site that will do it >> for >> > you. >> > >> > On Mon, May 9, 2011 at 11:29 PM, Jenny Gavin-Wear< >> > jenn...@fasttrackonline.co.uk> wrote: >> > >> >> >> >> I'm interested in any info. Pit falls to avoid, best practises, etc. >> >> >> >> Many thanks, >> >> >> >> Jenny >> >> No virus found in this outgoing message. >> >> Checked by AVG - www.avg.com >> >> Version: 9.0.900 / Virus Database: 271.1.1/3625 - Release Date: 05/08/11 >> >> 19:34:00 >> >> >> >> >> >> >> >> >> > >> > >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344373 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
