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 12 of 12   
 

MySQL Error Handling using the Signal and Resignal Statements

MySQL introduced the SIGNAL and RESIGNAL statements in version 5.5 to allow you to raise your own error conditions from stored procedures, triggers, and events. Rob Gravelle demonstrates how to utilize both.  Read more...
By Additional Articles 2015/08/17 | Source: Database Journal | Category: mysql
Rating: (not yet rated)  Rate this |   Briefcase | 1,495 reads

Integration Services, MySql and SET FMTONLY ON

Challenges with integrating MySQL data in an ETL regime and the Amazing FMTONLY trick!  Read more...
By Gerald Britton 2015/06/25 | Source: SQLServerCentral.com | Category: integration services
Rating: |  Discuss |   Briefcase | 2,936 reads

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: SQLServerCentral.com | Category: linked server
Rating: |  Discuss |   Briefcase | 3,047 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: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,863 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: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,064 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: SQLServerCentral.com | Category: mysql
Rating: |  Discuss |   Briefcase | 3,014 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: MSSQLTips.com | Category: mysql
Rating: (not yet rated)  Rate this |   Briefcase | 3,118 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: SQLServerCentral.com | Category: mysql
Rating: |  Discuss |   Briefcase | 5,728 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: MSSQLTips.com | Category: sql server
Rating:  Rate this |   Briefcase | 8,844 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: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 153 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: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 176 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,400 reads
   Items 1 to 12 of 12   
 
Tags
editorial (2)    
t-sql (2)    
database weekly (1)    
error handling (1)    
export (1)    
fmtonly (1)    
integration services (1)    
linked (1)    
linked server (1)    
migration (1)    
oracle (1)    
resignal (1)    
server (1)    
signal (1)    
sql dialects (1)    
sql server (1)    
sqlservercentral (1)    
stairway series (1)    
syntax (1)