wbcopytables: Invalid option
Posted by: vaibhav anmand
Date: June 19, 2016 07:30AM

I am migrating sql server tables in MySQL using wbcopytables command. I want to copy a specific range(id 1-10000) of data from MSSQL to MySQL, so I am using below syntax.

wbcopytables --odbc-source="DRIVER={FreeTDS};SERVER=**.**.**.**;PORT=1433;DATABASE=TESTDB;UID=***;PWD=***;TDS_VERSION=7.1" --target="root@127.0.0.1:3306" --force-utf8-for-source --truncate-target --table-range [TESTDB] [dbo].[DeletedUnits] TESTDB DeletedUnits Unit_Id Unit_Id 1 10000

unfortunately I am getting below error message this syntax.

wbcopytables: Invalid option 10000

workbench version : 6.0.8 11354 build 833

Options: ReplyQuote


Subject
Written By
Posted
wbcopytables: Invalid option
June 19, 2016 07:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.