Be careful with the MSSQL tables and the analysis if you sync the analysis with the external databases
For me it's a problem, sometimes the date fields are changed to datetime and so on in the analysis.
I'm not sure why but it as something to do with the MSSQL server version, we have several MSSQL intallations with diferent versions and in some cases this was a problem.
When we have tables in MSSQL the option Propose to synchronize with the external databases of the analysis is always set to Never to be sure that we don't have problems in the future.
Regards
Paulo Oliveira
Edited 1 time(s). Last edit at 06/19/2019 02:49PM by pao.