Hi,
I tried to compare two databases with Full text indexing.
In the Project Configuration options I chose to ignore Full text indexing.
On Synchornization I got an error message similar to:
"The following error message was returned from the SQL Server:
[7613] Cannot drop index 'PK_tblXXX' because it enforces the full-text key for table or indexed view 'tblXXX'.
Could not drop constraint. See previous errors.
The following SQL command caused the error:
ALTER TABLE [dbo].[tblXXX] DROP CONSTRAINT [PK_tblXXX]'
When I did it again without ignoring the comparison of Full text indexing, it ran fine.
I think it will be great in such case to suggest the user to make the synchroniztion again, this time without ignoring "full text indexing".
Moreover, it was good if this was in the Warnings area before Synchronization.
Thanks,
Yinon
I tried to compare two databases with Full text indexing.
In the Project Configuration options I chose to ignore Full text indexing.
On Synchornization I got an error message similar to:
"The following error message was returned from the SQL Server:
[7613] Cannot drop index 'PK_tblXXX' because it enforces the full-text key for table or indexed view 'tblXXX'.
Could not drop constraint. See previous errors.
The following SQL command caused the error:
ALTER TABLE [dbo].[tblXXX] DROP CONSTRAINT [PK_tblXXX]'
When I did it again without ignoring the comparison of Full text indexing, it ran fine.
I think it will be great in such case to suggest the user to make the synchroniztion again, this time without ignoring "full text indexing".
Moreover, it was good if this was in the Warnings area before Synchronization.
Thanks,
Yinon