Patent ID: 7689565

Claim:
A method of synchronizing a staging database with a production database, the method comprising: receiving a dataset for storing in a staging database, the dataset containing storage area network (SAN) management data collected from a managed resource of a SAN wherein receiving the dataset comprises; serially receiving a plurality of partitions from an agent operating in a storage area network, each partition containing a respective portion of data for the dataset collected from the managed resource operating in the storage area network, the plurality of partitions received as partitions due to large amounts of data collected from the managed resource by the agent; storing the dataset in the staging database wherein storing the dataset in the staging database comprises: storing data from each partition into the staging database while the staging database is unsynchronized with the production database and the production database is in a read-only mode, and verifying success of storage of data from each partition to indicate completion of receipt of all data from the dataset; maintaining a changeset identifying changes made to the staging database during the step of storing the dataset; and synchronizing the staging database with the production database using the changeset wherein synchronizing the staging database with the production database comprises: determining that success from all partitions in the data has occurred indicating the an entirety of the dataset is present in the staging database prior to synchronizing the staging database with the production database wherein the production database is in a read-write mode during synchronization.