| Author |
Topic |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2009-02-19 : 10:19:26
|
| Our deployment team doesn't have DBA rites to prod. They are not supposed to know the admin credentials. We use a tool, tqcrunas.exe which wraps admin credentials and builds an exe file. The deployment team executes this exe on prod. Is there a better approach? Are there any such similar tools?------------------------I think, therefore I am - Rene Descartes |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-19 : 12:19:05
|
quote:
Originally posted by ravilobo
Our deployment team doesn't have DBA rites to prod. They are not supposed to know the admin credentials. We use a tool, tqcrunas.exe which wraps admin credentials and builds an exe file. Please elaborate on this. The deployment team executes this exe on prod. Is there a better approach? Are there any such similar tools?------------------------I think, therefore I am - Rene Descartes
|
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2009-02-19 : 12:32:28
|
quote:
We use a tool, tqcrunas.exe which wraps admin credentials and builds an exe file. Please elaborate on this.
In lay terms, 1. Tqcrunas is a small GUI based application2. This GUI app, accepts any executable command with parameter (e.g. sqlcmd -Sservername -Uuser -Ppwd)3. When you save an out file gets created (out.tqc)4. You give the out.tqc file (which is encrypted) to the deployment team5. Deployment team would just double click out.tqcHope this helps.------------------------I think, therefore I am - Rene Descartes |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2009-02-19 : 12:37:16
|
quote:
]Who do they call when it errors and they don't have the proper rights to fix it?
An error log gets created. Which will be sent back to us. We check the error and send a fix in a new tqc file.------------------------I think, therefore I am - Rene Descartes |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2009-02-19 : 12:51:33
|
| some more info..We have around 1000 stores. Each store is a production site for us. Each store has a support team, which is not an admin team. There is a need for separating DBA team and deployment team. Though I can remotely logon to each server, I am not supposed to do deployment because of the massive number of servers.------------------------I think, therefore I am - Rene Descartes |
|
|
|
|
Production deployment by lay users