Paradox Tables to database server move 
Author Message
 Paradox Tables to database server move

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.



Wed, 06 Oct 1999 03:00:00 GMT
 Paradox Tables to database server move

Quote:

> 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.

If you can get hold of the Paradox Client Server tool you can use
DataPump to upsize them to the database (SQL Server, Oracle, Sybase
etc...) and it works quite painlessly.  You can also do this through
FoxPro 3 and v5 if you wish, it has a built in wizard for upsizing.

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

Shaun



Sat, 09 Oct 1999 03:00:00 GMT
 Paradox Tables to database server move

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



Tue, 19 Oct 1999 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Contiuously moving a record to a table in a different database server

2. database:server.table vs database@server:table

3. Batch MOves with Paradox tables

4. Moving Paradox tables with RI

5. Move / Relocate Paradox Tables in Delphi

6. Moving information from Paradox Table to MS Word

7. Moving onto comp.databases.paradox

8. Paradox 9 move data to SQL Server

9. Moving from Paradox 5 to Paradox 8

10. Move Database from Server to Server?

11. moving a SQL Server 2000 database to SQL Server 7

12. Moving two dedicated servers to a single database server


 
Powered by phpBB® Forum Software