SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Database defintion from an Excel Spec?


Database defintion from an Excel Spec?

Author
Message
Lambchop4697
Lambchop4697
SSC Journeyman
SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)

Group: General Forum Members
Points: 90 Visits: 43
I liked the article. Easy to follow and understand. I have been consulting for more than 20 years and I have only found this situation a few times. But those were always ugly and the conditions by which the "politics" occured was equally unique. I disagree with the earlier criticism about 3rd party vendor control and our ability to demand information. I have faced these exact problems in state and federal government situations as well as private sector. The fact is, I do not think you have a lot of outside exposure if you believe you can impose your own policies on the parties you are working with. Keep in mind, and this is to those who are wanting to be judgemental, if it was easy, you probably would not have been called in the first place. Always good to ask for the simple to be possible, but accept the reality that in most cases, people are usually not that stupid and they *always* have their reasons. Otherwise, go work for a single company and then you can impose your policies according to your stupendously supportive boss Smile
upwards and onwards!



dcawvive
dcawvive
Old Hand
Old Hand (324 reputation)Old Hand (324 reputation)Old Hand (324 reputation)Old Hand (324 reputation)Old Hand (324 reputation)Old Hand (324 reputation)Old Hand (324 reputation)Old Hand (324 reputation)

Group: General Forum Members
Points: 324 Visits: 149
I was basing the 10K on the 80 hours estimated in the article @ $100 /hour plus a few hours of debugging, tweaking etc.
Samuel Vella
Samuel Vella
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2049 Visits: 2144
dcawvive (11/12/2009)
I was basing the 10K on the 80 hours estimated in the article @ $100 /hour plus a few hours of debugging, tweaking etc.


Currency conversion issue
I'm working in £, you're dealing with $ ;-)
katesl
katesl
Old Hand
Old Hand (399 reputation)Old Hand (399 reputation)Old Hand (399 reputation)Old Hand (399 reputation)Old Hand (399 reputation)Old Hand (399 reputation)Old Hand (399 reputation)Old Hand (399 reputation)

Group: General Forum Members
Points: 399 Visits: 473
What I meant to say in my first post is that programmers should know what a programmer's editor can do and when to use it. Time estimates based on document editing when what's needed is a programmer's editor are way high-- unconscionable to contemplate charging your client for many hours of work when half an hour will do it.

_________________
"Look, those sheep have been shorn."
data analyst replies, "On the sides that we can see.."
Neuro
Neuro
Old Hand
Old Hand (385 reputation)Old Hand (385 reputation)Old Hand (385 reputation)Old Hand (385 reputation)Old Hand (385 reputation)Old Hand (385 reputation)Old Hand (385 reputation)Old Hand (385 reputation)

Group: General Forum Members
Points: 385 Visits: 239
katesl (11/12/2009)
What I meant to say in my first post is that programmers should know what a programmer's editor can do and when to use it. Time estimates based on document editing when what's needed is a programmer's editor are way high-- unconscionable to contemplate charging your client for many hours of work when half an hour will do it.




£50 an hour no way, I wouldn't get out of bed for that



Charles Kincaid
Charles Kincaid
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3311 Visits: 2384
I had a similar challenge and I did it to myself. We underwent a new database design for the next generation of one of our products. We decided to "do it right" rather than the old way of "add a column when you have something to save".

We also have common columns (not fields) in most of the tables. There are intersection tables and relationship tables that don't need the common columns. So while parsing my column definition file if I came up with a table that was not defined I issued a CREATE TABLE statement. After that it was ALTER TABLE all the way. My tool is in .Net and I used text files.

What is surprising is that somebody bought a 3rd party product that has no views or stored procedures at all. I have several major works in production that way but no more. Did they give you no guidance whatever as to indexing? It could be that you left that out for the sake of the article. Please say that this is true. If not then you are being very kind by not outing the vendor. Bone up on your missing index DMV.

ATBCharles Kincaid
René Berends
René Berends
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
Points: 18 Visits: 234
Hi,

I'm using a similar approach to generate tables, indexes and stored procedures to build and populate data warehouses, all from Excel.
Basically you have one tool to create, maintain and generate your mappings. Plus, they're documented.

I use VBA to generate all the database objects.

René

Kind regards,
René Berends
rsteckly
rsteckly
SSC-Enthusiastic
SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)

Group: General Forum Members
Points: 120 Visits: 62
Why not use SQL Server Integration Services? In SSIS 2008, you can use the import/export wizard to specify the input as an Excel file. You can then choose to create a table, rather than move the sheet to an existing one.
Granted, you'd have to use the wizard once for each sheet, but from the specs that sounds easier.
Of course, there can be some pesky data typing issues...
Charles Kincaid
Charles Kincaid
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3311 Visits: 2384
rsteckly (11/12/2009)
Why not use SQL Server Integration Services? ...
Because his spreadsheet has specifications for that date and not the actual data.

ATBCharles Kincaid
rsteckly
rsteckly
SSC-Enthusiastic
SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)

Group: General Forum Members
Points: 120 Visits: 62
Duh. Right, sorry.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search