Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

Installing and creating databases from an empty db created by the DBA

Created: 13 Oct 2009 | 1 comment
GertjanA's picture
0 Agree
1 Disagree
-1 1 Vote
Login to vote

I'm not too sure on how to describe this, but I assume the developpers will know what is ment.

I've had a lengthy discussion (or actually I listened, they talked) with the SQL-people.
The complained about the VSA needing to have db-creator rights when installing EV, DA, etc.

They asked why Symantec is not following the MS-way, which seems to be to install an empty databases (done by the dba's) from which the rest is derived.

I believe this is what I understand they mean.

1/ database admin will create and empty database (no tables in it)
2/ EV-installer will connect to this empty database and create needed tables in it
3/ EV-installer creates other db's

They claim this is the MS way of doing it, actually they say: a well written installer for a product using sql should do this.

Could this be looked into? I am sure more dba's would be happy. I'm lucky to be able to convince them they will be shot if they do not let me use EV to create db's....

Thanks

Comments

JesusWept's picture
02
Nov
2009
0 Votes 0
Login to vote

The EV Installer creates

The EV Installer creates other db's? so it would still need db creator rights?
The idea behind the the configuration utilities is so that there is the least amount of interaction needed with the DBA's

but what would really help is if you had any MS documentation that suggests this is best practice