View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001189 | Database Comparer VCL | General | public | 2017-12-06 12:37 | 2019-12-13 10:54 |
| Reporter | shirokov | Assigned To | barry | ||
| Priority | high | Severity | major | Reproducibility | always |
| Status | feedback | Resolution | open | ||
| Summary | 0001189: DB object creation order is invalid | ||||
| Description | The 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 Reproduce | 1. 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. | ||||
| Tags | No tags attached. | ||||
|
|
|
|
|
Extract Metadata - это не скрипт создания базы, это заблуждение. Это просто информация о структуре базы навалом. Для получения скрипта создания БД необходимо выполнить сравнение с пустой базой. Тогда объекты будут создаваться с учетом зависимостей. Т.е. по логике Update Script. Или dbcExtractMetadata.dproj делает скрипт создания по логике сравнения? |
| 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 |
