Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Enhancment - Allow Drop Database Script To Be Specified #67

Open
GoogleCodeExporter opened this issue Mar 14, 2015 · 1 comment
Open

Comments

@GoogleCodeExporter
Copy link

RoundhousE provides several options for customizing the process of creating a 
database. You can specify a particular script, and there is a folder for 
scripts to be run immediately after creation. This is very useful, especially 
if you need to redeploy the database, which happens fairly often during 
development.

However, for some databases, RoundhousE is unable to drop the "database". This 
makes sense, actually. Different database technologies have different concepts 
of what constitutes a database. In SQL server, one usually considers the 
"database" to be the physical file and all data associated with the file. 
Things like users are external, and schema can be used to logically organize 
the database. Oracle, on the other hand, associates users with a particular 
database and treats each user also as a schema. This has the effect of the 
conceptual "database" usually being thought of as an individual schema. In the 
technologies I've worked with, it is a relatively simple process to script the 
drop, but the drop must be performed by another tool since users can't override 
how RoundhousE performs the drop. This forces RoundhousE users to build up a 
significant amount of infrastructure to automate redeployment and to depend on 
extra tools that otherwise would not be needed.

Original issue reported on code.google.com by [email protected] on 3 Dec 2011 at 11:37

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant