Re: SQL Server to MySql

[Dinangkur Kundu]

Hi,

As I've similar problem but approach is different. I just need to know how i can complete the process, technical thingy i can handle. I've a software in remote site with VB6 and SQL server 2000. They have internet connection but it's expensive(Bangladesh), so they use dial-up to send e-mails from there. But the owner of the factory lives in Canada. He wants me to create a dynamic webpage which will contain same database and php will help to generate reports from online mysql. So, he will be able to see reports everyday. Now site PC will go online after 10 pm and update new data to online mysql sever. How can I do that.

If I dump all entered data for everyday in ascii file in a csv format and then send the csv to web server through ftp, after transfer the file. From website owner will click a button which will contain a function to import data from that csv file to mysql server.

Is there any good option, please help.

-Dinangkur Kundu
IT Service Developer