MSBuild: Automate Collecting Of Db Migration Scripts?

May 20, 2010

Asp.net web application (source stored in svn) sqlserver database. (Database schema (tables/sprocs) stored in svn) db version is synced with web application assembly version. (stored in table 'CurrentVersion')CI hudson server that checks out web app from repo and runs custom msbuild file to publish/package app.

My msbuild script updates the assembly version of the web app (Major.Minor.Revision.Build) on each build. The 'Revision' is set to the currently checked out svn revision and the 'Build' to the hudson build number (incremented on each automated build).

This way i can match the app to a specific trunk revision also get other build stats from the hudson build number.

I'd like to automate the collecting of migration scripts (updated sprocs etc) to add to the zip package. I guess by comparing the svn revision of the db that has yet to be deployed to, to the revision being deployed, i can find what db files have changed in the trunk since the last deployment to that database/environment.

This could easily be achieved by manually calling the svn diff -r REVNO:REVNO command to list changed .sql files. These files could then manually have to be added to the package.
It would be great if this could be automated.

Firstly i'd imagine I'll have to write a custom task to check the version of the db that has yet to be deployed to. After that I'm quite unsure. how this would be achieved through an msbuild task either existing or custom?

Finally I'll have to autogen a script to add to the package that updates the database version table so as to be in sync with the application.

View 3 Replies


Similar Messages:

C# - Collecting Useful Server Information?

Mar 8, 2011

I want to add a page to an existing website with a list of practical system information about the server that's running the site. For example, which windows version, 32 or 64 bits, SQL Server version, some host variables, amount of RAM, disk space and whatever else. Basically, anything practical that could tell me more about the health of the server. So, how do I get the most practical information through .NET?

Not important how it's going to be displayed but assume it's a list with three columns: Name of the setting, value for the setting and a description that tells what the setting is for... (The first two would already be enough, though, but for clarifications a description would be nice.)

One added complication, though: I need both 32-bits and 64-bits solutions...

View 3 Replies

Collecting Data From Checkboxlist?

Jan 22, 2011

I have a checkboxlist inside of a wizard control. I need to collect the value of all items that are checked, as well as whatever value is inside of a textbox if "other" is checked, to insert into my database during the Wizard.FinishButtonClick event. How do I do this?

View 1 Replies

Web Forms :: Collecting Payment Using Paypal?

Oct 8, 2010

I have a website which I want to use to collect payments from customers. An essay writing service is provided through the site.User's fill in a form and submit it. At the moment, when the form is submitted, it just fires an acknowledgement to the user that their order is being processed.I have used ASP.Net/C# for the web applicatioHow do I integrate paypal in the website so that user's can make paymen

View 1 Replies

Building A Web Application Using Msbuild?

Dec 10, 2010

I have a web application solution with 14 projects which include web services, class libraries, sub-web applications.. can anyone provide a solution on how to get along with an example?

View 1 Replies

Compile A MVC Project Using MSBuild?

Feb 3, 2010

How do I compile an ASP.Net MVC project using MSBuild? We use a Continuous Integration server to compile and deploy our applications. To keep things simple I created an MVC 1.0 project in VS2008. I immediately created an MSBuild script file to compile it. I did not change any code in the project. The MSBuild script contained the following target.

<AspNetCompiler
VirtualPath="/"
PhysicalPath="C:Developmentmvc1"
TargetPath="c:publishxxx"
Force="true"
Debug="false"
Updateable="true"

The MVC project sln file is contained in the c:developmentmvc1 directory.I am running XP/Pro.I am receiving an error ASPCONFIG: it is an error to use a section registered as allowDefintion='MachineToApplication' beyond application level.

I removed the authenication mode, membership provider, etc. from the web config file until I finally saw a different error message.I am now receiving an error message saying that the file '/views/shared/site.master' does not exist.

View 3 Replies

Building A .net 1.1 Project Using Msbuild?

Dec 7, 2010

The Web project we are working on is built against .net 1.1 framework.We would like to automate the build process for this project by using msbuild.However MSBuild only targets 2.0 framework. So how can this be done if we like to use MSBuild or MSBEE(this asks us to convert the web project to new version by opening up in Visual studio IDE)?We cannot convert the project to suit to 2.0 framework

View 1 Replies

Get MSBuild Output From CCNet Api?

Jul 16, 2010

I am building an asp.net shell on top of CCNet 1.5, where I send commands like force build to CCNet through the api. The ThoughtWorks.CruiseControl.Remote namespace has methods to get information from CCNet on the build, like status, elapsed time, etc.I would like to programmatically get the MSBuild task output from the CCNet api, but I haven't seen any methods for this. Is it at all possible? Or do I need to scan output files on disk or something?

View 2 Replies

Web Forms :: How To Write Data For Collecting Sql Database

Jan 12, 2011

I want to write the above form data to a sql server database

View 2 Replies

C# - Collecting Extra Information Using Dot Net's Standard Authentication

Apr 3, 2011

I'm using the inbuilt dot net authentication to register users in a simple web site and trying to add some extra information to be collected on registration. It currently asks for Usernname, email, password, confirm password. I'd like to add some extra bits, something like "favourite colour" - just a simple stringIs there an easy way of doing this? Maybe a simple tutorial I could follow?

View 2 Replies

Retrieve The Full Output From A Web Application With MSBuild

Jan 12, 2010

I have a misunderstanding with MSBuild. I want to build a web application (with a traditional .csproj project file) and get the "entire output" of the build in a new, clean output folder - including all the website files that are included in the project with <Content Include="....

The AspNetCompiler utility makes this easy for "web site" style projects - you specify the input folder and the output folder, and they can be entirely different.

So far I've only had success specifying the OutoutPath folder, i.e. moving the bin folder - but this only gives me the binaries and ignores aspx, image files, etc.

View 1 Replies

How To Use Nant And MSBuild To Build Debug Deployment

Jun 17, 2010

I have a Nant build script which referrences 30 other build scripts.

Each build script referrences a visual studio solution using MSBuild.

Each solution has 3 to 5 projects in.

Some projects are Class Librarys and some are Web Apllications.

The projects reference other projects both in their solution and out of their solution, so the projects do not use project references, they reference the the Release DLLs in the Bin folders of the other projects.

To use the software, I need to publish all the solutions together.

Which means I cannot do a deployment which is in debug mode.

Which means I cannot the step into and debug the code.

I would like to run the build script to get a deployment of the software which I can debug.

View 1 Replies

Configuration :: How To Use Msbuild To Create MSI Files Or Setup

May 27, 2010

I want to Use MSBUILD to create MSI Files or setup. Can I do it programetically.

View 1 Replies

Forms Data Controls :: Collecting A Variable That's Being Crossed Via Postback Url?

Dec 2, 2010

I'm fairly new so I've been learning via examples. The idea of this part of the project is to present a list of items (out of a DB), and when you click on an image that's on the list, it should open a new window with the details. this is the snippet where

I send the variable:

<asp:ImageButton runat="server" ID="imagebutton1" ImageUrl="images/icon_lupa.gif"

View 3 Replies

Visual Studio :: Unable To Use Web Deployment MSBuild V10 With AspNetMerge .NET 4

Jul 8, 2010

I am using Web Deployment v10.0 RTW and .NET Framework version 4.0 MSBuild.

There were some problems with incorrect settings and resulting in errors. I had to pass in my own values in order to continue to the next step:

[Code]....

With the above setting, it builds in .NET 4.0 instead of 2.0, but I am having trouble with AspNetMerge:

[Code]....

I was able to solve the above error by changing this inMSBuildMicrosoftWebDeploymentv10.0Microsoft.WebDeployment.targets:

[Code]....

But soon came to another error:

[Code]....

So I changed some more to make it work:

[Code]....

But again hit with another error but this one I can't solve:

(AspNetMerge target) ->

aspnet_merge : error 1008: The PrecompiledApp.config file is missing. Make sure the application has been precompiled with the Aspnet_compiler tool.

View 3 Replies

How To Setup A Development Environment Using Msbuild And Continuious Integration

Jul 6, 2010

I need to set up a developement environment using msbuild and continuious integration, NUnit etc. I am quite new to this kind of thing as it is normally already set up in most environments ive worked in. I am quite short of time as well and dont have have the time to read huge volumes in order to get an understanding (developement starts Monday next week) so need to get this up and running asap in the shortest possible time. Does anyone have a working sample I can utilise or a short tutorial that breaks this process down?

View 1 Replies

Installation :: Include An External Script For Execution In MSBuild.exe?

Mar 3, 2011

I have onle xml file which contain msbuild tags, means few task and I want to execute this file rather then .csproj file.

View 2 Replies

C# - Operate With Html RadioButtons. Validation , Checking If Checked, Collecting Values?

Mar 24, 2011

I'm trying to make a .Net, c# application for online creating surveys. I have a few types of questions, and than I dynamicly put labels, combos, textboxes ... on the form. Up to this point, I somehow managed to get. Than, on click on add button, I write down the responses in html format using stringBuffer and append function. Example.

public string RetOptionalQuestion(string seq_numm, string question, string answersOpt)
{
StringBuilder _output = new StringBuilder();

[code]...

View 1 Replies

Migration From .NET1.1 To 3.5?

Mar 7, 2011

I am currently using .NET 1.1 but my client wants to move application from .NET 1.1 to .NET3.5. So client wants know how they will be benifited if migrate from 1.1 to 3.5.

What are the benifits of 3.5 over 1.1 for clients who is using that application?

View 3 Replies

Configuration :: Migration From IIS 6.0 To IIS 7.5?

Jan 31, 2011

While migrating from IIS 6.0 to IIS 7.5, what changes do i need to make in IIS in order to get windows authentication working correctly.

My Application is in .net 2.0.

View 1 Replies

MSBuild Failing To Build Referenced Projects When Upgrading To VS2010?

Dec 8, 2010

I have recently upgraded my .Net 3.5 solution containing some C# code projects and a ASP.net web site project to VS2010 (from VS2008). It is building and running fine inside VS, but I get some problems when trying to build it on my server with MSBuild 4.0 via TeamCity. It seems like the projects that are referenced from the web site are not built. This was all working fine before I upgraded to VS2010, MSbuild 4.0 and Windows SDK 7.1.

Inside the msbuild script that I use to build from teamcity I have defined project references for the web site like this:

[code]...

When I try to run the build script I get an error message saying that it could not find the dll file when trying to copy it from the bin folder of the referenced project into the bin folder of the web site. This is happening because the referenced projects are in fact never built at all (No bin folder exists in the project dir).

I am not very experienced with MSbuild, so I may have overlooked some important stuff. Is it not so that MSbuild will automatically try to build the referenced projects if no project output is existing?

View 1 Replies

Building A Project With MSBuild Which Has Only Class Files Without A Main Method?

Dec 7, 2010

I have a project which contains only .vb files. It doesn't include a suitable main() method to detect the entry point?

View 1 Replies

How To: Automate - Email User Their New Pwd

Jun 21, 2010

I have an asp shopping cart and when purchased I want to automatically send the user their login ID and pwd using ASP/VB.

View 12 Replies

Automate The Running Of A SQL Query?

Mar 16, 2011

What should i research in order to accomplish this task?

I am using MS-SQL & VB.Net

I have a SQL table that stores startdate and enddate. I want to run a query on that table every 10 minutes in order to check if the enddate is greater than today and if it is I would like to add a 1 to another column if it is not I would like to add a 0.

View 3 Replies

Paypal And IPN.. How To Automate Payment ?

Jul 6, 2010

i'm trying to integrate Paypal in an asp.net app. It works fine, the last thing i would like to do is to automize payment notify.

In particular, how does it works IPN ? I would like to set a field to 1 when a user buy a service... How can i do with ipn ?
I'm asking here to avoid to read all 120 pages of paypal IPN documentation... ;)

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved