Hi Wes,

I have done a paradox version a couple of times. My first approach was to
create a conversion application which reads the structure of the tables and
create a SQL script to create all the tables (a quick and dirty approach).

The second time I did it (I'm currently doing it now the second time for
another customer), I created each table manually as I needed them in the
application (a set of Delphi apps). As I did it the second time, I change
the structure as I need it. Be warned it is a little more to consider some
times because of dependencies to change the structure of tables after they
are created with firebird than it is with paradox. I am going to end up
with less work in the end. I have learned the hard way that the quick and
dirty approach with a mop later, often leaves a looong and drawn out mop up.
Although I haven't finished doing it this second time, I can see already a
much better end result shaping up.

Also do move everything in your paradox application to client server
approach from the start, e.g. use queries instead of tables and use stored
procedures wherever possible and don't maintain balances via code if these
are the same as sum up tables. And don't attempt to mimic pessimistic
locking. If you change your thinking you don't need to use pessimistic
locking.


I can talk more if you would like me to.

Regards,
Kevin.
-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]On Behalf Of Wes
Sent: Thursday, 2 June 2005 12:09 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Import into Firebird from Paradox Tables


Hello,

I'm new to Firebird and I would like to import data into Firebird from
Paradox. I realize that some fields might have to change in order to
import the data, however, I'm wondering if there are any utilities
that will automatically create the tables in Firebird using the
Paradox tables. Should I just manually create the table structures in
Firebird, then write an app that imports the data myself? Just trying
to do this as easily as possibe. I know once I get the data into
Firebird, I will have to re-think how some tables are constructed, but
I thought it would be a first step asking the experts what they think
about this.

Thanks,

Wes






++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++




----------------------------------------------------------------------------
--
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]