Comments posted to this topic are about the item Distributing SQL Server Databases
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 L Reid
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.
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.
Viewing 4 posts - 1 through 3 (of 3 total)