View Issue Details

IDProjectCategoryView StatusLast Update
0001189Database Comparer VCLGeneralpublic2019-12-13 10:54
Reportershirokov Assigned Tobarry  
PriorityhighSeveritymajorReproducibilityalways
Status feedbackResolutionopen 
Summary0001189: DB object creation order is invalid
DescriptionThe dependent database objects are created in invalid order. SQL Server 2008 R2. dbcExtractMetadata.dproj demo.

See the provided scripts.
The problems:
1. The view ASI.VEHICLEBYSITEREAD depends on ASI.VehicleRead, but ASI.VEHICLEBYSITEREAD is created before ASI.VehicleRead.

2. VEHICLEPMREAD is not created completely. Compare the scripts.

3. DBO.FUELTYPE is not created completely. The ShortName field is absent.

4. The TIME data type does not extract precision: TIME, but should be TIME (7).

5. SET QUOTED_IDENTIFIER OFF at the beginning of the script, while the original DB script always set it to ON.
Steps To Reproduce1. Create a new database with the SchemaComplete.sql script.
2. Run dbcExtractMetadata.dproj demo and extract DB structure to a script.
3. The resulting script dbcomparerscript.sql.
TagsNo tags attached.

Relationships

related to 0001193 closedbarry MS SQL TIME column is extracted incorrectly. 

Activities

shirokov

2017-12-06 12:37

administrator  

creationordererror.zip (47,166 bytes)

barry

2019-12-13 09:59

administrator   ~0004273

Extract Metadata - это не скрипт создания базы, это заблуждение. Это просто информация о структуре базы навалом.
Для получения скрипта создания БД необходимо выполнить сравнение с пустой базой. Тогда объекты будут создаваться с учетом зависимостей. Т.е. по логике Update Script.
Или dbcExtractMetadata.dproj делает скрипт создания по логике сравнения?

Issue History

Date Modified Username Field Change
2017-12-06 12:37 shirokov New Issue
2017-12-06 12:37 shirokov File Added: creationordererror.zip
2019-12-13 09:51 barry Relationship added related to 0001193
2019-12-13 09:59 barry Note Added: 0004273
2019-12-13 10:54 barry Assigned To => barry
2019-12-13 10:54 barry Status new => feedback