March 16, 2011 at 11:42 pm
Comments posted to this topic are about the item Visual Studio Database Tools
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
March 17, 2011 at 12:45 am
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
March 17, 2011 at 1:37 am
Thanks for the question.
It gave me a good learning opportunity.
March 17, 2011 at 1:46 am
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!
March 17, 2011 at 1:55 am
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
March 17, 2011 at 3:32 am
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
March 17, 2011 at 4:09 am
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.
March 17, 2011 at 6:53 am
Eventhough it's made-up, "object-mapped data files" sounds really cool. 😎
March 17, 2011 at 7:01 am
Another tough question on Visual studio db tools
M&M
March 17, 2011 at 7:58 am
This is useful information, thanks for the question.
March 17, 2011 at 8:18 am
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:
March 17, 2011 at 8:18 am
Nice question. Thanks!
March 17, 2011 at 8:25 am
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.
March 17, 2011 at 11:43 am
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
March 17, 2011 at 12:57 pm
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