General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Hi,
>
>What would I need to setup an application to store data into tables on an SQL server?
>
>I would obviously need a server, Windows 2000/2003, Microsoft SQL? Oracle?, what else?
>
>What would I need on the workstation side?
>
>How would I setup my development system in my office?
>
>I know these sould like silly questions, however, I need to save data to SQL tables and the application currently runs FOX2X tables. All advice is appreciated. Thank you in advance.
Hi Derek,
what you need - first to re-write you FoxPro2.X application, because you have to use T-SQL statements to work with SQLServer or Oracle.
During rewriting you can use different backends, most of them have freeware versions with some limitations.
The best way to do this is to buy newest VFP - 9.0. You can use CursorAdaptor to connect with differnt backends.
Everything depend on how big is application, enviroment in which it works, etc.
In some of our Client-server applications we use distributed DB- part of DB is doubled on the workstation which gives posibility Client to work remotely with/without connection(Internet, LAN, WAn, etc.) to main server for some period of time and after that to replicate data with main server.
Without full description of your project nobody will be able to give you proper advice.
HTH
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only