|
|
Posted by javelin on 10/02/21 11:44
David, I appreciate your reply. First, I should say that I'm quite
fluent at SQL coding by hand, what I'm not that good at is remembering
the names of tables and fields, so having a drag and drop interface
helps a great deal. Second, no matter how good you are, I believe that,
given equal knowledge of a data structure and predefined goals, I can
drag and drop my views at least as quick as you or anyone else can type
them. I know some very advanced SQL Server developers that would rather
pay for their own licenses to use Speed SQL or other design tools. BTW,
Speed SQL is not that great for graphical drag and drop design of
queries, it's rather slow, but it's awesome for intellisense. Just
alias a table, type in the alias followed by a dot, and the field names
pop right up. Gotta love that!
As for the 160 nearly identical databases, that is for 160 different
clients, each on having about 400 identical tables, some having
specialized tables, functions, views, etc., for their company. Thus, we
need to manage each one independently. To put them all in a single
database would complicate things in ways this environment is not
prepared to handle.
Thanks.
Navigation:
[Reply to this message]
|