Activity overview
Latest activity by rcroeder
Compare fails to find simple difference in field
Simple issue,
two databases, one on SQL2008R2 the other SQL2008. On field has the value of 'EquipMake' the other 'equipMake'. Compare says they are the same, If I change the value on either side it...
Comparison of Real Data type
For sometime now I have and annoying issues comparison of Real data type, when that data is value is 0. RedGate does create a update, however when I rerun the comparison it shows that the fields do...
Brian,
Not really, the SQL DOC is a method to provide documentation table. What I am suggesting is to tie that documentation to a database just for database documentation where the database can be further documented. If you look at the output from SQL Doc it gives you the structure of each table, but detail information regarding the usage or meaning of each field is missing.
As an example for table __ApplicationGroupToGroupAreaSite I may want to add additional documentation
[ApplicationGroupToGroupAreaSiteID] [int]
[ApplicationGroupID] [int]
[ApplicationGroupAreaID] [int]
[ApplicationLicenseSubTypeID] [int]
[ApplicationLicenseTypeID] [int]
[SiteTypeID] [int] What type of site is being displayed see table _applicationSiteType
[DisplayOrder] [int]
[StatusID] [int]
[AgencyID] [int] Current agency being rendered
[AppRefGUID] [uniqueidentifier]
[Side] [int] Determines the side of the form to draw the element, 0=left 1=right / comments
Brian,
Not really, the SQL DOC is a method to provide documentation table. What I am suggesting is to tie that documentation to a database just for database documentation where the database can be ...
Suggestion for enhancement
The product works nice, however it could be enhanced. The program could point to a second database that contain the structure of the database being document, in such a format similar to syscolumns ...
Export
Suggestion on export, you have everything except tables that cannot be compared
RC