Hi guys,
I am given a task of developing a tool for migrating data from MSSQL 2000 do MySQL database.
My clients runs a third party software which stores data in MSSQL 2000. The application is desktop software that stores data in local MSSQL Server.
My Application is in web. We store data on online servers. Now my task is to write a tools so that my client will be able to transfer the data to the online server easily.
Assumption My client do not have much computer knowledge
I am planning for following 2 easy steps for my client :
1.) Generate DUMP file using an export tool which will read data from MSSQL Server and dump it to a csv file.
2.) Login to admin section of website.
3.) Upload and import the data from csv file.
Now my confusions are:
1.) is csv format ok?
2.) is there any other methods or formats with better performance?