Re: Dbf - mysql - sql server
more with arrows ::
------------------
SQL SERVER -> DBF <-> MYSQL
support with explanations aboved. Hope there's another solution :(
Re: Dbf - mysql - sql server
Re: Dbf - mysql - sql server
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?
Re: Dbf - mysql - sql server
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,
Re: Dbf - mysql - sql server
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.
Re: Dbf - mysql - sql server
Quote:
Originally Posted by
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.
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.
Re: Dbf - mysql - sql server
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