Re: WorkBench Migration error

[Sergio Andres De La Cruz Rodriguez]

Hi Philippe:

As I can read from what you pasted, here's the problem:

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

As you see, it is complaining about the SERVERPROPERTY function. It seems strange to me since the official SQL Server 2008 R2 documentation says it is indeed supported: http://msdn.microsoft.com/en-us/library/ms174396(v=sql.105).aspx

Can you run this query in your SQL Server server and report the results back here?:

SELECT CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR)

Also, can you tell us which Workbench version are you using?

Cheers,

Sergio A. de la Cruz Rodríguez
Software Developer
Oracle Corp.