How to create a ODBC Connection to mySQL in Microsoft SQL Server # #mysql #dataanalyst #odbc

This advanced SQL Server video was a request from a member of the ALLJOY community. The ask was to do a video on ODBC connections. To be able to do that, we will install mySQL, create a database, a table, low a few rows and them pull that data from mySQL into SQL Server using ODBC in the Import / Export Wizard.

0:00 Introduction
1:07 Install mySQL
6:13 Set up environment variable
8:40 Create mySQL Database
9:04 Create mySQL Table
9:29 Insert rows into mySQL Table
11:15 Setting up ODBC connector
15:10 SQL Import / Export Wizard
20:20 Show data that was pulled from mySQL into SQL Server

[rsworld]

How do i configure the odbc driver to insert more records in destination. I am using ssis pacakge to load data from sql to mysql which is in different server.

[briandong]

Hi, I am new to MySQL and SQL in general. This only applies for local databases? How does this work with a remote database connection (example: One stored in Europe/Asia while trying to gain access from America)? That is only allowed by the enabling the connecting computer as an Access Host by connecting the IP address?