The present application is directed towards systems and methods for automatically transforming reporting and view database schema during upgrading of a system from a source installation to a target installation. An analyzer executed by a processor of a client device may identify an application of a source installation configured to process a first one or more objects of the source installation. The analyzer may determine that the first one or more objects are modified during upgrading or transformation of the source installation to a target installation. The analyzer may generate a mapping between the first one or more objects of the source installation to a second one or more objects of the target installation, responsive to the determination. A transformer executed by the processor of the client device may modify a schema of the application, according to the generated mapping.