mdb v.2 to mySQL advice

[RS_Arm]

Hello.

At my job, we have a software app based in Access2 (year 1994).
We are about to implement SugarCRM.

So, here's the deal: we need to import and synchronize data from Access2 to MySQL, (and maybe MySQL to MDB) one time per day. All process must be automatized, so the import options from SugarCRM will not be an option.

The app and SugarCRM are running on a different servers.

As you may imagine, we have more then 15.000 client accounts, more then 100.000 products, etc... .

At the moment we are building an VB app to create text files with the needed data so that, maybe, an php script will import data to SugarCRM database.


Here goes a few questions:

1.Should we import data using an php script? Why/why not?
If not, should we build a solution based on webscripting or applications, like VB, C# or others?

2.If we use a php script (or other webscripting like asp or ruby), what could be the disadvantages?


Thank you.

[HoraShadow]

If you have a copy of SQL Server Enterprise Manager, I would definitely use DTS. You can have it done in a matter of hours.