Subject | Re: [IBO] Using IB_SQL to update V5 to V6/IB metadata |
---|---|
Author | lester@lsces.co.uk |
Post date | 2002-07-17T22:22:10Z |
> I have a version 5 database that I'm converting to FB and at least partially to IBO inI have not had to do this for some time, but do you have two
> order to learn about IBO and FB before beginning a new big project.
>
> In order to do this, I need to first alter 3 tables to change the now-reserved word YEAR
> to TheYEAR and update all of the stored procedures that use them.
networked machines available?
Set up one with IB5 and the other with Firebird.
> IB_SQL doesn't show me the source to these tables so that I can change them.I did not have any problem reading the IB5 source tables
with IB_SQL and I don't think it is broken now, just connect
and use the metadata extract?
> Also, I haven't been able to work out how to update metadata with IB_SQL, so I'dThe metadata file can be edited in notepad, the problem
> appreciate some direct info on that.
names changed, and then you just run it as a script to
create the database on Firebird, at which time problems will
be flagged.
Once you have the new database, just pump from one to the
other using the datapump. Telling it the new names of the
mapped entries to copy to ( just use "'s around the reserved
names ).
As I said - some time since I used it, but it worked for me.
> I've tried IBOConsole, but I don't know how to get started in that because of the need toIBConsole is not much use for anything on Firebird. I use
> 'Register'. What do I do with it to get it into a state in which I can view and alter
> metadata?
IB_SQL and command line backup/restore.
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services