Subject | Re: [IB-Conversions] re:Fox to Interbase with IBO/IB_WISQL? |
---|---|
Author | Tim Uckun |
Post date | 2000-07-12T02:01:14Z |
At 09:36 AM 7/12/00 +1000, you wrote:
I believe one of the fastest ways to do this is to use access. Here is what
I propose.
1) Import your data into Microsoft access. Access will read and import data
from just about any database known to mankind.
2) Export your data from access to interbase.
Step one is easy! Step two is not too difficult let me explain.
There are already several tools to export access databases to SQL server
(pretty useless for our purposes), postgres, mysql etc. Some of these are
open source. We can take one these and modify it to generate SQL scripts.
Or we can generate SQL scripts and some PERL code so that the database can
be created in any OS. I have already done some (very little so far) work on
this and I think it's very feasible with a weekend of coding. Maybe this
weekend I'll pick up the project again.
----------------------------------------------
Tim Uckun
Mobile Intelligence Unit.
----------------------------------------------
"There are some who call me TIM?"
----------------------------------------------
>OK, here is a proposal:If I may...
>
>Will that do to start with?
>
>Let's get this ball rolling...
I believe one of the fastest ways to do this is to use access. Here is what
I propose.
1) Import your data into Microsoft access. Access will read and import data
from just about any database known to mankind.
2) Export your data from access to interbase.
Step one is easy! Step two is not too difficult let me explain.
There are already several tools to export access databases to SQL server
(pretty useless for our purposes), postgres, mysql etc. Some of these are
open source. We can take one these and modify it to generate SQL scripts.
Or we can generate SQL scripts and some PERL code so that the database can
be created in any OS. I have already done some (very little so far) work on
this and I think it's very feasible with a weekend of coding. Maybe this
weekend I'll pick up the project again.
----------------------------------------------
Tim Uckun
Mobile Intelligence Unit.
----------------------------------------------
"There are some who call me TIM?"
----------------------------------------------