Conduitsoft is looking for assistance/programming in the setup/design of a Off-premise SQL database connection with its own internal VFP database(s)
This program can be performed several ways. We are looking for suggestions and direction.
1. Integrated Remote View (into Remote SQL Database)
2. Individual programs that would read and write appropriate database changes as needed.
3. Nightly Program that would read and write appropriate database changes as needed.
These are only ideas at this point. Idea 1 is the best scenario. That way both systems are updated simultaneously.
We have extensive knoledge in Visual Foxpro 6 but no experience in connecting it to a SQL 2000 Database.
Your job would be to provide a outline/sample program of connectivity from a VFP database (dbc) into a SQL Database, with the ability write reocrds into the SQL Database, read from the SQl Database.
We would like the truest "online" performance as possible. In other words when we create a record in VFP we would liek it be inserted into the SQL database. Then if the records is updated in the SQL database we would like it to update the original record in VFP.......
We will supply test database, tables and some scenarios.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.