I rebuild two SQL Anywhere 17 databases with command "%SQLANY17%\bin64\dbunload" -v -c "ENG=dbunl;UID=xxx;PWD=xxx;start=%SQLANY17%\bin64\dbeng17.exe;dbf=C:\Backup\data.db" -an "C:\temp\data_new.db" -ap 4096 -ea None -kdi 0 -ii -up Both databases contain integrated login mappings and have the same structure. After a reload, the integrated login mappings are missing in one of the databases, in the other they are complete. If I only unload the reload script and then compare them, there are no differences and both databases contain "GRANT INTEGRATED LOGIN TO ..." and "SET OPTION "PUBLIC"."login_mode"='Mixed'". What else can I check? asked 24 Jan, 10:30 Miro Marek |
Are the integrated logins that are missing still valid. The user(s) must exist at the present time in the context in which the rebuild is being done (otherwise, the GRANT INTEGRATED LOGIN will fail).