How to use SQLServer database with Sqoop

Question

Hi. I want to use SQLServer database with Sqoop and the default is MySql. How can I change the database to SQLServer?

Answer 1

First, download the SQLServer connector from Microsoft's official website. Then move the connector file to the Sqoop lib path. Then SQLServer in the sqoop import command as mentioned below:

$ sqoop import --driver com.microsoft.jdbc.sqlserver.SQLServerDriver \
    --connect <other parameters>