ZSD ZENworks Integration (or AMIE) process when Database moved to another platform

   Take a backup/snapshot of the files, system and database before any changes.

   Record what changes or customization was done in your Corporate ZSD Documentation.

   Some File modifications may not carry forward for the subsequent Side-By-Side upgrades.

In this case the database was moved from internal Sybase to internal PostgreSQL.

Make note of the Imported items and their settings - Hardware, Software, Bundles, Mobiles.

Have a full backup of the database and Appliance.

Set up Hardware Item Reconciliation on Serial Number.
Make note of the Integration Settings for each of the selected Categories: Hardware, Software, Bundles, Mobiles

Reconfigure the Database Communication.

Example:
ZCM ZONE internal Sybase Database = 192.168.1.27

After ZENworks Database migration

ZCM ZONE internal PostgreSQL Database = 192.168.1.27

Check your Import Settings under each of the Tabs - Hardware, Software, Bundles, Mobiles

Only those Item Categories checked will have Tabs above.

Example of Hardware:

Make sure Reconcile Based On is configured to the attribute that is unique for Hardware.
This way the Items imported will reconcile with the new database and not create duplicate Items. 
Database "Item" table FIELD_10 = Serial Number and is commonly used as this unique variable.

User > Configuration > Categories > Hardware | Edit

Select Serial Number

Check box Unique Value  > Save

In the Reconcile Based On dropdown select  "Serial Number'

Select Done

Review your current configuration

[Setup] > Setup > ZENworks > ZENworks Import (Tab)

Select the ZENworks Server to change configuration - 192.168.1.27