SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Visual Studio Tools


Visual Studio Tools

Author
Message
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27679 Visits: 13268
Jamie Thomson (3/10/2011)
This one may be particularly useful: Visual Studio 2010 SQL Server Database Projects


Thanks for the references!


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
Jamie Thomson
Jamie Thomson
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1263 Visits: 188
Duncan Pryde (3/10/2011)
Jamie Thomson (3/10/2011)
This one may be particularly useful: Visual Studio 2010 SQL Server Database Projects


Thanks for the links - I discovered after I posted that you have a number of entries on your blog as well which look interesting.

I think what I'm after is some idea as to why I should start using "Datadude" if I've never used it before. I'll have a look through the various articles and see what I can find though.

Thanks,

Duncan


yeah, that's a hard one to articulate. For me, I reached a point where it just "clicked" and I don't think that can happen until you use the product.

The big benefits as far as I can see them are:
-Development-time error checking (i.e. find out about errors before you actually run the code - so you wont get caught by deferred name resolution)
-Declarative development. (i.e. You define what the database state should be and the tool works out how to get it to that state, as opposed to you having to author all of the ALTER statements)
-Code analysis (i.e. it highlights bad coding practices)

Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
Duncan Pryde
Duncan Pryde
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3594 Visits: 1552
Jamie Thomson (3/10/2011)


The big benefits as far as I can see them are:
-Development-time error checking (i.e. find out about errors before you actually run the code - so you wont get caught by deferred name resolution)
-Declarative development. (i.e. You define what the database state should be and the tool works out how to get it to that state, as opposed to you having to author all of the ALTER statements)
-Code analysis (i.e. it highlights bad coding practices)


The second one does look like it might swing it. Up to now, we've tended to hand-write upgrade and rollback scripts for each release. It works, but it's time-consuming and quite clunky. I imagine this would be an improvement on that approach.
Jamie Thomson
Jamie Thomson
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1263 Visits: 188
Duncan Pryde (3/10/2011)
Jamie Thomson (3/10/2011)


The big benefits as far as I can see them are:
-Development-time error checking (i.e. find out about errors before you actually run the code - so you wont get caught by deferred name resolution)
-Declarative development. (i.e. You define what the database state should be and the tool works out how to get it to that state, as opposed to you having to author all of the ALTER statements)
-Code analysis (i.e. it highlights bad coding practices)


The second one does look like it might swing it. Up to now, we've tended to hand-write upgrade and rollback scripts for each release. It works, but it's time-consuming and quite clunky. I imagine this would be an improvement on that approach.


Definitely. On a recent project we moved to a 2-weekly release cycle. We could never have done that if we'd had to manually author our DB upgrade scripts.

I won't say there aren't caveats to this -nothing is that simple when data is involved- but you'll find that nearly all scenarios are possible.

Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
Duncan Pryde
Duncan Pryde
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3594 Visits: 1552
Jamie Thomson (3/10/2011)
Duncan Pryde (3/10/2011)
Jamie Thomson (3/10/2011)


The big benefits as far as I can see them are:
-Development-time error checking (i.e. find out about errors before you actually run the code - so you wont get caught by deferred name resolution)
-Declarative development. (i.e. You define what the database state should be and the tool works out how to get it to that state, as opposed to you having to author all of the ALTER statements)
-Code analysis (i.e. it highlights bad coding practices)


The second one does look like it might swing it. Up to now, we've tended to hand-write upgrade and rollback scripts for each release. It works, but it's time-consuming and quite clunky. I imagine this would be an improvement on that approach.


Definitely. On a recent project we moved to a 2-weekly release cycle. We could never have done that if we'd had to manually author our DB upgrade scripts.

I won't say there aren't caveats to this -nothing is that simple when data is involved- but you'll find that nearly all scenarios are possible.


That's good to know - we've wasted quite a lot of time in the past testing and debugging upgrade scripts (someone always forgets to add something!)

Thanks for all your extra information - it's been really useful.

Duncan
SanDroid
SanDroid
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1582 Visits: 1046
I could not find any Davelopment Tools that where released in the last ten years on MSDN.... :-D

I wonder if this is another victim of the Question submission tools edit function. :-P
SanDroid
SanDroid
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1582 Visits: 1046
mohammed moinudheen (3/9/2011)
I had no idea about the answer, I guessed it and got it right. :-)

Off late, there are so many questions on Visual Studio tools in QotD section.

It would be great if someone could share names of books on this topic for beginners.


The Visual Studio 2010 documentation is online here:
http://msdn.microsoft.com/en-us/library/dd831853.aspx

It does not have any infomration on Davelopment tools. ;-)
Jamie Thomson
Jamie Thomson
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1263 Visits: 188
SanDroid (3/10/2011)
I could not find any Davelopment Tools that where released in the last ten years on MSDN.... :-D

I wonder if this is another victim of the Question submission tools edit function. :-P


I suspect its more a victim of my poor grasp of english, which is rather disappointing given it is my native language Smile

Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
Victor Kirkpatrick
Victor Kirkpatrick
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2203 Visits: 453
We recently upgraded to Visual Studio 2010 Ultimate and I had some free training time, so I dove into the database project stuff. At first, I thought I was wasting my time, but like Jamie said, it all started to "click" at a certain point, and you get it. And, it's pretty awesome what you can do, especially with the refactoring of columns - automatically changing all the objects that reference that column, having each object as it's own file (yes, 1000 per folder limit due to performance, heh). What can take me hours on end happened in 2 minutes with this tool. Seriously.
SanDroid
SanDroid
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1582 Visits: 1046
I wan't everyone to understand something.
1000 files is a performance recomendation created a few years ago using a 32bit single core processor system running what I would call a limited configuration as a base point.
I have actually had to change this default configuration value in every version of Database Tools. Cool

If you have a good dev system with plenty of memory, more than one CPU core, and you are not running 32bit windows install on 64bit hardware importing Databases with almost 8000 objects are no real problem.
Smooooth

The amount of time these tools save you are worth any system lag you may experiance.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search