I have a table with some data in database a. I copied it to other database
folder (database b).

How can i add this table to database b? I don't want to create new table and
copy records.

I just want to register this table to database catalog.

Tomas


You're going to have to create a table. Its the only way ElevateDB will know the data is there. All you need to do is reverse engineer the other database, cut the bit for that table and run it in the other database.

Roy Lambert

Tomas,

<<I have a table with some data in database a. I copied it to other database
folder (database b). >>

You cannot do that with ElevateDB.  You must use ElevateDB itself to peform
the table creation and row insertion.   Roy's answer is a good solution.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thanks Tim.

The problem is i have zipped database without database config and catalog
files. There are only table, blob and index files.
Original files are removed.

How can i recover the database?

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:D00A89D7-B201-47EA-94FF-9FBAABAB3EC4@news.elevatesoft.com...
> Tomas,
>
> <<I have a table with some data in database a. I copied it to other
> database folder (database b). >>
>
> You cannot do that with ElevateDB.  You must use ElevateDB itself to
> peform the table creation and row insertion.   Roy's answer is a good
> solution.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Tomas
If you know the structure of the tables then its a bit of typing - create new catalog definitions for the tables, then drop the data into the appropriate directory. If you're lucky you'll be able to open them. If there's a variance in the version numbers I'm lost.

Roy Lambert

Tomas,

<< The problem is i have zipped database without database config and catalog
files. There are only table, blob and index files.  Original files are
removed.

How can i recover the database? >>

Do you at least have the SQL that can create the table structures ?   If so,
then I can get things working again for you if you send me the SQL along
with the table files.  As Roy indicated, the internal version numbers may
need to be reset for the tables in order to get them to work with the new
database catalog.

--
Tim Young
Elevate Software
www.elevatesoft.com

I did it as Roy said. Thanks.

But can you add any function to use external table in a database? I think it
makes the database more flexible.



"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:9481AD56-0A01-41BA-A36B-D2CAA4F136DF@news.elevatesoft.com...
> Tomas,
>
> << The problem is i have zipped database without database config and
> catalog files. There are only table, blob and index files.  Original files
> are removed.
>
> How can i recover the database? >>
>
> Do you at least have the SQL that can create the table structures ?   If
> so, then I can get things working again for you if you send me the SQL
> along with the table files.  As Roy indicated, the internal version
> numbers may need to be reset for the tables in order to get them to work
> with the new database catalog.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Tomas,

<< But can you add any function to use external table in a database? I think
it makes the database more flexible. >>

The table files don't have any information in them regarding the structure
of the table, so if I did something like this it could be very deadly in the
hands of the wrong person.

I'll see if I can think up some safeguards.

--
Tim Young
Elevate Software
www.elevatesoft.com