SQL DB Project and column renaming

Do you use Microsoft Visual Studio SQL Database Project?
Do you need to rename all columns of a table? (ok, it's a rare operation).

Please pay a lot of attention because deploy and schema compare functions don't warn you that the table will be dropped and recreated... with a completely data loss!!!

This strange and dangerous behavior doesn't happen when you rename less columns.

The work-around is to manually add sql script to "copy and paste" the datas from old to new table.

- Posted using my iPhone

Unable to create TeamProject on TFS 2010

Are you stucked during creation of a Team Project on Team Foundation Server 2010?

Does the progress bar hangs at 90% of the creation?

Have you found an error event on tfs server (application event log) that talks something about Lab Management and a Virtual Server Manager 2008 R2?

Do you confirm that your TFS is not configured for Lab Management?

Do you confirm you actually don't need the Lab Management feature?

Ok, pay attention 'cause process template MSF Agile 5.0 requires Lab Management configured.

A good and easy work-around is to create a new process template based on MSF Agile 5.0 removing the Lab Mangement section. - Posted using my iPhone

ALM & Test Day 2011

Si inizierà alla grande il 2011 con due date importanti, una a Roma il 18 gennaio ed una a Milano il 21 gennaio 2011.

ALM & Test Day consentirà a tutti i protagonisti del "lato oscuro" del mondo developers & co. di immergersi in una giornata piena di dettagli su come migliorare la produttività e la collaborazione all'interno di un team.

Io ci sarò come speaker in una sessione tecnica dedicata al Visual Studio Sql Database Project!

Cliccate QUI - Posted using my iPhone

Luca Ritossa Blog - Designed by Posicionamiento Web | Bloggerized by GosuBlogger