Re: RE: Scripting for change with Team Coding
Norman Dunbar <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <[email protected]> |
Hi Timothy,
> When you say "DBA Option", what are you referring to?
Help->About. That lists all the add-ons that your license for Toad
covers. The DBA option has the ability in it to create a script from the
output of Schama Compare. Without the DBA option all you can do is look
at the differences and try to manually resolve them.
Mine says "Add-ons: DB Admin Module, SQL Optimizer".
> We do not have the ability to run anything against QA or Production,
only dev.
That makes sense to be honest. But it will make running the schema
compare difficult if you are not able to access production. :-(
> It is our
> responsibility to manage the change in Dev and then schedule a
> deployment along with an appropriate script to execute in QA or
> Production via the DBA team. What I need to be able to do is find all
> changes within the Dev database since a given version / revision in the
> repository and create a script to give the DBA's for execution to QA and
> later to Production.
I understand. You mentioned that you use Subversion as well as team
Coding (or are you using Subversion as your Legacy team Coding system?).
I would think about looking at your Subversion logs to see what changed
"recently" and maybe, the "svn diff" command will enable you to do some
scripting work?
It's a bit difficult to find out exactly what has changed between fixes
if you don't have a schema still at the base level to compare it with.
--
Cheers,
Norm. [TeamT]
------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)
<*> To change settings via email:
[email protected]
[email protected]
<*> To unsubscribe from this group, send an email to:
[email protected]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/