Windows 10: convert a phpmyadmin mysql database directly to mssql server or access

Hi Microsoft, Do you have any utilities or wizards to convert a mysql database on at / under a phpmyadmin directly to ms sql server or ms access.

:)

 

Switching from mySQL to MSSQL

Hello all,
I a have a dilemma on my hands. MY application uses mySQL, and everything woks great. I planned to list mysql server as a requirement for my application, so that I didn't have to worry about licensing issues with distribution (my app is commercial, not GPL). My app uses libmysql.dll to connect to the mysql database instance, which, come to find out, must be licensed to distribute as well says Oracle.

So:
I planned to switch everything over to MSSQL express, which is totally free to distribute and use in commercial applications. I am used to mySQL server, not MSSQL. Upon installing MSSQL server, I discovered it uses local authentication (Windows username and pass)... Is there a way to set up MSSQL server to function like mySQL server? ex: requiring my connection string to use username, pass, DB name, and table name? The DB is accessed by both my app and an IIS site runnign on the same server.

Does anyone know of any good tutorials or sample walkthroughs of building a vb.net app that connects to and uses MSSQL server?

Thanks so much guys

 

MSSQL Server 2012 to MySQL Linux. Dire performance

I am running MSSQL on server 2012 and I'm trying to do queries against a MySQL database on a Linux box. I'm using MySQL ODBC 5.1 Driver. I have data moving in both directions often based on comparisons (update target from source where filedX <> FieldY
and so on).

My Issue is one of performance. It's rubbish. Basic queries work fine but as soon as I'm doing any bulk data moves (> 10,000 records say) then it becomes simpler to actually copy the data from MySQL to MSSQL, run the comparisons and send back a much reduced
number of rows. This obviously makes for some interesting SQL scripts and a lot of pain!

Am I missing something in terms of tuning the connection or whatever?

Thanks in advance

 

Convert hsql to mysql

dump to csv and import. phpmyadmin is a great tool for managing mysql databases