dbptk-developer icon indicating copy to clipboard operation
dbptk-developer copied to clipboard

Cannot deploy a database with external LOBs

Open BorisDomajnko opened this issue 5 years ago • 3 comments

To load the database it seems that I need to use the same filter options as for creating the SIARD file. But it is unconvenient to deal with --filter1-column-list additional file. What are the parameters to export to filesystems? Now I get errors , connected to creation of BLOBS.

Creation of SIARD (runs ok): dbptk-app.log_CREATE_SIARD.txt Deployment: dbptk-app.log_DEPLOY_SIARD.txt

Options: [ -jar dbptk-app-2.6.0-RC.jar migrate
--filter external-lobs
--filter1-column-list /home/doma/dbdipview/www/files/LOB_list_file.txt
--filter1-reference-type file-system
--filter1-base-path=/home/doma/dbdipview/www/files/xx ](url)

BorisDomajnko avatar Sep 17 '19 08:09 BorisDomajnko

Hi Boris,

At the moment DBPTK doesn't support the import of the SIARD with external-lobs defined by a filter. The issue will remain open and can be revisited in future iterations of DBPTK. For now, DBPTK only supports the creation of the SIARD. You cannot export it to the file system again.

hmiguim avatar Sep 17 '19 13:09 hmiguim

reopen

hmiguim avatar Sep 17 '19 13:09 hmiguim

I thought the problem was only the export to DB (to a given output folder). I hope there will be further activities soon:) Best regards, Boris

BorisDomajnko avatar Sep 17 '19 13:09 BorisDomajnko