Thanks for the info on Navicat, it looks really great, but I'm going to stick with SQL Express for now.
Installing/testing SQL 2008 Express went extremely well. I'll need to get my head around the changes in FULLTEXT. If anyone else is looking at Express, I've blogged the installation notes:- http://fasttrackonline.blogspot.com/2011/05/coldfusion-and-microsot-sql-expr ess-r2.html Enjoy! Jenny Gavin-Wear Fast Track Online Tel: 01262 602013 http://www.fasttrackonline.co.uk/ >>-----Original Message----- >>From: M P [mailto:miketot...@gmail.com] >>Sent: 11 May 2011 19:48 >>To: cf-talk >>Subject: Re: Migrating a DB from MS SQL 2000 into MySQL latest release >> >> >> >>I second the comment on Navicat. It's intuitive and easy to use >>and the new Premium edition supports MS-SQL as well as MySQL, >>Postgre, Oracle and SQLite. And no, I don't have any affiliation >>with them, I just love their product :-) >> >>I've converted several databases from MS-SQL to MySQL with no >>problems whatsoever. I now use Navicat exclusively to manage all >>of my client databases and I haven't even had to install the >>dreaded SQL Enterprise Manager on my new system (which makes me >>extremely happy because I can't stand Enterprise Manager). >> >>For backups or transferring to a new server, I think Navicat is >>MUCH easier and more intuitive than Microsoft's built-in tools. >>Even moving a database from one MS-SQL Server to another is just >>a couple of clicks of the mouse. >> >>With regards to the comment about the type of backup, I actually >>just schedule a nightly sync from my Production DB to a dedicated >>backup version on the Staging Server (or Development Server for >>clients that don't have a staging environment). This way, we >>actually have a LIVE fail over we can bring online almost >>immediately, while we repair or replace the Production server. I >>realize that might not be an option for all situations >>(especially really large DBs), but it's worked extremely well for >>me over the years. >> >>I've never seen a MySQL database get corrupted and I've worked >>with hundreds of them (though granted most of them were fairly small). >> >>Just my 2 cents worth. >> >>-Mike >> >> >>>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:344467 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm