Visual Studio Database Tools

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

  • 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

  • Thanks for the question.

    It gave me a good learning opportunity.

  • 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!

  • 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 🙂

  • 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

  • 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.

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

  • Another tough question on Visual studio db tools

    M&M

  • This is useful information, thanks for the question.

  • 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:

  • Nice question. Thanks!

  • 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.

  • 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

  • Nice question, and nice explanation. Thanks.

    Tom

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

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