SQLServerCentral.com Articles tagged MySQL

Stairway to SQL Dialects Level 3: MySQL

Wed, 05 Dec 2012 07:00:00 UT

As part of the LAMP stack, MySQL is incredibly important for providing a reliable and platform-agnostic database platform for web development. This level looks at the syntax of MySQL and how to best port SQL code to a MySQL environment.

10 tips on converting MS SQL queries to MySQL

Fri, 01 Jun 2012 06:00:00 UT

The syntax of SQL queries in MS SQL and MySQL are similar but not identical. This article discovers 10 most popular differences between MS SQL and MySQL syntax.

20 tips on converting MySQL views to MS SQL

Wed, 02 May 2012 06:00:00 UT

This article gives 20 tips how to modify MySQL views to make it compatible with Microsoft SQL Server.

Export data from MySQL to SQL Server

Fri, 20 Apr 2012 06:00:00 UT

Many people want to create a customized migration process using SQL Server Integration Services (SSIS), but it is hard to start working with heterogeneous databases like MySQL, Postgres, DB2, etc. Check out this tip to learn about how to import data from heterogeneous databases like MySQL to SQL Server.

Linked server to MySQL Server.

Tue, 17 Apr 2012 06:00:00 UT

In this article, we are going to create a linked server to the MySQL Database. Once finished that task, we will select, insert, update and delete some data using SQL Server.

Microsoft SQL Server vs. MySQL

Fri, 29 Jan 2010 07:00:00 UT

Is Microsoft SQL Server superior to MySQL or not? What are the pros and cons of using SQL Server over MySQL? Is MySQL mature enough to compete with a big player like Microsoft and Oracle? Can we fairly compare both products?

Did Oracle buy MySQL by accident?

Mon, 17 Aug 2009 06:00:00 UT

The wording of the statement about MySQL that came out from Oracle after the merger was downbeat. The implication was "Oh no! Another Blooming Database to deal with". But surely they don't plan to just let it drift?

Guest editorial: Reasons to be Cheerful

Wed, 04 Feb 2009 07:00:00 UT

The furore surrounding the recent release of MySQL 5.1 makes Tony Davis wonder if more than a few web 2.0 developers might be peering over the SQL Server Express fence and wondering if the grass doesn't look slightly greener over here.

Database source control in just 5 minutes
It takes just 5 minutes to connect your SQL databases to source control. Got 5 minutes to spare? Get started now.

MySQL Primer for the SQL Sever DBA

Fri, 08 Aug 2008 06:00:00 UT

This is an introduction into Mysql for the SQL Server user. It compares the various engines of Mysql and how they compare to SQL Server.