Visual Studio Database Tools

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Jamie Thompson » Visual Studio Database Tools

24 posts, Page 1 of 3

1 2 3 »»»

Visual Studio Database Tools

Rate Topic

Display Mode

Topic Options

Author

Message

Jamie Thomson

Posted Wednesday, March 16, 2011 11:42 PM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 1:03 AM
Points: 877, Visits: 185

Comments posted to this topic are about the item Visual Studio Database Tools

Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson

Post #1079470

Koen Verbeeck

Posted Thursday, March 17, 2011 12:45 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 6:39 AM
Points: 9,376, Visits: 6,472

Very interesting question, thanks.

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

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1079492

tejaswini.patil

Posted Thursday, March 17, 2011 1:37 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, April 19, 2011 1:59 AM
Points: 1,042, Visits: 234

Thanks for the question.

It gave me a good learning opportunity.

Post #1079501

DNA_DBA

Posted Thursday, March 17, 2011 1:46 AM

SSCrazy

Group: General Forum Members
Last Login: Monday, May 20, 2013 5:19 AM
Points: 2,374, Visits: 1,945

Good question. There have been a few Visual Studio questions recently - it's made me want to find out more about it as it could be quite useful. Thanks!

Post #1079505

Jamie Thomson

Posted Thursday, March 17, 2011 1:55 AM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 1:03 AM
Points: 877, Visits: 185

DNA_DBA (3/17/2011)

Good question. There have been a few Visual Studio questions recently - it's made me want to find out more about it as it could be quite useful. Thanks!

That's the last one I'm afraid (from me anyway). I'm done now :)

Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson

Post #1079509

kaspencer

Posted Thursday, March 17, 2011 3:32 AM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 10:36 AM
Points: 1,404, Visits: 253

Just one question occurs to me:

In your discussion of your question, when you state the answer, you state that a DGP is used to insert meaningless data into a schema.

However, in the Microsoft library, it states "You can use Microsoft Visual Studio Team Edition for Database Professionals to generate meaningful data for testing. "

Which is correct? Meaningless or Meaningfull?

Regards

Kenneth Spencer

Post #1079531

dave.farmer

Posted Thursday, March 17, 2011 4:09 AM

SSC Eights!

Group: General Forum Members
Last Login: Friday, May 03, 2013 3:39 AM
Points: 857, Visits: 584

DNA_DBA (3/17/2011)

Good question. There have been a few Visual Studio questions recently - it's made me want to find out more about it as it could be quite useful. Thanks!

Yes, definitely find out more... it's a massive step forward.
You get proper source control without the need to maintain artificial scripts (none of that if exists drop create etc.), deployment is made orders of magnitude easier. As I mentioned in the discussion to another of Jamie's questions, I can do in less than a day what it took a database team 2 or 3 days to do in my last place!

PS. for maintaining known static data via post deployment scripts, there's a very useful free little tool here to generate easily maintained, rerunnable scripts from your existing static data for use in your post deployment scripts.

Post #1079539