database restore to SQL - field is not defined in table

Doomhammer

Hi,

I have problem with database restore from native to SQL server.
database and client are 5.0 SP1, client is newest build. SQL is 2012.

During restore process, I am running into problem: error message Field No ### is not defined in the ### table.

I tried to recompile all objects, deleted objects with compilation error, but did not help.

Thanks for help.

Doomhammer

Hello,

I found my problem - someone deleted two fields in table and those fields were used in keys. I deleted those keys and restore was OK.
this error could not be found via compile.

evandeveerdonk

Hi Martin,

are you able to do an import of the objects first? Either by importing a fob, or a backup with only the objects.
In that case, you might by-pass this problem
Ernst

Doomhammer

Hello,

I found my problem - someone deleted two fields in table and those fields were used in keys. I deleted those keys and restore was OK.
this error could not be found via compile.