.net framework data provider for mysql download

.NET FRAMEWORK DATA PROVIDER FOR MYSQL DOWNLOAD HOW TO
.NET FRAMEWORK DATA PROVIDER FOR MYSQL DOWNLOAD CODE

Fire up the 64-bit Import/Export Wizard from your start menu, not from within SSMS 2012 which will launch the 32-bit version.At least I was able to get something working even if it was only an empty database in SQL Server that looked like the database in MySQL. I then manually fixed up the file in a text editor to run against SQL Server. I finally asked for the MySQL DBA to run mysqldump to only generate the schema, and not the data.

.NET FRAMEWORK DATA PROVIDER FOR MYSQL DOWNLOAD CODE

He did, but the SQL code generated did not parse against SQL Server.

I asked the MySQL DBA to re-run mysqldump providing the option вЂ“comptible=mssql to generate SQL code that can be run against SQL Server.

.NET FRAMEWORK DATA PROVIDER FOR MYSQL DOWNLOAD HOW TO

Hit up Bing for some leads on how to get the two platforms to work together using mysqldump as the linchpin while staring down the prospect of using PowerShell to programmatically fixing up a 15GB text file to make the SQL contents run against SQL Server.Unfortunately mysqldump generates SQL consistent with the MySQL SQL-dialect which happens to be incompatible with the SQL Server SQL-dialect. The MySQL DBA I was partnering with used mysqldump to generate a 15GB ANSI text file containing the schema statements necessary to build the tables in the database as well as the INSERT statements necessary to load those tables.Judging by the number of posts on the internet of people asking for help on this topic I know I am not the only one to have myВ hopes dashed.В To be fair, I did need to pull 14GB of data from MySQL into SQL Server, not the typical chore, but who cares, right? 14GB or 14KB, this should have been aВ simple issue of gaining connectivity and fixing myself a cup of coffee to sip while the servers did all the workвЂ¦not so fast. With SSIS, MicrosoftвЂ™s integration tool shipped with their flagship data platform, I should be able to easily manage connecting to MySQL, which according to their website isВ вЂњthe worldвЂ™s most popular open source database вЂњ, and pull data into SQL Server. I started with a giant assumption that I think many may have in the past: Let me start by saying this did not turn out to be as easy as I originally thought.

.net framework data provider for mysql download