On Tue, Feb 23, 2021 at 3:00 PM liviuslivius <liviusliv...@poczta.onet.pl> wrote:
> Why not standard way by creating new field copy data delete old and > rename? > Hundreds of tables/SPs/Triggers using this domain (it's used domain in almost every table, multiple times per table) It can be slow operation, is it your conern to do not take production > database too long offline? > Exactly, and in fact a client have 20+ databases with 100Gb+ each db and at least 5 distinct databases If yes, you can speed up such process if you have access to good hardware > with a loot of RAM and do all in memory. > Possible, but anyway I'm not sure how long would it take (creating a new database empty and fixed is quick, but exporting/importing is my concern) > > I do not know also your setup and how complicated relations are as you can > also add new field and create view which choose new field and hen you can > divide this process in multiple update steeps. > It's a ERP, so hundreds of relations and dependencies > > Regards, > Karol Bieniaszewski > > > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel >
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
