How to create a ODBC Connection to mySQL in Microsoft SQL Server #
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