Visual Studio Database Tools

  • Jamie Thomson

    SSChampion

    Points: 11805

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

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    Very interesting question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • tejaswini.patil

    SSCommitted

    Points: 1782

    Thanks for the question.

    It gave me a good learning opportunity.

  • DNA_DBA

    SSCertifiable

    Points: 7849

    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!

  • Jamie Thomson

    SSChampion

    Points: 11805

    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 🙂

  • kaspencer

    SSCarpal Tunnel

    Points: 4407

    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

    You never know: reading my book: "All about your computer" might just tell you something you never knew!
    lulu.com/kaspencer

  • dave.farmer

    SSCrazy

    Points: 2431

    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[/url] to generate easily maintained, rerunnable scripts from your existing static data for use in your post deployment scripts.

  • OCTom

    SSChampion

    Points: 11755

    Eventhough it's made-up, "object-mapped data files" sounds really cool. 😎

  • M&M

    SSC-Insane

    Points: 21699

    Another tough question on Visual studio db tools

    M&M

  • Cliff Jones

    SSChampion

    Points: 10517

    This is useful information, thanks for the question.

  • SanDroid

    SSChampion

    Points: 10068

    OCTom (3/17/2011)


    Eventhough it's made-up, "object-mapped data files" sounds really cool. 😎

    I would have to agree. We call the filled tables in our cached Data library Datasets or well defined tables. I like object-mapped data files so much I am going to start using it. :w00t:

    I would like to say that I am sure someone I worl with will notice this and correct me, but I know they won't. :smooooth:

  • SanDroid

    SSChampion

    Points: 10068

    Nice question. Thanks!

  • SanDroid

    SSChampion

    Points: 10068

    kaspencer (3/17/2011)


    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?

    They both are really. The data would be meaningfull from a testing perspective of dertermining if the database can be populated with the data and data-types that it will be filled with. Also for testing this generated or "FALSE" data can test an application UI to ensure that it dsplays information properly.

    However testing a Zip Code and Last Name feild in a database with the values 54321 and QWRTGHOPI is not very meaningfull. You can find documentation that is not sales oriented that will also back this up.

    It is always good to rememeber that the M$ marketing department gets to review all product documnetation before release.

  • SQLRNNR

    SSC Guru

    Points: 281243

    Thanks for the question. It makes total sense.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • TomThomson

    SSC Guru

    Points: 104773

    Nice question, and nice explanation. Thanks.

    Tom

Viewing 15 posts - 1 through 15 (of 24 total)

You must be logged in to reply to this topic. Login to reply