SuperSite Blog

Just FYI:  SQL Server 2005 SP2 support is ending.

This post was mentioned on Twitter by gretchenglas: Microsoft Announces SQL Server Migration Assistant for MySQL: Some interesting new from Microsoft, for those th.. http://bit.ly/4Mx1R5

I am thinking those that chose MySQL did so on the cheap.  A migration tool is not going to fill their pockets full of money they want to spend on MS SQL.

Pingback from  Twitter Trackbacks for                 Microsoft Announces SQL Server Migration Assistant for MySQL - SuperSite Blog         [winsupersite.com]        on Topsy.com

Pingback from  Microsoft Announces SQL Server Migration Assistant for MySQL …

>> I am thinking those that chose MySQL did so on the cheap.  A migration tool is not going to fill their pockets full of money they want to spend on MS SQL.

Only if they buy a professional-level SQL Server. If they use SQL Server Express, it, too, is free, correct?

"Only if they buy a professional-level SQL Server. If they use SQL Server Express, it, too, is free, correct?"

Yes, but it's not something you want to rely on in a production environment for multiple clients.  SQL Express is for integration into an application where Compact Edition doesn't meet the needs of the app.  In an enterprise, you'd want to have synchronous and/or failover redundancy.  Small businesses can get SQL Server 2008 Standard in SBS Premium though, and it certainly doesn't cost that much to add it to SBS when you look at the TCO in the IT investment.  SQL Server can run multiple databases though.  I have a client that runs their LOB app (a complicated business process management app), security monitoring and data collection, and customer database all from the same server.

@Waethorn -

Not starting an argument here. If you don't / can't run production environments for multiple clients on SQL Server Express, why would you want to do it with MySQL? I hear what you're saying, but I thought MySQL and SQL Server Express were equivalent, in terms of enterprise-ability? Or is that mistaken on my end?

They are not equal.  My SQL community server is equal to MS SQL standard version.

SQL express is for turn key applications that need a database on the same machine as the application is running on.  Express is limited to 1 CPU socket (quad core) 1gig of RAM and 4gig databases.

"I thought MySQL and SQL Server Express were equivalent, in terms of enterprise-ability? Or is that mistaken on my end?"

SQL Server Express isn't designed for enterprise applications.  MySQL could work, if you have a very good system architect at work, but the free version of MySQL was never designed for enterprise-level production environments.  If you want enterprise class support for MySQL, you end up buying the enterprise edition of it, along with a support contract.  Prices start at $600US, but can go up to $5000.  That's PER YEAR though.

In either case though, there are basic versions for free, and there are enterprise versions for a lot of money.  Nobody in their right mind would try and use a mismatched version for their environment though, and certainly, any business with a competent IT department won't be running their business-critical apps on a piece of freeware.

@rrode:

That is not correct.

MySQL Community fits between SQL Server Express and Web, but unlike Web, it doesn't get anything beyond community support.

Remember that MySQL Community, like SQL Server Express, is designed for beginner developers for mostly just educational and personal use.  Real developers that have business-critical web or desktop apps that generate revenue, will never utilize those platforms.

Microsoft has a nifty installer here that can get you started on web development.  SQL Server Express 2008 is provided for starter development.  If you web apps are business-critical, the target migration path is to use a web host that offers hosted SQL Server 2008 database offerings.

http://www.microsoft.com/web/

In fact, you can download a PHP driver for IIS and integrate SQL+PHP web applications using only Microsoft technologies.

@Waethorn - Much thanks. And, I agree - if you have a need to migrate from SQL Server Express / MySQL to SQL Server 2008  (an enterprise SKU), you need to do more work than just run a wizard, if you want to do it right (scaling it right, mirroring, etc..).

Fluent.NET 1.0 liberado : Si os gusta el tema de fluent interfaces , este es un más que decente framework

Pingback from  Microsoft Announces SQL Server Migration Assistant for MySQL … «  ???????????????????????????????????????