Skip to content

Instantly share code, notes, and snippets.

@randyzwitch

randyzwitch/sqlserver-to-omnisci.sh

Last active September 24, 2019 20:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save randyzwitch/88843ad385e28fe57b8e7da8b48f431a to your computer and use it in GitHub Desktop.
Save randyzwitch/88843ad385e28fe57b8e7da8b48f431a to your computer and use it in GitHub Desktop.
Download ZIP
Example SQL Server to OmniSci SQLImporter code
Raw
sqlserver-to-omnisci.sh
java -cp /opt/omnisci/bin/mapd-1.0-SNAPSHOT-jar-with-dependencies.jar:/path/mssql-jdbc-7.4.1.jre8.jar \
com.mapd.utility.SQLImporter \
-d com.microsoft.sqlserver.jdbc.SQLServerDriver \
-u admin -p HyperInteractive -db omnisci --port 6274 -t customers \
-su sqlserver_user -sp sqlserver_password \
-c "jdbc:sqlserver://localhost:1433;DatabaseName=prod" \
-ss "select * from dbo.customers"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment