Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Error migrating from DBISAM
Sun, Jul 6 2008 4:08 AMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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

Image