garbage after unsintall BTS 1.10
Posted in 2008
Topics: Installation, Setup & Upgrades, Data Types & Schema Design, Migration, Import/Export & Data Conversion
Hi,
I have here a IDS 11.50 UC2 Developer with BTS 1.10 installed and registered in a database.
Now I will migrate all data to another instalation with IDS 11.50
UC3 Developer on another machine, and I want to use the dbexport. So I
execute the dbexport and see a lot of casts, data types, procedures
generated by BTS, so I remove all indexes created to BTS and unregister
it . After execute the dbexport/dbschema again still have some casts , data
types and procedures.
There is a way to clean all refer to BTS automaticly? or after uninstall/unregister any datablade always will still a garbage ...
The solution I have here is identify the owner of objects, where on my database isn't "informix" user (and the objects of BTS is "informix") or execute a unload table by table....
César
Novos endereços, o Yahoo! que você conhece. Crie um email novo com a sua cara @ymail.com ou @rocketmail.com.
http://br.new.mail.yahoo.com/addresses
Hello César,
Since no one is answering your BTS question (and I can't either), try
something else. For example, use "dbschema" on your source to get the
table layouts and then run them on your target. Then run "UNLOAD TO
tablename.file SELECT * FROM tablename" on your source and then "LOAD
FROM tablename.file INSERT INTO tablename" on your target.
-L.S.