Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

Fri, Aug 22 2008 6:00 AM	Permanent Link
Peter Thorne	I have just moved to a new PC and upgraded from 1.9 B2 to 1.9 B4 in the process (perhaps not a good idea in hindsight). As a result I seem to have some databases with cat files that no longer refer to any tables in the database (example attached). Opening a database in edb manger won't display any tables even though the db is pointing at the correct directory. The wierd thing is that this has only happened for some of my databases and not all. How can I rebuild cat files for each affected db? Simply deleting the affected file just results in another "empty" cat file. PS - Before you ask I rather dumbly did this operation with a sync programme so I don't have the original cat files ...
Fri, Aug 22 2008 12:09 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Peter, << I have just moved to a new PC and upgraded from 1.9 B2 to 1.9 B4 in the process (perhaps not a good idea in hindsight). As a result I seem to have some databases with cat files that no longer refer to any tables in the database (example attached). Opening a database in edb manger won't display any tables even though the db is pointing at the correct directory. The wierd thing is that this has only happened for some of my databases and not all. How can I rebuild cat files for each affected db? Simply deleting the affected file just results in another "empty" cat file. PS - Before you ask I rather dumbly did this operation with a sync programme so I don't have the original cat files ... >> I'm afraid there's nothing you can do to recover a catalog file short of re-issuing all of the DDL to create the database objects. The catalog file is the one and only place where all of the metadata for a database is stored. -- Tim Young Elevate Software www.elevatesoft.com
Sat, Aug 23 2008 9:57 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Peter >I'm afraid there's nothing you can do to recover a catalog file short of >re-issuing all of the DDL to create the database objects. The catalog file >is the one and only place where all of the metadata for a database is >stored. Unless, it suddenly hit me, you'd reverse engineered it at some point and still have a copy of the generated SQL around? Roy Lambert [Team Elevate]