DCSIMG
Morgen's blog

Morgen's blog

Team System for the masses

Alternative test step editor for TFS

 The new Microsoft Test Manager has amazing abilities in managing manual tests, automating then, providing max data collection for the developer to reproduce the bugs found while testing.

However, Editing the test steps in Microsoft Test Manager is a bit difficult. step lines are limited in their width, and the text canot be wrapped to multi-lines.

 Here's an alternative editor that makes the steps editing more easier for us

Dan

Database management in Visual Studio 2010 Lecture, in TechEd Eilat

I'll be lecturing next week in TechEd Eilat, 29.11.2010.

You're all invited to join me and get to know how to manage your database schema, the same way you manage your application code.

You'll have a chance to see the major features in Visual Studio 2010 database management.

The database management is no longer outside ALM!

Dan

Using TFS in Linux Ubuntu

I have built a Linux Ubuntu virtual machine as a client for working with Team Foundation Server 2010 , using Eclipse plug in (Team Explorer Everywhere 2010).

I’ll Guide you through the required steps to do that.
Needless to say, we need a TFS server (2005/2008/2010) as a prerequisite, to connect to later on.

1. Let us build a machine.


If you already have an ubuntu macine – use it and skip this phase.

I Recommend for this testing to build a virtual machine, using Oracle Virtual Box Software.
Why Virtual Box? I experienced problems working on a virtual ubuntu machine based on Microsoft Virtual PC: delays using mouse, duplicate keyboard key clicks, etc…

Download Virtual Box from Here, and install it.

Download the latest version of ubuntu as iso file from here.

Activate Virtual Box and create a new Linux Ubuntu virtual machine, using the iso file as an installation media.

Follow the exact instructions in this great post.

2. We have a machine. Now install eclipse.

Note: Do not use Ubuntu Software Center to install eclipse. I tried that. The installation succeeds, but then the TFS plug in fails to install.

Go to Eclipse downloads site, and choose your favorite edition to download. I’ve chosen the IDE for Java EE Developers. download the zip file, and just extract it on your Ubuntu machine. Now you can use, No installation needed.

3. Download Team Explorer Everywhere from here.

If you did not purchased it you have a one month trial period.
There are 3 downloads in that page:

InstallTEE.htm – a useful readme file
TFSEclipsePlugin-UpdateSiteArchive-10.0.0.zip – the Team Explorer plugin for Eclipse
TEE-CLC-10.0.0.zip – TF Command Line utility

Download the files. in order to install the Eclipse plug-in, extract from zip file is NOT needed.

4. Install the Plug-in.

Follow instructions on InstallTEE.htm in the paragraph titled “To install the plug-in”

5. Associate local projects to TFS

Follow instructions on InstallTEE.htm in the paragraph titled “To associate your local Eclipse workspace with the same Team Foundation Server workspace”

Be aware that “Workspace” has a dual meaning. Eclipse workspace is the local environment, while TFS workspace, well, You know.

These next instructions are taken from In InstallTEE.htm + my screen shots.

Project Explorer, right-click the project that you want to add to version control, point to Team, and then click Share Project.

01 Team - Share Project 
The Share Project dialog box appears.

In the Select a repository type list, click Microsoft Team Foundation Server, and then click Next.
02 - Select TFS 

The Team Project page of the Share Project to Team Foundation Server dialog box appears.

05 - Login Details 

In the list of servers, click the instance of Team Foundation Server to which you want to connect.

If your server is not listed, click Servers, and then add the instance of Team Foundation Server to which you want to connect.

In the Team Project Collections list, click the team project collection that contains the team project to which you want to add your project.

image
In the Team Projects list, select the check box that corresponds to the team project to which you want to add your project, and then click Next to advance to the TFS Workspace page.

07 - Select Workspace

In the list, click the Team Foundation Server workspace to which your project was previously connected, and then click Next.

My additions:

We may have to edit TFS workspace definition…

08 - Edit Workspace

And then we’ll choose the TFS folder to associate.

09 - Select Server Location

6. Done.

We can view pending changes (my java projects are not yet on TFS so we have “add” pending changes).

11 - Pending Changes

After Check in, The files are in TFS.

The Plug in we installed enables us to manage builds, use Source control Explorer:

15 - Source Control Explorer

and manage work items:

16 - Work Item

17 - Bug

New TFS Sidekicks available

Team Foundation Sidekicks by Attrice Corporation is a free-to-use suite of tools for Microsoft Team Foundation Server administrators and advanced users.

These tools provide Graphic User Interface for administrative and advanced version control tasks in multi-user TFS environments.

Atrrice released Sidekicks v3.0.2 compatible with TFS 2010 Release client binaries.

Download here.

View Sidekicks page here.

Dan

Team Explorer Everywhere - for Java / Linux users

 Teamprise helped us using Team system while developing in Java,  within IDEs other than Visual Studio (Eclipse, IBM Rational),
on platforms other than Windows ( Apple Mac OS X, HP-UX, IBM AIX, Linux, Solaris, Unix).

With the launch of Visual Studio 2010, Microsoft announced Team Explorer Everywhere (acquired from Teamprise).

Read more about it here, download it from here.

Dan

Team Explorer 2005 forward compatibility pack is available

Microsoft released Team Explorer 2005 forward compatibility pack, which enables us to work with TFS 2010 using Visual Studio 2005

Download link here.

TF60008: VSS database version older than 6.0 – When migrating from VSS to TFS

I was performing a conversion from Visual Source Safe to Team Foundation Server, using SRL’s legendary check list.

Phase 1 – Analyzing using VSS tool, completed successfully.
Phase 2 – Analyzing using TFS tool (VSSConverter analyze) – could not start because of an error:

TF60008:  The VSS database version is older than 6.0. The VSS converter only supports database versions 6.0 or above. Please upgrade the database version and try again.

Visual Source Safe database must be converted to version 6 before TFS migration, but how?

The Solution (Thanks to Leon Langleyben) – Using command line, go to VSS 2005 directory (Program Files\Microsoft Visual Source Safe) and activate ddupd.exe , using vss data folder path as a parameter.

For example: “c:\program files\Microsoft Visual Source Safe\ddupd.exe” c:\myvss\data

Work item definition modifications not shown in Team System Web Access

I made some modifications on a work item definition, specially regarding to the state transitions. I uploaded my modifications to the server (TFS 2008 SP1), and performed refresh in my team explorer to view the changes. Everything OK.

But when I tried to view my modifications using Team System Web Access – I saw the old definitions. “Refresh cache” option did not help.

I googled it and found a post providing the solution: use the magic word - iisreset.

It works.

Rename TFS work item definition? possible in 2010

Before TFS 2010, renaming work item definition was a complex task.
What we had to do was to create a NEW definition using the new name and all other definitions of the original work item, and to re-create all work items and lose all modification history.

In TFS 2010, all we have to do is to rename work item definition using command line tool witadmin.exe

Dan

Visual Studio 2010 TFS Guide to Requirements Management Released

 An excelent guide for managing requirements in VS2010 is available.


The guide is for requirements engineers, and shows us how to plan, analyse and validate our requirements
in TFS 2010 envioronment with various methologies supported in TFS.

Dan

TFS 2010 Installation Guide – a friendly version

Hi

For installing TFS 2010, we use the installation guide provided my microsoft.
However, It’s takes an effort to use it, to navigate inside this chm file and locate the step we are in during the installation.

Leo Kushnir sent me a link to a friendly installation guide by Benjamin Day.
One PDF file, with the installation steps, and with a lot of screen shots.

Use it!

SQL Server Reporting Services is configured to require a secure connection, however no HTTPS URL is configured with a valid certificate

I got this error message by TFS configuration wizard, which ran validation tests after SQL 2008 & TFS 2010 installations:

”SQL Server Reporting Services is configured to require a secure connection, however no HTTPS URL is configured with a valid certificate. Use the Reporting Services Configuration Manager to configure or remove HTTPS support.”

It appears that reporting services management URL was enabled only in HTTPS, not HTTP.

Found a great solution by Ed Holloway here, by editing report server configuration file.

Visual Studio 2010 RC: Team Foundation Error. Could not load type 'Microsoft.TeamFoundation.Client.TeamFoundationServerBase' from assembly

I installed visual studio 2010 RC, after uninstalling 2010 Beta 2 version.

When activated Visual Studio, got error message "Team Foundation Error. Could not load type 'Microsoft.TeamFoundation.Client.TeamFoundationServerBase' from assembly ''Microsoft.TeamFoundation.Client, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f57f11d50a3a'."

There’s a great post, by Grant Holliday, explaining the reason: TFS Object Model API changes after Beta 2.

The bottom line: Uninstalling VS2010 Beta 2 is not enough, we have to remove all VS add-ons which were built against the Beta2 object model.

I had 2 add-ons that caused those errors:
1. TFS 2010 power tools Beta 2 (According to Brian Harry, RC compatible version is a matter of days to be released)
2. Team Foundation Sidekicks 2010 by Attrice.

Note: If you try to uninstall Power Tools *After* installing VS2010 RC, It's possible that the uninstall will not complete successfuly, and you will still get error messages in VS2010. Buck Hodges provides a fix for that, by re-installing and uninstalling Power Tools.

Dan

Data Dude: Could not load file or assembly System.Data.SqlServerCe, Version=3.5.1.0

Hi

You may get this error from Visual Studio, after successfully installing data dude GDR 1 or GDR 2, when you try to work with the dude (create new data dude project, for example).

Could not load file or assembly 'System.Data.SqlServerCe, Version=3.5.1.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

Data dude GDR 1 & 2 require installation of Microsoft SQL Server Compact Edition 3.5 SP1 .

This requirement is NOT documented in the GDR download page,
And when you install the GDR without it, the installation succeeds, but the dude will raise this error when you try to use it.

Dan

Flexible Dude for data compare

 Hi,

In my previous post I offered a utility that makes data dude's schema compare output more flexible,
especially when we try to run the script on a database at a customer's site.

Now I'd like to modify the generated script from data compare, just a little bit.

Data dude generated this INSERT TABLE statement:
INSERT INTO [dbo].[myTBL] ([FieldA], [FieldB], [FieldC], [FieldD]) VALUES (8, 2, NULL, N'Hi')

What if we have primary keys on FieldA and FieldB, and we already have one row containing those values?

Here's my console application that generates the requested statements.

This console application gets 2 arguments: First one is the name of the file generated by data compare, the other one is the path to the data dude project.

The application uses data dude's path to parse all sql files regarding to primary keys ("*.pkey.sql) in the folder "Schema Objects\Schemas\dbo\Tables\Key" under data dude's project root folder.

The application parses those files to retrieve the list of all fields with primary keys in all tables.
Then, the application parses data dude's generated file, searches for INSERT INTO statements, searches for fields with the primary keys and generates "IF NOT EXISTS" statement .

So, if we had 
INSERT INTO [dbo].[myTBL] ([FieldA], [FieldB], [FieldC], [FieldD]) VALUES (8, 2, NULL, N'Hi')

My application replaced it with:
IF NOT EXISTS (SELECT * FROM [dbo].[myTBL] WHERE [FieldA]=8 and  [FieldB]= 2)
BEGIN
INSERT INTO [dbo].[myTBL] ([FieldA], [FieldB], [FieldC], [FieldD]) VALUES (8, 2, NULL, N'Hi')
END

And another bonus for you: Treatment for ALTER TABLE DROP CONSTRAINT.
The application replaces:
ALTER TABLE [dbo].[myTBL] DROP CONSTRAINT [FK_myTBL_MyConstraint]

with:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_myTBL_MyConstraint]') and
OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[myTBL] DROP CONSTRAINT [FK_myTBL_MyConstraint]
GO

The code is attached. Just create a new console application and replace your program.cs file with this one.

Dan

 

 

More Posts « Previous page - Next page »