I am ashamed. In the real, my problem was two:
1) Communication failure. Some DBA (maybe I?), changed DBA password as decided on a long boring meeting (and I forgot); 2) on DBMCLI, user_getall don't take database users. That's why just appear DBM. Using correct DBA password all get working as tradicional. If I can rewrite the past, I'll clear last chapters... Forgive-me all. SapDB is the best small database I've worked forever. And for my mails be forget, two tips: 1) In Sybase PowerDesigner, create your schemas as in Oracle 7. Then, in SQL Studio (or whatever) connect in Oracle mode. Note: change / to // for get script working fine. 2) Never try to compact directory of SapDB in NTFS filesystems. Definetly don't work. And is not even recommended (as Microsoft states in theyr MS SQL Server 2072A Administration Course). Thanks to all that helped-me (hey guys, put the Sybase tip on the FAQ? And the fact that dbmcli users_getall command doesn't return database users! This helps... I take too much time searching info about this before sending one mail to the list...). Again, thanks! Edson Richter -----Mensagem original----- De: [EMAIL PROTECTED] [mailto:sapdb.general-admin@;listserv.sap.com]Em nome de Edson Carlos Ericksson Richter Enviada em: Monday, November 04, 2002 11:07 PM Para: [EMAIL PROTECTED] Assunto: Please, Help!!! Migration from 7.3.0.24 to 7.3.0.29 RESUME: DBA (SYSDBA Account) desappear after migration!!! I already searched all archives withou any success! May be something wrong in my install? Can someone help-me, please? Plataform: Win2K, SP3 1) Migration process: Backup complete for migration 2) Completely Uninstall of version 7.3.0.24 3) New install of version 7.3.0.29 4) Created a new instance via DBM Gui 7.4.2.6 for restore (parameters wasn't copied) 5) Restore database from step 1 After migration from 7.3.0.24 to 7.3.0.29, DBA (that is my SYSDBA user) disapeeared! Anyone knows how can I re-create DBA (that is a SYSDBA) account? Thanks in advantage, Edson Richter --- Email foi verificado quanto a exist�ncia de virus antes de seu envio, e n�o h� virus. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.410 / Virus Database: 231 - Release Date: 10/31/2002 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general --- E-Mail recebido est� sem virus. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.410 / Virus Database: 231 - Release Date: 10/31/2002 --- Email foi verificado quanto a exist�ncia de virus antes de seu envio, e n�o h� virus. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.410 / Virus Database: 231 - Release Date: 10/31/2002 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general --- E-Mail recebido est� sem virus. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.410 / Virus Database: 231 - Release Date: 10/31/2002 --- Email foi verificado quanto a exist�ncia de virus antes de seu envio, e n�o h� virus. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.410 / Virus Database: 231 - Release Date: 10/31/2002 --- Email foi verificado quanto a exist�ncia de virus antes de seu envio, e n�o h� virus. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.410 / Virus Database: 231 - Release Date: 10/31/2002 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
