Hi Samad:
First of all, upgrading a CA PPM instance can very tricky if you skip recommendations of the main upgrade documents: Release Notes (CA PPM 14.4 Release Notes (On-Premise) - CA PPM - 14.4 - CA Technologies Documentation) and Change Impact & Upgrade ( Change Impact and Upgrade (On-Premise) - CA PPM - 14.4 - CA Technologies Documentation ). I assume you have an On Premise instance.
Did you backup your database before the upgrade? Did you perform the 14.4 installation in a non-productive environment? This is strongly recommended in order to identify and assess possible impacts of the upgrade.
What is your architecture? I can tell you some experiences on Windows and MS SQL Server.
When you installed the 14.4 version the command line should have asked you for the existing CA PPM instance (in this case, 14.2) and to decide whether you wanted to preserve the current folder or use a new one. This decision only affects the location of CA PPM in the application server's file system, but does not affects the database. In one of the first steps of the installation process, it performs a Health Check to validate the CSA (formerly NSA) parameters. If the database was not found or has a incorrect version, it will stop right there.
This validation is very important because it assumes that the base components of the architecture are already upgraded if necessary (specially the Operating System and the Database Engine versions). During the upgrade, the CA PPM executable will not change your SQL engine version (for example: from SQL Server 2007 to SQL Server 2010), but it will drop tables, create tables, add columns, Stored Procedures and any other database change that the new CA PPM 14.4 release requires.
Also, be careful when installing a second instance in the same server. The install executable should be able to detect the current CA PPM instance in order to perform the upgrade. If not, it will just add a completely different CA PPM instance (which is totally discouraged) without any relationship with the first one, and will not touch the original CA PPM database.
Regards
Juan