Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Content with tag MySQL Rss

   Items 1 to 10 of 10   

Linked server creation to MySQL Server

Here is a step by step procedure to create a linked server to MySQL from SQL Server.  Read more...
By Vinayaka Gangadhar 2014/10/13 | Source: | Category: linked server
Rating: |  Discuss |   Briefcase | 2,979 reads

Stairway to SQL Dialects Level 3: MySQL

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.  Read more...
By Joe Celko 2012/12/05 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,770 reads

10 tips on converting MS SQL queries to MySQL

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.   Read more...
By Oleg Fedorov 2012/06/01 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,047 reads

20 tips on converting MySQL views to MS SQL

This article gives 20 tips how to modify MySQL views to make it compatible with Microsoft SQL Server.   Read more...
By Andrew Kuprianov 2012/05/02 | Source: | Category: mysql
Rating: |  Discuss |   Briefcase | 3,002 reads

Export data from MySQL to SQL Server

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.  Read more...
By Additional Articles 2012/04/20 | Source: | Category: mysql
Rating: (not yet rated)  Rate this |   Briefcase | 2,991 reads

Linked server to MySQL Server.

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.   Read more...
By Daniel Calbimonte 2012/04/17 | Source: | Category: mysql
Rating: |  Discuss |   Briefcase | 5,633 reads

Microsoft SQL Server vs. MySQL

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?  Read more...
By Additional Articles 2010/01/29 | Source: | Category: sql server
Rating:  Rate this |   Briefcase | 8,776 reads

Did Oracle buy MySQL by accident?

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?  Read more...
By Tony Davis 2009/08/17 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 152 reads

Guest editorial: Reasons to be Cheerful

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.  Read more...
By Tony Davis 2009/02/04 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 173 reads

MySQL Primer for the SQL Sever DBA

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.  Read more...
By Ken Kaufman 2008/08/08 | Category: mysql
Rating: |  Discuss |   Briefcase | 7,368 reads
   Items 1 to 10 of 10   
editorial (2)    
t-sql (2)    
database weekly (1)    
export (1)    
linked (1)    
linked server (1)    
migration (1)    
oracle (1)    
server (1)    
sql dialects (1)    
sql server (1)    
sqlservercentral (1)    
stairway series (1)    
syntax (1)