Lost ability to retrieve the schemes from MSSQL once we replaced our MSSQL 2008 R2 version with 2017 version
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