RE: Versioning software

  • From: "Marquez, Chris" <cmarquez@xxxxxxxxxxxxxxxx>
  • To: <Paula_Stankus@xxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 2 Jul 2005 08:59:11 -0400

Paula,

Agreed, it is not for scripts (versioning) really, but has the capability (like 
nay ER tool) of generating SQL "scripts" from the metadata.

Also, depends how you define "scripts", or "code", but one could put thier 
PL/SQL, PROCS, TRIGGERS (code) *in* ER/Studio (for versioning/safety) even 
though the code was written outside of ER/Studio...it is a repository.

Again, I found it to be DB ER tool 1st, CM, VM tool 2nd.

hth

Chris Marquez
Oracle DBA


-----Original Message-----
From: Paula_Stankus@xxxxxxxxxxxxxxx [mailto:Paula_Stankus@xxxxxxxxxxxxxxx]
Sent: Sat 7/2/2005 7:03 AM
To: Marquez, Chris; oracle-l@xxxxxxxxxxxxx
Subject: RE: Versioning software
 
Chris,

Yes, I get the impression ER/Studio is a versioning tool for data models, 
metadata but not necessarily for scripts, DTS and a little cumbersome even for 
versioning sp's. 

-----Original Message-----
From: Marquez, Chris [mailto:cmarquez@xxxxxxxxxxxxxxxx] 
Sent: Saturday, July 02, 2005 12:52 AM
To: Stankus, Paula G; oracle-l@xxxxxxxxxxxxx
Subject: RE: Versioning software

Paula,

I (had to) use Embarcadero ER/Studio on my last gig.
I learned to like it, but sometimes spent time doing things over...check-in, 
check-out was little painful and unruly.
It was much more a Data Model tool than a versioning tool (IMHO).
*When* maintained and entered correctly it would generate some nice complete 
DDL of the project for the database and save us from manual script maintenance 
and put the pressure on everyone to put/keep our stuff in the tool or else.
Didn't do GRANTS well or at all, but it have once nice feature was a "RUN THIS" 
option.  Anything that it could not generate at least could be included in the 
model.

hth

Chris Marquez
Oracle DBA



-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Paula_Stankus@xxxxxxxxxxxxxxx
Sent: Fri 7/1/2005 9:25 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: OT:  Versioning software
 
W e are considering Embarcadero, Subversion, VSS and Clear Case for versioning 
DBA work:
 
triggers
sp's
functions
ddl
data models
project plans ????
unix scripts
windows scripts
 
For multiple RDBMS environments.
 
Any suggestions?
 



Other related posts: