Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Visual Studio Database Tools Expand / Collapse
Author
Message
Posted Wednesday, March 16, 2011 11:42 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Sunday, November 10, 2013 11:52 AM
Points: 877, Visits: 188
Comments posted to this topic are about the item Visual Studio Database Tools

Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
Post #1079470
Posted Thursday, March 17, 2011 12:45 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Sunday, July 20, 2014 11:20 PM
Points: 13,252, Visits: 10,133
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
Posted Thursday, March 17, 2011 1:37 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen 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
Posted Thursday, March 17, 2011 1:46 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 12:59 AM
Points: 2,613, Visits: 2,225
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
Posted Thursday, March 17, 2011 1:55 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Sunday, November 10, 2013 11:52 AM
Points: 877, Visits: 188
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
Posted Thursday, March 17, 2011 3:32 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 3:08 AM
Points: 1,707, Visits: 458
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
Posted Thursday, March 17, 2011 4:09 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, June 11, 2014 9:54 AM
Points: 912, Visits: 654
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
Posted Thursday, March 17, 2011 6:53 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:17 PM
Points: 2,512, Visits: 3,698
Eventhough it's made-up, "object-mapped data files" sounds really cool.
Post #1079613
Posted Thursday, March 17, 2011 7:01 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 11:06 PM
Points: 2,270, Visits: 3,778
Another tough question on Visual studio db tools

Mohammed Moinudheen
Post #1079617
Posted Thursday, March 17, 2011 7:58 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 1:54 PM
Points: 3,869, Visits: 3,620
This is useful information, thanks for the question.
Post #1079659
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse