-
Notifications
You must be signed in to change notification settings - Fork 19
External LOBs Filter Module
This filter module is used to fetch and save a LOB that is stored outside the DBMS environment.
External LOBs filter module configuration is bounded to Import Config module. For each column you have that is an external LOB reference you should configure as shown in the example bellow:
schemas:
sakila:
tables:
- name: "table_with_external_lobs"
columns:
(...)
- name: "column_reference"
externalLOB:
basePath: "<replace_by_the_base_path>"
accessMethod: "<replace_by_the_file_system_type"
(...)For more information please refer to Import Config module wiki page.
The filter can be invoked without the need to add parameters.
dbptk migrate -i import-config [args] -e [export-module] [args] -f external-lobs
Used when LOBs referenced in the database are present on local file system.
schemas:
sakila:
tables:
- name: "table_with_external_lobs"
columns:
(...)
- name: "column_reference"
externalLOB:
basePath: ""
accessMethod: "file-system"
(...)Used when LOBs referenced in the database is in a remote accessible location
schemas:
sakila:
tables:
- name: "table_with_external_lobs"
columns:
(...)
- name: "column_reference"
externalLOB:
basePath: ""
accessMethod: "ssh-system"
(...)Note: In order to use this reference type strategy the connection to the database must use SSH parameters. More information here.
Copyright © 2019 by KEEP SOLUTIONS
All rights reserved. No part of this publication may be reproduced, distributed, or transmitted in any form or by any means, including photocopying, recording, or other electronic or mechanical methods, without the prior written permission of the publisher, except in the case of brief quotations embodied in critical reviews and certain other noncommercial uses permitted by copyright law. For permission requests, write to the publisher, addressed “Attention: Permissions Coordinator,” at the address below.
KEEP SOLUTIONS, LDA.
Rua Rosalvo de Almeida, nº 5
4710-429 Braga, Portugal
W www.keep.pt E [email protected]