SQL Database Setup - Need 11/7 AM Help 
Author Message
 SQL Database Setup - Need 11/7 AM Help

I just took over as project manager for this database project.  We've asked
the vendor to supply us with descriptive (plain English) names to go with
each of the fields.  The vendor says that this information was not done and
would be very involved.  When I did some database work back in ACCESS, I
always put in a plain English description.  Is this feature not available in
SQL 7.0?  Even if it isn't, shouldn't the vendor have done something like it
anyway just as a good practice?  I'd appreciate some thoughts.  I'm not
going to start a battle with the vendor but I would like to have some
professional perspective on what would have been best practices.

Thanks



Fri, 25 Apr 2003 03:00:00 GMT
 SQL Database Setup - Need 11/7 AM Help

Quote:
>> Is this feature not available in SQL 7.0?

    Yes that is true. SQL2000 introduces extended properties for database
objects.

Quote:
>> Even if it isn't, shouldn't the vendor have done something
>> like it anyway just as a good practice?

    I guess so. Database diagrams or ER diagrams would suffice I think.

--
Umachandar Jayachandran
SQL Resources at http://www.umachandar.com/resources.htm
(Please reply only to the newsgroup)



Fri, 25 Apr 2003 03:00:00 GMT
 SQL Database Setup - Need 11/7 AM Help

I always think it's good practise to have a data dictionary of some form
listing, tables (with a brief description of what they are used for) and
listing all fields and what they contain. If you're replacing staff then it
save a lot of learning time and avoids potential errors if you have a
definitive place of reference.


Quote:
> >> Is this feature not available in SQL 7.0?

>     Yes that is true. SQL2000 introduces extended properties for database
> objects.

> >> Even if it isn't, shouldn't the vendor have done something
> >> like it anyway just as a good practice?

>     I guess so. Database diagrams or ER diagrams would suffice I think.

> --
> Umachandar Jayachandran
> SQL Resources at http://www.umachandar.com/resources.htm
> (Please reply only to the newsgroup)



Sat, 26 Apr 2003 03:00:00 GMT
 SQL Database Setup - Need 11/7 AM Help

The vendor probably has internal documentation  but does not wish to publish
it or make it available.  This is not unusual, but also it is not very
professional.  Often. paticulalry with small vendors, it is a matter of
staffing and cost to produce a usable document for their customers, in other
cases it is a matter of maintaining trade secrets.

See if you can get internal documents in exchange for signing some sort of
non-disclosure agreement.


Quote:

> I just took over as project manager for this database project.  We've
asked
> the vendor to supply us with descriptive (plain English) names to go with
> each of the fields.  The vendor says that this information was not done
and
> would be very involved.  When I did some database work back in ACCESS, I
> always put in a plain English description.  Is this feature not available
in
> SQL 7.0?  Even if it isn't, shouldn't the vendor have done something like
it
> anyway just as a good practice?  I'd appreciate some thoughts.  I'm not
> going to start a battle with the vendor but I would like to have some
> professional perspective on what would have been best practices.

> Thanks



Sat, 26 Apr 2003 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. database needed for os2 v2.11 HELP

2. need help connecting NT client SSM to SQL 11 server

3. Need help in SQL 11 installation

4. Q: Install/Setup ODBC using IPX on Win/Win3.11 to SQL v6.0

5. HELP - Database Setup App Help NEEDED ???

6. -->Need Database Guru to Help Setup Massive Discographical Database

7. Need Lessons Learned: Upgrading from Version 10 to 11 and 11.0.3 to 11.5

8. Opinions needed for Upgrade 11.0.3.3 to 11.9.2

9. SQL 6.5 need help with SQL Mail setup

10. need help with SQL Collations in SQL Server setup

11. Need help about System 11 and PeopleSoft

12. Sybase System 11 Driver problem - (Need Help)


 
Powered by phpBB® Forum Software