Converting Your SQL Server Database to MySQL

I’ve been trying to convert a SQL Server 2000 database to MySQL, because I’ve grown to like MySQL, and find it easier to manage (using Navicat).

After trying DTS, Navicat’s import features, and a slew of conversion products, I’ve settled on a product I stumbled upon last night.

http://dbconvert.com/

I must say, this is one of the slickest programs I’ve ever used. It just flat-out works.

A problem you’ll find with some of these converters is, they will not define your foreign keys. Ugh! I don’t wanna have to manually define those again! I have 75 tables in this database. DBConvert to the rescue. It seems to define my PK’s, FK’s, and indexes properly – Nice!

It even displays errors and potential problems with your table objects.

The only problem I’ve had is the data itself. DBConvert seems to get “bogged down” when it’s trying to insert a lot of data into my tables. I’m having to manually convert the data using the program’s filter options. It definitely goes a lot faster.I’m simply copying over the data, and unchecking the “copy structure” checkbox. Then you click the Filter button, and manually define what you want. It’s pretty easy.

Adding the data

Enjoy!

Congrats to Brian Fitzgerald!

I’d like to congratulate my good friend, Brian Fitzgerald, on his addition to the Mach-II team!

I can tell you, Brian has a passion for ColdFusion and frameworks like you’ve never seen. He’s a great guy and is always excited to help me learn what he knows.

Congrats Brian!  You rock dude!

O’Reilly – A Great Online Book/Video Service

A friend at work pointed me to a resource I’ve never seen – O’Reilly – Safari Books Online.

I signed up for the $42.99/month plan a few weeks ago, and must say I love this service! It house all the books and videos you’ll probably ever need.

I’ve been perusing all the Java content myself, and I’ve gotta say, there’s so much there, it’s WELL worth the $. I don’t think you can beat it.

The only thing I don’t like is the online reading thing. See, I don’t like reading on my computer. It gets old quick!

But overall, I like it and probably will continue using it.

You can signup for a free trial here

Do You Have Enthusiastic Clients Like This?

I don’t have a truckload of clients, but the ones I DO have sure are enthusiastic, and that’s what I like!

Wanna Load Test? Here’s How….

I’ve never felt the need to load test any of my apps, because I never felt like they’d receive enough traffic to make a difference in performance.

Uhhhhhhhhhhhhhhhhh…..

uhhhhhhhh…… I just noticed Obama’s site is uhhhhhhhhhhh….. PHP.  That uhhhhhhhh… doesn’t uhhhhhhhh surprise me. You can just watch the embarrassingly sad video below and tell uhhhhhhhh…. the guy doesn’t have much sense without a teleprompter. Bush uhhhhhhhh…. runs circles around the guy.

BTW, you ever notice when the guy stumbles, everybody makes excuses like this: “He hasn’t had much sleep”.

Huh? Bush never got that kind of treatment. Oh, I forgot, he isn’t a Democrat.

Please be warned, this video is pretty embarrassing. 

A Newly-Named Asteroid Called Vista??

In keeping with my monthly routine, I must write yet another entry about Vista.

If scientists discover a new asteroid, 1,000 miles in circumference, composed completely of space garbage, I think they should name it Vista.

That’s it…

Java, Here I Come!

Me and my buddy Brian at work here have decided to pick up another language. After much discussion of the crappiest, most-Vista’ish (This technique stolen from Ray Camden) languages/platforms that ever existed, we decided to go with Java instead.

To get started, you’ll need the JDK, which can be downloaded here.

I also downloaded Netbeans IDE and a bunch of tools that don’t mean much to me at the present time.

ColdFusion 8 Certification Exam – The Verdict

Yes, I’ve read Ray’s blog and related comments on the certification process. And yes, there’s a lot of controversy swirling around Adobe’s Certification exams at the present, but I really have no choice on whether to take it or not, as the company I work for likes having certified developers on staff.

I Listen to beatlesradio.com

If you’re like me, you have to listen to music while you code. I dunno … there’s just something about it that’s soothing. It’s almost the same as drinking 3 long islands, then coding ( I can build some wild shit after a few). Maybe we’ll talk about that one in another entry.