import the whole database using sqoop

Question

I understand that we have --import-all-tables for importing all tables. But can we import the whole database using Sqoop so that the DB properties are also imported.

Answer 1

We can't import DB properties using Sqoop, using SQOOP we can only import data from DB to HDFS along with java, avro files(avro schema contains table schema but not db properties).