DCSIMG
December 2007 - Posts - Maor's Blog

December 2007 - Posts

מחפש אתגר מקצועי? בוא אלינו

אם את/ה מחפש/ת אתגר מקצועי, חברה דינמית וצעירה ועבודה בסביבה טכנולוגית אנחנו מחפשים אותך:

לתפקידי ייעוץ בתחום ה ALM דרושים מועמדים עם:

clip_image001

  • נסיון רב בפיתוח בסביבת NET. בעלי 3-5 שנות נסיון לפחות
  • הכרות עם סביבת Team System – יתרון
  • סביבה טכנולוגית: Team system, Visual studio 2005, .NET

לתפקידי פיתוח דרושים:

  • בעלי ניסיון של שנתיים לפחות בפיתוח ב- Net.
  • ניסיון של שנה לפחות בפיתוח ב- Net 2.0.
  • היכרות טובה עם עולם ה WEB - יתרון

אם אחד התפקידים מעניין אותך, אנא שלח/י קורות חיים ל: maor AT srl.co.il

 

Visual Studio Team System 2008 Team Foundation Server MSSCCI Provider

The Visual Studio Team System 2008 Team Foundation Server MSSCCI Provider enables integrated use of Team Foundation Version Control with products that do not support Team Explorer integration. You can download it from here.

This version (1.2) includes:

  • Enable handling branched solutions in Visual Studio 2003.
  • Fixed issues to enable provider to support Toad for SQL Server 2.0.
  • Enhanced the "Choose Folder in Team Foundation Server" dialog.
  • Fixed bug which prevented Properties Dialog from displaying local path.
  • Work Items Query list in the Checkin Dialog is loaded and saved on the disk.
  • "Get" operation performance improvements.
  • Defect fixes

Download MSSCCI provider for VSTS 2008.

Team Foundation Power Tools for VS2008

Ed Hintz just announced the Team Foundation Power Tools for VS2008 are now available:

The Team Foundation Power Tools for VS2008 are now available here.  This is the first release of the Power Tools that work with VS2008.  We did not want to just deliver a warmed over version of the VS2005 Power Tools, so we included lot of new goodies in this release.

It includes:

  • Find In Source Control
  • Quick Label
  • Process Template Editor
  • Open in Windows Explorer
  • Team Build Notificationapplet
  • More commands...

Click here for download.

What Is Your TFS Configuration?

The VSTS team are working on some test planning for the next release of Team Foundation Server. One area they’re focused on is testing various possible configurations of TFS.

MS is trying to get a picture of the variety of ways that people have their TFS installations configured.  Read Chris's blog post on what they are doing and why. There is a short survey (10 questions) with no need to provide any sensitive data. Fill it out and help them to make sure that the configurations they test map to ones actually deployed ‘in the wild’. If you own or manage multiple TFS deployments, you can fill out the survey once for each.

So go and fill out the 10-question survey here for each deployment you have.

Recordings From Dev Academy 2 Available

If you want to see the sessions from Microsoft Developers Academy 2 you can do it. 

Enjoy!

DevAcademyII

No Scroll Bar In The Data Dude Schema View

You won't find it.

There's no horizontal scroll bar in the schema view window like there is in the solution explorer (or other views).

The problem relevant for VS 2005 as also VS 2008.

scroll

Custom Build Number In Team Build

Many users want to modify the default build number of Team System Team Build which looks like: <Build-Type-Name>_<Date>.XXX.

You can change it by writing a custom task and call it in the BuildNumberOverrideTarget target of the MSBuild file. In this example the task will generate a unique build number based on current time:

using System;
using Microsoft.Build.Utilities;
using Microsoft.Build.Framework;

 
namespace MaorDavidBlog.Samples.MSBuild
{
    public class BuildNameGenerator:Task
    {

        private string _buildName;

        public override bool Execute()

        {            
            _buildName = DateTime.UtcNow.ToString();
            return true;
        }



        [Output]
        public string BuildName

        {
            get { return _buildName; }
        }

    }
}

The attribute “Output” indicates that BuildName property is output of the custom task.

Then, register the task in TFSBuild.proj file.

<!-- Add using task line just after import statement - - >
<UsingTask 
 TaskName="MaorDavidBlog.Samples.MSBuild.BuildNameGenerator"  
 AssemblyFile="$(MyCustomTasks)\MaorDavidBlog.Samples.MSBuild.dll"/>



<! -- Override the target towards the end of proj file - - >
<Target Name = "BuildNumberOverrideTarget" >
    <BuildNameGenerator> 
            <Output TaskParameter="BuildName"
            PropertyName="BuildName"/> 
    </BuildNameGenerator> 
</Target>

 

Next time you'll execute your build, you'll see your custom build name.

Copy WildCards With MSBuild

I got today hysterical message from a good friend that implementing in his company automatic build with Team System. The message was: "Maor, How can I copy wildcards With MSBuild? Please help!!!".

Okay. What you should do my dear friend is:

1. Create an item list if you have more than one file to copy. You can do it with the CreateItem task:

<CreateItem Include="$(MyDir)\*.*">
    <Output TaskParameter="Include" ItemName="MyFilesToCopy" />
</CreateItem>

2. Copy!

<Copy SourceFiles="@(MyFilesToCopy)" DesginationFolder="$(MyPutputDir)" />

3. Execute your build script.

Ah, by the way, if you want to recursively copy files using the <Copy> task, read this post from MSBuild Team Blog.

Enjoy!

Automatically Compare Data and Schema Using MSBuild and Data Dude

VSTS for DB Professionals (aka "Data Dude" or "VSDBPro") provides great tools for schema and data compare.

Like most Visual Studio-based project systems, the core tasks inside the VSDBPro project implemented as MSBuild tasks. The two core activities for Database Projects (.dbproj), “Build” and “Deploy” are implemented by two MSBuild tasks named “SqlBuildTask” and “SqlDeployTask.”

Sometimes, we also need to automate the schema and data compare processes. We can do it with new MSBuild dedicated tasks that shipped with Power Tools for Data Dude: (Currently available for VSTS 2005)

  • SqlDataCompareTask: allows you to compare the content of tables within two databases from the command line using MSBuild
  • SqlSchemaCompareTask: allows you to compare schemas between two database from the command line using MSBuild

How should you use it?

First, install the Power Tools. Download from here. (notice that the power tools requires Data Dude Service Release 1 installed).

After you installed the power tools you can use the tasks in your MSBuild script.

Example:

  <!--Import the settings-->
  <Import Project="$(MSBuildExtensionsPath)\Microsoft\VisualStudio\v8.0
 \TeamData\Microsoft.VisualStudio.TeamSystem.Data.PowerTools.Tasks.targets"/>

  <Target Name ="DataCompare">
    <SqlDataCompareTask
       SourceConnectionString="Data Source=(.);Integrated Security=True;Pooling=False"
        SourceDatabaseName="SourceDB"
        TargetConnectionString="Data Source=(.);Integrated Security=True;Pooling=False"
        TargetDatabaseName="TargetDB"
        OutputPath = "$(temp)"
        OutputFileName = "DataCompare.sql"/>
  </Target>

Notice that the task does not allow you to compare against the project right now. Same way you can use the SqlSchemaCompareTask.

<Import Project="$(MSBuildExtensionsPath)\Microsoft\VisualStudio\v8.0
\TeamData\Microsoft.VisualStudio.TeamSystem.Data.PowerTools.Tasks.targets"/>
<Target Name ="SchemaCompare">
    <SqlSchemaCompareTask
    SourceConnectionString="$(SourceConnectionString)"
    SourceDatabaseName="$(TargetDatabase)"
    TargetConnectionString="$(TargetConnectionString)"
    TargetDatabaseName="$(TargetDatabase)"
    OutputPath = "$(IntermediateOutputPath)"
    OutputFileName = "$(TargetDatabase)SchemaCompare.sql"
    IgnoreChecks ="true"
/>
</Target>

The properties exposed by the MSBuild tasks are documented via an accompanying XSD file located in:

%ProgramFiles%\Microsoft Visual Studio 
8\Xml\Schemas\1033\MSBuild\Microsoft.VisualStudio.TeamSystem.Data.PowerTools.Tasks.xsd

How To: Build Non-MSBuild Projects with MSBuild

Building non-MSBuild projects is possible. For example you have to build VS2003, Installer, C++, Delphi projects etc. How can you do it? It's simple.

The MSBuild has a built-in task: Exec task. This task calls cmd.exe instead of directly invoking a process and runs the specified program or command with the specified arguments. You can use it in order to build non-MSBuild projects.

For example (thanks to Nagaraju) , in order to build a Visual Studio 2003 Project you should modify the MSBuild file as:

   1:  <PropertyGroup>
   2:      <VS2003_Devenv>$(ProgramFiles)\Microsoft Visual Studio .NET 2003\Common7\IDE\devenv.com</VS2003_Devenv>
   3:      <VS2003_SolutionName>$(SolutionRoot)\vs2003\VS2003Application\VS2003SLN.sln</VS2003_SolutionName>
   4:      <VS2003_Configuration>Debug</VS2003_Configuration>
   5:  </PropertyGroup>
   6:   
   7:  <Target Name="AfterCompile">
   8:      <Exec 
   9:             Command="&quot;$(VS2003_Devenv)&quot; &quot;$(VS2003_SolutionName)&quot; /build $(VS2003_Configuration)"/>
  10:      <MakeDir 
  11:             Directories="$(BinariesRoot)\$(VS2003_Configuration)"
  12:             Condition="!Exists('$(BinariesRoot)\$(VS2003_Configuration)')" />
  13:      <Copy  SourceFiles="$(SolutionRoot)\vs2003\VS2003Application\bin\$(VS2003_Configuration)\**\*.*"  
  14:             DestinationFiles="$(SolutionRoot)\vs2003\VS2003Application\bin\$(VS2003_Configuration)\**\*.* ->'
  15:             $(BinariesRoot)\$(VS2003_Configuration)\%(RecursiveDir)%(Filename)%(Extension)')"
  16:  />
  17:  </Target>

Read here for more information about the target names and the MSBuild configuration file.

First declare some variables to use them during the build. (Lines 1 - 5) . Next in the AfterCompile target, use the MSBuild Exec task to build the VS2003 project by invoking the devenv.com program (Lines 8 -9). After that make a directory (using MakeDir task) for the output (if not exists) (Lines 10 - 12). Finally copy (using the Copy task) the output files to the build binaries root (Lines 13 - 15).

Notice that this assumes VS 2003 is installed on the build machine.

Other resources: Aaron Hallberg - Building Non-MSBuild Projects With Team Build.

Good Luck!

Data Dude: How to Select From Other Database Server

When you have a View or other T-SQL Select statement that referenced to other server (even Oracle) , the VSTS for DB Professionals returns TSD4001: Could not find server SERVER NAME. Now build and deployment of the SQL Server database are blocked.

What can you do in order to solve it? the best workaround is to make sure the scripts are using 4 part names (ServerName.DatabaseName.DatabaseOwner.TableName) and you add the linked servers to the design database server. After that, you should be able to get the error to go away and you might be left with a warning about the cross-server dependencies not being able to be verified, but that shouldn't block your build and deployment of the SQL Server database.

ADO.NET Data Services ("Project Astoria") CTP is Released

Earlier this day I wrote about the release of ASP.NET 3.5 Extensions Preview release . The ASP.NET 3.5 Extensions Preview is a new release that provides new functionality being added to ASP.NET 3.5 and ADO.NET in 2008. This release delivers a set of new features that target:

  1. Enabling High Productivity Data Scenarios - including MVC, Entity Framework, ADO.NET Data Services and dynamic data
  2. Supporting Test Driven Development - including a powerful and extensible MVC framework
  3. Creating the best server for Rich Clients - including Ajax history support and Silverlight controls for ASP.NET

This release also includes the first CTP of the production version of ADO.NET Data Services (aka "Astoria") .

ADO.NET Data Services

ADO.NET Data Services provide new services that find, manipulate and deliver data over the web using simple URIs. Benefits include an easy and flexible way to access data over the web, while enabling the separation of presentation and data access code.

Astoria team blog: http://blogs.msdn.com/astoriateam/default.aspx

My posts about Astoria: http://blogs.microsoft.co.il/blogs/maordavid/archive/tags/Astoria/default.aspx

ASP.NET 3.5 Extensions Preview Released

The ASP.NET 3.5 Extensions Preview is a preview of new functionality being added to ASP.NET 3.5 and ADO.NET. The release includes an ASP.NET MVC, ASP.NET Dynamic Data, Silverlight controls for ASP.NET, ADO.NET Data Services, Entity Framework runtime, and new features for ASP.NET AJAX.

HTML helpers pages: ASP.NET MVC Preview: Using The MVC UI Helpers

How to Unit Testing with MVC: TDD and Dependency Injection with ASP.NET MVC

Team Explorer 2008 Download

To connect to Team Foundation Server, you must run a separate installer for Team Explorer. This installer is located in the [Drive]:\TFC\ folder on both the Team Suite 2008 media and the Team Foundation Server 2008 media.

Team Explorer 2008  is now also available to download.

Download Visual Studio Team Explorer 2008 (~388mb).

Technorati Tags:
GMAIL New Feature

Do you need help with keyboard shortcuts in Gmail? Just type ? (question mark) and you'll see a list of the most important keyboard shortcuts. To use it, you need to enable keyword shortcuts in the Settings before using them (the option is disabled by default).

I really like it!

GmailHelp

Technorati Tags: ,
More Posts Next page »

Search

Go

This Blog

News

    RSS

     

    Connect with Me

    Maor's Facebook profile  Follow Maor on Twitter  Maor's profile on Linkedin  Maor in FriendFeed 
           

Syndication