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.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

closed as off-topic by Paul White, RolandoMySQLDBA, RLF, Michael Green, dezso Jan 26 '15 at 13:08

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Paul White, RolandoMySQLDBA, RLF, Michael Green, dezso
If this question can be reworded to fit the rules in the help center, please edit the 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:… – 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