Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question
    
Are the projects you're working on for PeopleSoft applications? Perhaps the PeoplSoft tool has the constraints because they are needed for other PeopleSoft applications/frameworks. If you just need something for plain old Oracle applications, you could look into Oracle SQL Developer: oracle.com/technetwork/developer-tools/sql-developer/overview/… –  FrustratedWithFormsDesigner Jan 21 '13 at 16:04
    
@FrustratedWithFormsDesigner, we are using it for Oracle based Projects –  rs. Jan 21 '13 at 16:13
    
Then I'd suggest starting to look at Oracle SQL Developer (linked above). There are other tools as well, but that one is made by Oracle so any limitations probably parallel what the database actually supports (rather than limitations from other vendor software). Just curious: Why were you using PeopleSoft tools to develop software that was not interacting with PeopleSoft software? –  FrustratedWithFormsDesigner Jan 21 '13 at 16:17

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.