Hi:

I have a Paradox application with about 200 tables that I would like
to convert into Client/Server architecture.  Is there any way I can do
this in steps.  For example, first, just move the tables into a
database server with minimal code changes.  This would eventually lead
the way to rewriting the front end.  I want to take the first step as
soon as possible due to security issues.

I would welcome any advice!

Thanks in advance.

Hope this gives you a bit of direction...if you need more just ask.

Shaun

Well with that many tables it's going to be a huge job. I moved a big
40,000 record table from Paradox to a Sybase server without too much
trouble. Create your new C/S alias, and depending on the server, you can
use something as simple as Tools|Utilities|Copy to copy the table over,
(or you can write a scan loop, or you can add records in, etc). My Paradox
forms pretty much worked exactly the same, (other than the sybase database
login), as they did with my paradox tables. I did have problems with the
response times for posting a record, (the screen would freeze up after
posting a record, and while the user could type ahead, it was
disconcerting, and broke her concentration, but I digress), the forms
still functioned. I think this may have been due to the fact that I don't
have SQL links, and was using an ODBC connection. I rewrote the forms in
delphi, and this problem went away.

Hope this helps

Brad Miller