February 4, 2016 at 9:06 am
When on BI dev assignment I often have to create views as the basis for creating a star schema. Many times I have to use named queries in the DSV.
I wondered if there was a tool/macro for reverse engineering tables/views or a SQL query.
I have Visio Pro 2013 on my laptop but many times at clients I'm working on their dev machine.
Ideally I'd like to be able to export a script and import to my local visio.
Would save lots of time during design/documentation.
Best
Lee
February 4, 2016 at 9:20 am
leejayd (2/4/2016)
When on BI dev assignment I often have to create views as the basis for creating a start schema. Many times I have to use named queries in the DSV.I wondered if there was a tool/macro for reverse engineering tables/views or a SQL query.
I have Visio Pro 2013 on my laptop but many times at clients I'm working on their dev machine.
Ideally I'd like to be able to export a script and import to my local visio.
Would save lots of time during design/documentation.
Best
Lee
I am not sure I understand your question here? Are you trying to take a result set and convert that back into the base tables including datatypes and such? I don't think this is possible. How would you possibly know what table, or maybe a derived value, a column came from based only on the name in a resultset?
Perhaps if you can more clearly explain what you are trying to do we can help you find a way to make it happen.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
February 4, 2016 at 9:27 am
Data source views(DSV) are stored as XML which is not that hard to get. You just need to explore a bit as I can't remember the exact tag that it's used.
How to import it to Visio? That I have no idea as I've haven't worked with Visio since college.
February 10, 2016 at 7:11 am
I'm trying to create a diagram/schema using a query as an input i.e. joins will be shown as links to other tables. More to aid documentation rather than anything else. We see a similar thing in Tabular with the data model view.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy