Dbf - mysql - sql server

[sh4rp]

Hi All
first of all, thanks for your caring to see this thread
what i'm about to ask - focusing on best solution to my problems here hoping somebody here, can help me out, finding the best solution.

------------------------------------
PROBLEMS::
-----------

+ i've got 1 ( one ) database type DBF in its own PC act as server - with running FoxPro application using it <- i'm not the programmer of this software <- its running well <- i can access it
+ i've got 1 ( one ) database SQL Server in its own PC act as server - with running VB.NET application using it <- i'm not the programmer of this software <- its running well <- i can access it

MY PART ::
-----------
+ my application will handle the online transactions and like to use MySQL 5.x - with PHP ( unfortunately, forcing me to use data from DBF and SQL Server )
I can't use just the SQL Server data, because large amount of data handle in DBF, and i can't use just DBF, because some critical informations puts in SQL Server - that's the conditions.

MY TEMPORARY SOLUTION ( really hope so ... )
------------------------------------------
+ creating small application with VB6 ( with purpose ) get data from SQL Server and transfer it to DBF - where DBF User ( user of the fox pro application ) completing all the informations -> after they complete all the informations -> VB6 Application will grab DBF data and transfer it to MySQL ( with different db structure - need to get adjusted first - per record ) -> then, i can use that data ( in MYSQL ) for PHP application -> and then, the user of PHP application do what they need to do with all of that informations -> VB6 application grab MySQL data and doing update , insert record to DBF. ( yeah .... hope u know what i mean )

QUESTION ::
-------------
anybody ... is there any good solution beside what i'm going to do above ?

-----------------------------
Thank u so much for ur caring,
My Best Regards,

[sh4rp]

more with arrows ::
------------------

SQL SERVER -> DBF <-> MYSQL

support with explanations aboved. Hope there's another solution

[sh4rp]

is there anyone here ?

[smendoza]

So how does the Foxpro data and the MSSQL data relate? It sounds like there are two separate applications running? You need to get data from both Databases for your application that you're building?

[sh4rp]

hi @smendoza

yes, there ais 2 applications running, one with DBF backend, and the other with sql server ( not my software ). application that using sql server run in other departement that create general informations and create_code for student record, where the DBF application filling out student details. In reality, the user of application that using sql server got to do twice data entry for student ( first in their sql server application, then to application that using DBF ) this kind of system is confusing, but that's the fact, if only the DBF application can produce create_code for student record, i'll not need to think about sql server application, so actually, their relation just with master student database table, nothing else. what i'm thinking now, is what i posted above.

they need an online application - as support system ( i'm using php and mysql ), unfortunately, all final detail informations that exist in mysql, must exist too in DBF. and my application gonna need detail informations that exist in DBF. And they also request, to eliminate the need of sql server application user, to re-entry student record in DBF application, that's where my small application created in VB6 do in background, to queries and transfered data from sql server to dbf, get data from dbf into mysql, and transfer from mysql to dbf,,,behhh ...

kinda lame to ask this, but, is there any shortcut solution for my problem here against what i'm thinking now ??

best regard,

[smendoza]

Sounds like you will need to sync the data with mysql and foxpro in both directions. If someone updates a record foxpro Im guessing you'll need to make sure the mysql data is updated as well.

[sh4rp]

Sounds like you will need to sync the data with mysql and foxpro in both directions. If someone updates a record foxpro Im guessing you'll need to make sure the mysql data is updated as well.

yes and this is done by scheduled, not in working time, i'll just make sure that there's no user using the application that using dbf while i'm doing it.

[techgnome]

If it were up to me... I'd skip mySQL and PHP ... use ASP.NET and datasets ... load data from SQL Server, load data from the DBF... process... and save back to the DBF ...
I think trying to add yet another database to the mix would only create more problems than it would solve.

-tg