Cannot Restore Data Common To All Companies

clocx

Hello everybody,

I've created a backup in Native (Entire Database).
In the database some tables have the property "Data Common to all Companies" set to No.
When I restored the database in SQL the "common" tables are created but no data is stored in it.
In the restore dialog I selected the option "Entire Database".
I also tried to create a "custom" backup and seleted the option to backup "Data Common to all companies". The data was backed up, but was also ignored during restore.
I don't know how to solve this problem. Can you help me?

David_Singleton

This will normally happen if you are importing into a database that is not new. for example if there are any object in the database before you restore.

Make a clean database and import to that.

clocx

Thank you David,

It looks like your suggestions will work.
I had first imported the objects where I dropped some keys and sumindexes that are not neccesary in SQL.
It is a bit waste of time to create them first and then drop them after creation.
(It is a database of 128G).
But anyway you helped me a lot.
Thanx

David_Singleton

clocx wrote:

Thank you David,

It looks like your suggestions will work.
I had first imported the objects where I dropped some keys and sumindexes that are not neccesary in SQL.
It is a bit waste of time to create them first and then drop them after creation.
(It is a database of 128G).
But anyway you helped me a lot.
Thanx

Just drop the keys BEFORE you make the backup, assuming you have a database you can do that in (not live of course)

By the way, better is to do a SQL backup restore, much faster and easier.

clocx

Yes, I know.
This is a migration from Native to SQL.

David_Singleton

clocx wrote:

Yes, I know.
This is a migration from Native to SQL.

Then you can still deactivate the uneccessary keys before you do the backup.