Article - CS136082
During Oracle to SQL Server migration, Step 12 Synchronize with Database fails: "An explicit DROP INDEX is not allowed on index 'dbo.FVITEM.PK_FVITEM'..."
Modified: 24-Jul-2013
Applies To
Oracle to MS SQL Server migration (of Windchill database)Description
- Migrating Windchill Oracle database to MS SQL Server 2005 via MS SQL Server Migration Assistant (SSMA)
- At end of step 12, the following error is presented:
Errors: An explicit DROP INDEX is not allowed on index 'dbo.FVITEM.PK_FVITEM'. It is being used for PRIMARY KEY constraint enforcement.
Synchronization error: An explicit DROP INDEX is not allowed on index 'dbo.FVITEM.PK_FVITEM'. It is being used for PRIMARY KEY constraint enforcement. On: staging.dbo.FVITEM.PK_FVITEM
Synchronization operation is complete.
This is a printer-friendly version of Article 136082 and may be out of date. For the latest version click CS136082