At 12:02 PM 19-11-01 +0000, you wrote:

>Hi all,
>
>Thanks so far for all the great explications! I've learned much more
>than I did when reading all these chapters and articles. I still do
>hope that the book announced last year will be written some time...

..some time before I die...<sigh>...but there are two *other* books in the pipeline, one (in two volumes) quite soon, one a few months from now...

>Now, I want to transform my old database format, into a much better
>format... I want to change my primary keys. Is there some information
>on the best way to do this? Or is it just 'deal with the pain you
>caused yourself' :-)

The best way to deal with this is to remodel your database completely - script it every step of the way, test things out with test data borrowed from your existing database - and then simply pump the data into a brand-new shell created from your *perfect* script. That way you can take care of your dependencies ahead of time and find any problem data that might be lurking about in your old database.

And it is sooooo refreshing - like slipping between clean bedsheets.

One thing our community does very, very well is data pump tools.

regards,
Helen

>Thanks in advance,
>Tom.
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________