blogs.conchango.com

welcome to the conchango blogging site
Welcome to blogs.conchango.com Sign in | Join | Help
in Search
Blogs

SSIS Junkie

Big release day at Microsoft

A short word about today's massive release from Redmond...

As if the world and his dog didn't know, Visual Studio Team System for Database Professionals, is getting released today. This is great news for all us put-upon database developers that want to be treated as first class citizens in the software development lifecycle by those pesky dotnetter types. No longer to be Ringo Starr compared to their John Lennon if you will!!!  :)

Thank you to all the team that have knocked out this great tool in less than year.

 

I heard a rumour about some other minor release today as well....

-Jamie

 

 

 

 

Published 01 December 2006 04:24 by jamie.thomson

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

SSIS Junkie said:

New releases that appear on my radar seem to be falling down all around me today. The SSIS team have

December 1, 2006 05:16
 

jonathan.george said:

I went to a demo of this product recently, and it came across as a cut down version of the Redgate Sql Compare and Sql Data Compare tools for several times the price (the figure quoted to me was something in the region of £3,000 per seat if you don't already have a team suite license).

Personally, I think instead of spending the money I'd stick with the existing database project in Visual Studio and/or management studio. Having said that, I'd be more interested if it had proper refactoring tools and intellisense - as a C# developer I don't like straying away from the full stop and arrow keys ;-)

As it stands now, if the price were lower, I think it could be justified but as it stands it's just too expensive.

December 4, 2006 16:34
 

jamie.thomson said:

Fair points mate.

Its got the same stuff as Redgate but its got two other things that are very important (to me anyway):

-Integration with source control (i.e. TFS)

-MSBuild compliant. So we have it as part of our CI and overnight builds

Its also got some other fairly funky stuff that we may or may not use. Like built-in unit testing.

It already has refactoring in it. i.e. Change the name of a column and all references to that column in sprocs/functions/views/foreign keys/etc… automatically get changed. They've a long way to go with it but it’s a good start.

Intellisense - I'm with you on that one as you can see here: https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=444298&SiteID=1

I went to their launch party in Seattle and had an interesting conversation with their lead developer about intellisense. He said there's about 6 language constructs in C# that have to be checked for for intellisense. In SQL there's close to 200. I don't know if that's true but it shows how difficult it would be to implement.

Have you used Redgate's attempt at Intellisense (used to be called SQLPrompt)? Its awful. I turned it off.

Good discussion. I hope someone else picks up on it.

cheers

Jamie

December 4, 2006 16:40

Leave a Comment

(required) 
(optional)
(required) 
Submit

This Blog

Syndication

News
© 2008 - Any comments or statements made herein do not necessarily reflect those of Conchango.
Powered by Community Server (Personal Edition), by Telligent Systems