Re: Transferring a DB to a new platform WITHOUT export/import

On Wed, 14 May 2003 03:45:34 +0000, Hans Forbrich wrote:

> Since you have experience at this product, would you please do a comparison
> between this and a plain export without data? You seem pleased with the
> performance & I'm intrigued whether this is faster than the export equiv for
> a "no data" request.

Databee is not a replacement for export without a data, it complements it. The output of the DBA tool are DDL commands which would otherwise remain embedded in a binary .dmp file. The nice thing is that you can, for instance, drop storage clauses. You can do it with TORA as well, but TORA is much more powerfull and is much slower because it uses a database connection and not a binary fiole parser. LOB types are handled OK. As for the object types, I have none.

>
> Do you have any experience/comments about the completeness of dictionary it
> provides across versions? Especially handling things like sequences, LOBs
> and objects/types.

I did. The set of DDLs was complete, including the column default values. Sequences are not starting with last currval but with 1. You must take care of getting the last value over yourself, because the dump file does not contain that information.

>
> I do understand the benefit of getting a data subset as described on their
> page. Based on your comments, I may need to investigate applicability in my
> environment.

The tool is free, so no additional costs are incurred. Databee does offer support, so if your boss insists, you can buy the license.

>
> Thanks
> /Hans

-- 
Mladen Gogala
Software is like sex, it is better when it is free.
Linus Torvalds