MySQL Forums
Forum List  »  Microsoft SQL Server

WorkBench Migration error
Posted by: PHILIPPE CHAUVIN
Date: February 28, 2013 05:13AM

Hello,
i'm trying to migrate an MS SQL Server 2008 R2x64 database to MYSQL 5.1.36 using WorkBench migrating tool.
I've successfully setup the source and target RDBMS (test connection OK).
But for the next step (Fetch shema list), there is a error connecting to DBMS source:

Starting...

Connect to source DBMS...

- Connecting to source...

Traceback (most recent call last):

File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\db_mssql_grt.py", line 173, in getServerVersion

ver_string = execute_query(connection, "SELECT CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR)").fetchone()[0]

File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\db_mssql_grt.py", line 62, in execute_query

return get_connection(connection_object).cursor().execute(query, *args, **kwargs)

pyodbc.ProgrammingError: ('42000', '[42000] [MySQL][ODBC 5.1 Driver][mysqld-5.1.36]FUNCTION SERVERPROPERTY does not exist (1305) (SQLExecDirectW)')

Traceback (most recent call last):

File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\db_mssql_grt.py", line 173, in getServerVersion

ver_string = execute_query(connection, "SELECT CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR)").fetchone()[0]

File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\db_mssql_grt.py", line 62, in execute_query

return get_connection(connection_object).cursor().execute(query, *args, **kwargs)

pyodbc.ProgrammingError: ('42000', '[42000] [MySQL][ODBC 5.1 Driver][mysqld-5.1.36]FUNCTION SERVERPROPERTY does not exist (1305) (SQLExecDirectW)')



Traceback (most recent call last):

File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\workbench\wizard_progress_page_widget.py", line 66, in run

self.func()

File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\migration_source_selection.py", line 415, in task_connect

raise e

SystemError: ProgrammingError("('42000', '[42000] [MySQL][ODBC 5.1 Driver][mysqld-5.1.36]FUNCTION SERVERPROPERTY does not exist (1305) (SQLExecDirectW)')"): error calling Python module function DbMssqlRE.getServerVersion

ERROR: Error during Connect to source DBMS: ProgrammingError("('42000', '[42000] [MySQL][ODBC 5.1 Driver][mysqld-5.1.36]FUNCTION SERVERPROPERTY does not exist (1305) (SQLExecDirectW)')"): error calling Python module function DbMssqlRE.getServerVersion

ERROR: Exception in task 'Connect to source DBMS': SystemError('ProgrammingError("(\'42000\', \'[42000] [MySQL][ODBC 5.1 Driver][mysqld-5.1.36]FUNCTION SERVERPROPERTY does not exist (1305) (SQLExecDirectW)\')"): error calling Python module function DbMssqlRE.getServerVersion',)

Failed

Thank for any help.

Options: ReplyQuote


Subject
Written By
Posted
WorkBench Migration error
February 28, 2013 05:13AM


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.