Merge two different OCS server databases

Question

Hi

Do you have the option to merge two different databases?

"Synchronization between OCS servers master/slaves" Not good, because it only syncs the currently logged in machines. I need complete database.

Thanks!

Answer 1

I didn't try this, but for sure SQL database export / impost via SQL commands works fine What's exactly the problem ? Can't you sent OCS traffic to one server?

Answer 2

I have two OCS servers with different data. I want to unite. No more machines are connected to the old server.

Answer 3

Hi,

Databases are different as you said. First is from ocs 1.x version and second from 2.x ? If so it couldn't be merged because structure is different.

Regards

Frank

Answer 4

Hi,

The database is 2.x.

Regards,

Joc

Answer 5

i wonder if it isn't enough to just export all computers on the old server and then import all the computers in the new server.

here is how to export a computer

https://wiki.ocsinventory-ng.org/04.Management-console-and-its-advanced-features/Export-a-computer/

mass Import maybe possible with a perl script

http://wiki.ocsinventory-ng.org/03.Basic-documentation/Administration-of-OCS-Inventory-NG/

serach for

With Communication server through a Perl script

Kind regards

sokatra

Answer 6

Yes, that’s exactly the problem. I can't mass relocate workstations. It would be good to have a mass export opportunity.