Tailored Option For Deploying Database For Varied Environments In Asp.net Development

Here this article displays the method to customize the properties of a database for

multiple desired environments for deployment purpose in ASP.net development. For ASP.net developers deploying a Visual Studio 2010 database project with the use of MSBuild(dot)exe and VSDBCM(dot)exe the entire process is meant. When there are multiple environments in picture you might often require customization of properties for each target environment. When VS 2010 is in use then the settings have configuration file. Here the topic describes the method of building environment-specific deployment configuration files and specify the one that you wish to use as a parameter.

Roundup with the job:

Here the topic in ASP.net development for deployment assumes that:

* ASP.net developers are using split project file approach to solution deployment

* Developers call VSDBCMD from the project file to deploy your database project

For building up a deployment system for supporting varied properties for desired environments ASP.net developers would have to:

* Build a deployment configuration file for every targeted environment. For example:- .sqldeployment

* Perform the VSDBCMD command which will describe the deployment configuration file as a command-line switch

* Parameterize the VSDBCMD command where the MSBuild lies so its options will be suitable for the desired environment

ASP.net developers India are profound in doing so & here there is a better description to detail the procedure.

Creation of environment-specific deployment configuration files

As a default setting the project will have a single configuration file for deployment with a name as Database(dot)sqldeployment. While opening this file in VS2010 there would be various visible deployment options like:

* Deployment comparison collation: Here you get a choice if you wish to use database collation of your project or the one of your destination server. Most probably you will wish to use the source collation at the time of deployment state or while testing period. If it is deployment for a staging or production environment then the target collation should not be modified so in order to eliminate the interoperability problems.

* Deployment of database properties: Here you can select if you wish to apply the properties as defined in the file. If it is a deployment for the first time then the properties are advised to be deployed. If it is the case of existing one then properties should lie in their place and need not deploy them again.

* Never skip re-development of database: Here you can select to re-create the target database each time you deploy or perform incremental modifications to bring the target database up to data with the schema. When you choose to re-create there will be loss of data in the existing db. Here you need to set it false for deployments to staging or production environments.

* Stop incremental deployment in a situation of data loss: Here you get a chance to jump in between to protect your vital information so set this to true.

* Switch execution of deployment to single user mode: Also here the setting must be true so you can make changes to database while on the way to deployment.

* Secure with back up before moving further with deployment.

* Produce DROP statements for objects that do exist in targeted zone

* No need to use ALTER ASSEMBLY statements for up-lift of CLR kinds

by: D N Talaviya

POST COMMENT

Hiring Professional Engineers For Environmental Testing Solar Hot Water Taking Things For A Green Environment Incontinence Pads For A Healthier And Safer Environment Keeping A Cool Working Environment Can Improve Efficiency And Productivity Dust Collectors For Managing Environment Awareness Regarding Eco-friendly Environment Has Been Initiated By Briquetting Plant Manufacturers Environmental Issues With Global Warming Reasons Why Plastic Recycling Is Considered Better For Environment 6007 Reference Guide For Avaya Agile Communication Environment(tm) Implementation Exam Guide Through Environmental Permits Indoor Air Quality Is Part Of A Healthy Work Environment Mining Machinery Should Focus On Environment Maximizing Server Uptime With Secure Environmental Monitoring