Orientdb和Teleporter问题 [英] Orientdb and teleporter issues

问题描述

我很难用Orientdb和teleporter做一个简单的用例

I am having difficulty doing a simple use case with Orientdb and teleporter

堆栈:

OS:Windows 10/Java:v8/Orientdb:2.2 beta2/Teleporter:1.0.0/ 数据库:MS SQL Express 2014

OS: Windows 10 / Java: v8 / Orientdb: 2.2 beta2 / Teleporter: 1.0.0 / Database: MS SQL Express 2014

设置:

1. 已安装，实例名称为SQL2014的MS SQL Express 2014
2. 使用两个表创建了新的数据库Graphdb，两个国家/地区:带有PK国家ID和带有PK省ID和FK国家ID的省
3. 已安装，然后启动Orient db 2.2 beta 2

4. 创建了新的oteleporter_graphdb.bat

1. Installed, MS SQL Express 2014 with instance name SQL2014
2. Created new db Graphdb with two tables, Country w/ PK Country ID and Province w/ PK Province ID and FK Country ID
3. Installed, and start Orient db 2.2 beta 2

4. Created new oteleporter_graphdb.bat

oteleporter.bat -jdriver sqlserver -jurl jdbc:sqlserver://:54963; instance:SQL2014; databaseName:graphdb -juser sa -jpasswd -ourl plocal:$ ORIENTDB_HOME/databases/graphdb -s naive -nr java -v 2

oteleporter.bat -jdriver sqlserver -jurl jdbc:sqlserver://:54963;instance:SQL2014;databaseName:graphdb -juser sa -jpasswd -ourl plocal:$ORIENTDB_HOME/databases/graphdb -s naive -nr java -v 2

测试用例:

1. 按原样运行oteleporter_graph.bat

此测试用例读取了db并为表的sql元数据部分(但Country&省份不是它的一部分.

This test case read the db and created warnings for table’s part of sql metadata but Country & Province were not part of it.

1. 修改oteleporter_graph.bat以同时包含国家"和省"表

1. Modify oteleporter_graph.bat to include both Country and Province table

oteleporter.bat -jdriver sqlserver -jurl jdbc:sqlserver://:54963; instance:SQL2014; databaseName:graphdb -juser sa -jpasswd -ourl plocal:$ ORIENTDB_HOME/databases/graphdb -s naive -nr java -v 2 –包括国家，省

oteleporter.bat -jdriver sqlserver -jurl jdbc:sqlserver://:54963;instance:SQL2014;databaseName:graphdb -juser sa -jpasswd -ourl plocal:$ORIENTDB_HOME/databases/graphdb -s naive -nr java -v 2 –include Country,Province

该测试已中止！

1. 修改oteleporter_graph.bat以仅包括国家/地区"表.

1. Modify oteleporter_graph.bat to include only Country table.

oteleporter.bat -jdriver sqlserver -jurl jdbc:sqlserver://:54963; instance:SQL2014; databaseName:graphdb -juser sa -jpasswd -ourl plocal:$ ORIENTDB_HOME/databases/graphdb -s naive -nr java -v 2 –包括国家/地区

oteleporter.bat -jdriver sqlserver -jurl jdbc:sqlserver://:54963;instance:SQL2014;databaseName:graphdb -juser sa -jpasswd -ourl plocal:$ORIENTDB_HOME/databases/graphdb -s naive -nr java -v 2 –include Country

此测试用例运行无误，但没有从数据库中读取任何表，也没有输出任何内容.

This test case ran without any error but didn’t read any table from the database nor output anything out.

问题:

1. 我是否缺少任何配置步骤?
2. 测试案例2，如何定义多个表? 其他问题:
3. 是否可以向表格添加过滤器?
4. 可以包含视图而不是表?传送者将如何识别PK/FK?

1. Am I missing any configuration steps?
2. Test case #2, how to define multiple tables? Other questions:
3. Possible to add filter to the tables?
4. Instead of tables, views can be included? how would teleporter will identify the PKs / FKs?

预先感谢

推荐答案

我将尝试按顺序回答您的问题.

I'll try to answer your questions in order.

1. 要安装和运行Teleporter，您必须:
   • 在ORIENTDB_HOME/plugins路径中提取orientdb-teleporter-1.0.0.jar.
   • 在您的ORIENTDB_HOME/bin路径中提取oteleporter.bat和oteleporter.sh脚本，并使用所需的参数从该位置启动它们.

1. To install and run Teleporter you have to:
   • extract orientdb-teleporter-1.0.0.jar in your ORIENTDB_HOME/plugins path.
   • extract the oteleporter.bat and oteleporter.sh scripts in your ORIENTDB_HOME/bin path and launch them from that location with the expected arguments.

如果有任何疑问，可以在这里参考官方页面，文档和博客文章:

If you have any doubt you can refer to official page, documentation and blog posts here:

http://orientdb.com/orientdb-labs/teleporter/ (官方传送门页面)

http://orientdb.com/orientdb-labs/teleporter/ (Official Teleporter Page)

https://github.com/orientechnologies/orientdb-实验室/blob/master/Teleporter-Index.md (官方文献)

http://orientdb.com/orientdb-teleporter-making-migrations-easier / (博客文章:OrientDB Teleporter-简化迁移(第1部分))

http://orientdb.com/orientdb-teleporter-making-migrations-easier/ (Blog Post: OrientDB Teleporter - Making Migrations Easier (Part 1) )

http://orientdb.com/orientdb-teleporter-making -migrations-easier-part-2/ (博客文章:OrientDB Teleporter-简化迁移(第2部分))

http://orientdb.com/orientdb-teleporter-making-migrations-easier-part-2/ (Blog Post: OrientDB Teleporter - Making Migrations Easier (Part 2) )

这篇关于Orientdb和Teleporter问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！