Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
Error migrating from DBISAM |
Sun, Jul 6 2008 4:08 AM | Permanent Link |
"Uli Becker" | Hi Tim,
I just tried to migrate another database from DBISAM3 to EDB. The migrations stops with this error: ElevateDB Error #700 An error was found in the statement at line 1 and column 1 (Missing SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP, GRANT, REVOKE, BACKUP, RESTORE, SET BACKUPS, REPAIR, OPTIMIZE, IMPORT, EXPORT, DISCONNECT, REMOVE, PUBLISH, UNPUBLISH, SAVE, LOAD, SET UPDATES, COPY FILE, RENAME FILE, DELETE FILE) I was able to isolate the DBISAM tables that cause the trouble. I'll send them to you by mail. Regards Uli |
Mon, Jul 7 2008 4:06 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Uli,
<< I just tried to migrate another database from DBISAM3 to EDB. The migrations stops with this error: >> Okay, the issue is that the migrator uses the special 'Text_' prefix for creating text indexes in the new ElevateDB tables, and you are using index names in the DBISAM tables called 'Text_'. DBISAM didn't give text indexes names, but EDB does. If you rename the source indexes prior to the migrate, that will resolve the issue. I'll see what I can do about this, but I'm not sure if I should change the naming at this point because it may break someone's application that is expecting the new text indexes to be called 'Text_<ColumnName>'. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |