Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Distributing SQL Server Databases Expand / Collapse
Author
Message
Posted Sunday, October 21, 2007 11:57 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 8, 2013 7:23 AM
Points: 199, Visits: 136
Comments posted to this topic are about the item Distributing SQL Server Databases
Post #413266
Posted Tuesday, October 23, 2007 8:04 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, September 9, 2013 8:32 AM
Points: 108, Visits: 166
A great article for its purpose - well done.

A note, however, that software vendors should not assume that they will be permitted server admin access to a data server to install their app. It is worthwhile to have this as one option, for the shops that don't really manage their servers.

In better managed situations, people like me will not permit vendors to use server admin for any purpose. I will go ahead and set up the db according to your specs, and give it to you with dbo access: you can do anything you want inside the boundaries of your db, but no special privs on the server.

Otherwise, I have no way to verify the security of the other databases.

Again, not a criticism of the article! But a warning to those who would use it - to do it appropriately.

roger reid


Roger L Reid
Post #413938
Posted Sunday, April 13, 2008 10:26 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, April 13, 2008 10:22 PM
Points: 1, Visits: 2
Hello.

Your only work if you build a desktop application,
if i'm decide to build a web application,
do you have any idea to solve my problem.

thank you
Post #484218
Posted Tuesday, April 15, 2008 8:21 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 8, 2013 7:23 AM
Points: 199, Visits: 136
Hi,

Database for a web application can be installed using the same technique. You will be creating a setup for you web-site. So, integrating the logic of Installer class, including the sql script files in the web-site setup and executing the scripts will allow you to install your database.

If you take my suggestion, installers for database should be separate from your application/website. It is good to integrate all the tasks in one setup, but looking forward in terms of maintainability, it is not recommended.

Vasant.
Post #485060
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse