We are using PeopleSoft app designer tool to manage and create projects, database objects - tables, columns, views etc in Oracle database. This tool has limitation that we cannot create tables/columns with name greater than 18 characters in length and it also forces PeopleSoft not null concept for all columns (automatically generates scripts to stores ' ' and doesn't have option for creating null columns). We are looking for similar tool with repository that stores and allow us to create projects, columns (check if column already exists before adding and reuse it), tables without any limitations and use projects to build scripts for migration.
Does anyone know any software or tool that has similar features? We are looking for repository based tool that will store projects and database objects.