good day!
im working on a migration tool for mysql to mssql.
is there any references or codes that you guys can share to me to create databases and
transfer data from mysql to mssql?
ive just got this idea of using dump mysql files since they also have sql commands there
thanks in advace :D
mysql has an export utility program (mysqldump.exe).
mssql has an import utility program.
No need to write a program.
i need a program for it because my client demands for such utility. it is a requirement. thanks for sharing your info anyway :)
You could do it by writing a program to sequentially read all the rows in each of the tables in mysql databse and write them to a text file in any format you wish, most likely a common csv format. I would make things easier if you wrote each table's data into it's own text file. Then write another program to read that file and insert the data into mssql tables.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.