MySQL Forums
Forum List  »  Microsoft SQL Server

Lost ability to retrieve the schemes from MSSQL once we replaced our MSSQL 2008 R2 version with 2017 version
Posted by: Jacob Nikom
Date: February 22, 2018 04:23PM

I lost the ability to retrieve the schemes from MSSQL once we replaced our
2008 R2 version with 2017. I tried to do it unsuccessfully on CentOS 6.6 and
CentOS 7.4 using freeTDS drivers freetds-dev.0.92.1021.tar.gz and the latest
freetds-1.00.82.tar.gz.

I am still able to perform data migration successfully using
/usr/libexec/mysql-workbench/wbcopytables-bin executable.

I have "sa" privileges for this database:
USE rfcAnalysis
SELECT suser_sname(sid)
FROM sys.database_principals
WHERE principal_id = user_id('dbo')
---
sa

(1 row affected)

I successfully connected to the source and target databases and successfully
retrieved the schema list from the source. So the first three steps of data
migration were successful.

However, when I moved to the next step "Schemas Selection", I did not see any
source schemas. They supposed to be visible over there, but instead I see the
empty pane. The "Next" button was grey out, so I cannot go forward to the next
step - "Reverse Engineer Source".

I used to be able to do that with MSSQL 2008 R2 versions.

The WB did issue any errors or warnings - everything looked fine.

Here is my log:
17:02:30 [ERR][ main]: Can't communicate with gnome-keyring, it's probably not running. Stored passwords will be lost once quit.
17:02:30 [INF][ WBContext UI]: Initializing workbench context UI with these values:
base dir: /usr/share/mysql-workbench
plugin path: /usr/lib64/mysql-workbench/plugins
struct path: /usr/share/mysql-workbench/grt
module path: /usr/lib64/mysql-workbench/modules
library path: /usr/share/mysql-workbench/libraries
user data dir: /home/googlebq/.mysql/workbench
open at start:
open type:
run at startup:
run type:
Force SW rendering: No
Force OpenGL: No
quit when done: No
17:02:30 [INF][ WBContext]: WbContext::init
17:02:30 [INF][ WBA]: Looking for extension modules for WBA...
17:02:30 [INF][ WBA]: 3 extension modules found
17:02:31 [WRN][ grt]: /home/googlebq/.mysql/workbench/connections.xml:15: link '97fdf9f0-1594-11e8-b1bd-005056831d00' <object GrtObject> key=owner could not be resolved
17:02:31 [INF][ WBContext]: System info:
MySQL Workbench Commercial (Proprietary) for Linux/Unix version 6.3.10 SE build 12596444 (64 bit)
Configuration Directory: /home/googlebq/.mysql/workbench
Data Directory: /usr/share/mysql-workbench
Cairo Version: 1.14.8
OS: CentOS Linux release 7.4.1708 (Core) x86_64
CPU: 4x Intel(R) Xeon(R) CPU E5-2640 0 @ 2.50GHz (2500.000MHz) - 7.64GiB RAM
No video adapter info available
Distribution: CentOS Linux release 7.4.1708 (Core)

Fips mode enabled: no

17:02:31 [WRN][ WBModule]: OS not found on supported OS list. OS string: 'CentOS Linux release 7.4.1708 (Core) x86_64'
17:02:57 [INF][ WBContext]: Loaded 0/0 new non-MySQL connections
17:04:15 [INF][ grt]: Connecting to Mssql@DRIVER=MyFreeTDSDriver;SERVER=AZSQLDB.invaluable.corp;PORT=1433...
17:04:15 [INF][ grt]: Opening ODBC connection to DRIVER={MyFreeTDSDriver};SERVER=AZSQLDB.invaluable.corp;PORT=1433;DATABASE=;UID=OSDprod;PWD=XXXX;TDS_VERSION=7.1...
17:04:25 [INF][ grt]: Connecting to Mssql@DRIVER=MyFreeTDSDriver;SERVER=AZSQLDB.invaluable.corp;PORT=1433...
17:04:25 [INF][ grt]: Opening ODBC connection to DRIVER={MyFreeTDSDriver};SERVER=AZSQLDB.invaluable.corp;PORT=1433;DATABASE=;UID=OSDprod;PWD=XXXX;TDS_VERSION=7.1...
17:04:25 [INF][ grt]: Connected to Mssql@DRIVER=MyFreeTDSDriver;SERVER=AZSQLDB.invaluable.corp;PORT=1433, 14.0.3008.27
17:04:46 [INF][ grt]: Connecting to Mysql@127.0.0.1:3306...
17:04:52 [INF][ grt]: Connecting to Mysql@127.0.0.1:3306...
17:04:52 [INF][ grt]: Connected
17:04:58 [INF][ Wizard]: Execute 'Connect to source DBMS'
17:04:58 [INF][ grt]: Connecting to Mssql@DRIVER=MyFreeTDSDriver;SERVER=AZSQLDB.invaluable.corp;PORT=1433...
17:04:58 [INF][ grt]: Opening ODBC connection to DRIVER={MyFreeTDSDriver};SERVER=AZSQLDB.invaluable.corp;PORT=1433;DATABASE=;UID=OSDprod;PWD=XXXX;TDS_VERSION=7.1...
17:04:58 [INF][ grt]: Connected to Mssql@DRIVER=MyFreeTDSDriver;SERVER=AZSQLDB.invaluable.corp;PORT=1433, 14.0.3008.27
17:04:58 [INF][ Wizard]: Execute 'Check target DBMS connection'
17:04:58 [INF][ grt]: Connecting to Mysql@127.0.0.1:3306...
17:05:15 [INF][ grt]: Connecting to Mysql@127.0.0.1:3306...
17:05:15 [INF][ grt]: Connected
17:05:16 [INF][ Wizard]: Starting thread for 'Retrieve schema list from source'

Thank you

Options: ReplyQuote


Subject
Written By
Posted
Lost ability to retrieve the schemes from MSSQL once we replaced our MSSQL 2008 R2 version with 2017 version
February 22, 2018 04:23PM


Sorry, only registered users may post in this forum.

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.