All values for Message.MessageTypeID

cata_sun

Hello,

I use Sql Compare to synchronize 2 databases. In some situations Sql Compage give me some warnings of type RedGate.SQLCompare.Engine.Message. One property of RedGate.SQLCompare.Engine.Message is MessageTypeID (one possible value is TableColumnDropDataLoss). I thought that the type of MessageTypeID is some kind of enum but that's not the case, it's type is string. I would like to have the complete set of values for this property, this can help me to decide which warnings are important and which are not. I looked into the documentation but I found nothing on this subject. Can you help me with the list of possibles values or some api (if this exists)?

Thank you,

Best regards,
Catalin

David E

Hi Catalin,

Below is an extract of the warning IDs and the messages we display within SQL Compare, I hope it helps. We can not guarantee that these IDs will not change in the future as we improve the product.

Regards,
David

 TargetUnsupportedSynonym 
 The synonym {0} is not supported in the target database version.

 TargetUnsupportedXMLSchemaCollection
 The XML schema collection {0} is not supported in the target database version.

 TargetUnsupportedAssembly
 The CLR assembly {0} is not supported in the target database version.
 
 TargetUnsupportedMessageType 
 The message type {0} is not supported in the target database version. 
 
 TargetUnsupportedContract 
 The contract {0} is not supported in the target database version. 
 
 TargetUnsupportedQueue 
 The queue {0} is not supported in the target database version. 
 
 TargetUnsupportedService 
 The service {0} is not supported in the target database version. 
 
 TargetUnsupportedRoute 
 The route {0} is not supported in the target database version. 
 
 TargetUnsupportedEventNotification 
 The event notification {0} is not supported in the target database version. 
 
 TargetUnsupportedDdlTrigger 
 The DDL trigger {0} is not supported in the target database version. 
 
 TargetUnsupportedPartitionFunction 
 The partition function {0} is not supported in the target database version. 
 
 TargetUnsupportedPartitionScheme 
 The partition scheme {0} is not supported in the target database version. 
 
 TargetUnsupportedServiceBinding 
 The service binding {0} is not supported in the target database version. 
 
 TargetUnsupportedSchema 
 The schema {0} is not supported in the target database version. 
 
 TargetUnsupportedCertificate 
 The certificate {0} is not supported in the target database version. 
 
 TargetUnsupportedSymmetricKey 
 The symmetric key {0} is not supported in the target database version. 
 
 TargetUnsupportedAsymmetricKey 
 The asymmetric key {0} is not supported in the target database version. 
 
 TargetUnsupportedPermission 
 Permission for {0} on {1} {2} is not supported in the target database. 
 
 TargetUnsupportedCLRProcedure 
 The CLR stored procedure {0} is not supported in the target database version. 
 
 TargetUnsupportedCLRFunction 
 The CLR function {0} is not supported in the target database version. 
 
 TargetUnsupportedCLRTrigger 
 The CLR trigger {0} on {1} is not supported in the target database version. 
 
 TargetUnsupportedXMLIndex 
 The XML index {0} on {1} is not supported in the target database version. 
 
 TargetUnsupportedCLRUDT 
 The CLR user defined type {0} is not supported in the target database version. 
 
 FilegroupsForObjects 
 Objects need to be created using one or more non-standard filegroups. These filegroups may need to be created manually: {0} 
 
 FilegroupsForTables 
 Tables need to be created using one or more non-standard filegroups. These filegroups may need to be created manually: {0} 
 
 TableRebuildDueToFilegroup 
 The filegroup of table {0} has changed. The table must be rebuilt. The data in the table apart from dropped columns will be preserved. 
 
 TableRebuildDueToTextFilegroup 
 The text filegroup of table {0} has changed. The table must be rebuilt. The data in the table apart from dropped columns will be preserved. 
 
 TableRebuildDueToPartitioning 
 The partitioning of table {0} has changed in a way that requires a table rebuild. The data in the table apart from dropped columns will be preserved. 
 
 TableRebuildDueColumnAlter 
 Cannot alter column {0} to {1} on table {2}. The table must be rebuilt. The data in the table apart from dropped columns will be preserved. 
 
 TableRebuildDueIdentityAlter 
 Cannot alter IDENTITY property on column [{0}] on table {1}. The table must be rebuilt. The data in the table apart from dropped columns will be preserved. 
 
 TableRebuildDueIdentityChange 
 The IDENTITY column on table {0} has changed. The table must be rebuilt. The data in the table apart from dropped columns will be preserved. 
 
 TableRebuildDueNotForReplication 
 Cannot alter NOT FOR REPLICATION property on column [{0}] on table {1}. The table must be rebuilt. The data in the table apart from dropped columns will be preserved. 
 
 TableRebuildDueClrDependence 
 The column [{0}] on table {1} depends on a CLR type that has been modified. The table must be rebuilt. The data in the table apart from dropped columns will be preserved. 
 
 TableRebuildDueColumnOrderChange 
 The column order in table {0} has changed. The table must be rebuilt. The data in the table apart from dropped columns will be preserved. 
 
 TableRebuildDuePersistedReference 
 The column [{0}] on table {1} is a persisted computed column that references columns that need to be rebuilt. The table must be rebuilt. The data in the table apart from dropped columns will be preserved. 
 
 ClrTypeUnbindNotPossible 
 The CLR type {0} needs to be unbound from dependent tables, but this is not possible without data loss. If the tables in question are not selected explicitly the script may fail. 
 
 SchemaDrop 
 Dropping a schema is a potentially dangerous operation. Dependencies for the {0} schema are not selected automatically. If you are sure you want to drop this schema please select the objects that belong to this schema manually. 
 
 PartitionSchemeDrop 
 Dropping a partition scheme is a potentially dangerous operation. Dependencies for the {0} partition scheme are not selected automatically. If you are sure you want to drop this partition scheme please select the objects that use this partition scheme manually. 
 
 PartitionFunctionDrop 
 Dropping a partition function is a potentially dangerous operation. Dependencies for the {0} partition function are not selected automatically. If you are sure you want to drop this partition function please select the objects that use this partition function manually. 
 
 UserDrop 
 Dropping a user is a potentially dangerous operation. Dependencies for the {0} user are not selected automatically. If you are sure you want to drop this user please select the objects that belong to this user manually. 
 
 UdtDrop 
 Dropping a user defined type is a potentially dangerous operation. Dependencies for the {0} type are not selected automatically. If you are sure you want to drop this user defined type please select the objects that belong to this user defined type manually. 
 
 NondecryptableTrigger 
 The trigger {0} cannot be decrypted in one or more of the datasources. Its contents cannot be compared and it cannot be synchronized. 
 
 NondecryptableDdlTrigger 
 The DDL trigger {0} cannot be decrypted in one or more of the datasources. Its contents cannot be compared and it cannot be synchronized. 
 
 NondecryptableFunction 
 The function {0} cannot be decrypted in one or more of the datasources. Its contents cannot be compared and it cannot be synchronized. 
 
 NondecryptableFunctionDeps 
 The function {0} cannot be decrypted in one or more of the datasources. Its dependencies cannot be exactly identified. The script may fail. 
 
 NondecryptableView 
 The view {0} cannot be decrypted in one or more of the datasources. Its contents cannot be compared and it cannot be synchronized. 
 
 NondecryptableViewDeps 
 The view {0} cannot be decrypted in one or more of the datasources. Its dependencies cannot be exactly identified. The script may fail. 
 
 NondecryptableProcedure 
 The procedure {0} cannot be decrypted in one or more of the datasources. Its contents cannot be compared and it cannot be synchronized. 
 
 NondecryptableProcedureDeps 
 The procedure {0} cannot be decrypted in one or more of the datasources. Its dependencies cannot be exactly identified. The script may fail. 
 
 FunctionReturnTypeChange 
 The function {0} has changed its type. It must be dropped and recreated. 
 
 CertificateCannotBeRecreated 
 The certificate [{0}] cannot be recreated. The script may fail. 
 
 SymmetricKeyCannotBeRecreated 
 The symmetric key [{0}] cannot be recreated. The script may fail. 
 
 SymmetricKeyCannotBeCompared 
 The contents of symmetric keys cannot be compared. SQL Compare will only compare the owner and the permissions if required for [{0}]. 
 
 XMLSchemaRebuildForTables 
 The XML schema collection {0} needs to be rebuilt. It will be unbound from the {1} column of the {2} table. After the rebuild the XML schema collection will be rebound to the table. The data in the table will be preserved. 
 
 XMLSchemaRebuildForNonTables 
 The XML schema collection {0} needs to be rebuilt. The dependent {1} will also be rebuilt. Data will be preserved. 
 
 TableAddColumnNoDefaultNoNull 
 This deployment adds the column [{0}] to table {1} as NOT NULL, with no default value specified. The table will be rebuilt. Any data in the table will cause the deployment to fail, unless a migration script covers the change. 
 
 TableAddColumnNoNullWithDefault 
 The column [{0}] on table {1} must be added and does not allow NULL values. The default {2} must be bound to it. The table must be rebuilt. The data in the table will be preserved. 
 
 UserWithCorruptLoginInSource 
 The user {0} does not have an associated login. If the user was not defined with WITHOUT LOGIN then the source database is in an inconsistent state. Please fix this by using sp_change_users_login. 
 
 UserWithCorruptLoginInTarget 
 The user {0} does not have an associated login. If the user was not defined with WITHOUT LOGIN then the target database is in an inconsistent state. Please fix this by using sp_change_users_login. 
 
 UserWithDefaultPasswdCreated 
 If the user {0} is not defined then it will be created with a default password of 'p@ssw0rd'. 
 
 UserWithUnsyncableDiffs 
 The user {0} has properties that cannot be synchronized. 
 
 RolesCreatePassword 
 The application role {0} will be created with a default password of 'p@ssw0rd' 
 
 FullTextMakeSureEnabled 
 Full text information is being added to the database, but the database might not be full text enabled (possibly because it has recently been restored from a backup). Make sure any full text catalogs have been rebuilt before running the script. 
 
 StatisticsCreate 
 Creating statistics [{0}] on {1}. When deploying statistics, the SAMPLE option isn’t supported. If you're deploying statistics that use SAMPLE, you'll need to manually modify the deployment script for those objects. 
 
 ColumnFieldTruncated 
 This deployment truncates the column [{0}] on table {1}. To mitigate this, make sure a migration script covers the change. 
 
 ColumnFieldNotNullDefault 
 The column [{0}] on table {1} is being marked as NOT NULL. The default value will be applied where appropriate. 
 
 ColumnFieldNotNullNoDefault 
 This deployment alters the column [{0}] on table {1} to NOT NULL, with no default value specified. Any NULLs in the column will cause the deployment to fail, unless a migration script covers the change. 
 
 ColumnCastToNonSystemType 
 The column [{0}] on table {1} cannot be cast to {2} because it is not a system type. The script may fail. 
 
 ColumnCastCannotDo 
 The column [{0}] on table {1} cannot be cast from {2} to {3}. The script may fail. 
 
 ColumnCastPrecisionLossableType 
 This deployment casts the column [{0}] on table {1} from {2} to {3}. Any data that exceeds the new column size might lose precision, or the deployment could fail. To avoid this, make sure a migration script covers the change. 
 
 TargetUnsupportedFulltextView 
 The fulltext index on view {0} is not supported in the target database version. 
 
 TargetUnsupportedSparseField 
 The sparse property on column {0} in table {1} is not supported in the target database version. 
 
 TargetUnsupportedColumnSet 
 The column set property on column {0} in table {1} is not supported in the target database version. 
 
 TableRebuildDueFilestream 
 Table {0} contains filestream data in column {1}. The table must be rebuilt. The data in the table apart from dropped columns will be preserved. 
 
 TableRebuildDueToFilestreamFilegroup 
 The filestream filegroup of table {0} has changed. The table must be rebuilt. The data in the table apart from dropped columns will be preserved. 
 
 TargetUnsupportedFilestream 
 The filestream property on column {0} in table {1} is not supported in the target database version. 
 
 TableRebuildDueColumnSet 
 Cannot add column set on field {0} to table {1}. The table must be rebuilt. The data in the table apart from dropped columns will be preserved. 
 
 TargetUnsupportedDatatype 
 The type {0} on object {1} is not supported in the target database version. 
 
 TargetUnsupportedFunctionParameterDatatype 
 The datatype of the parameter {0} of function {1} is not supported in the target database version. 
 
 TargetUnsupportedFunctionReturnDatatype 
 The datatype of the return parameter of function {0} is not supported in the target database version. 
 
 TargetUnsupportedStoredProcParameterDatatype 
 The datatype of the parameter {0} of stored procedure {1} is not supported in the target database version. 
 
 TargetUnsupportedFilteredIndex 
 The filter condition on index {0} on table {1} is not supported in the target database version. 
 
 TargetUnsupportedFulltextStoplist 
 The full text stoplist {0} is not supported in the target database version. 
 
 TableRebuildFieldsDropped 
 Couldn't match the column [{0}] on table {1} to a column in the source table. To preserve any data in the target column, make sure a migration script covers the change. 
 
 TableRebuildFieldsNullToDefault 
 Column [{0}] on table {1} no longer allows NULL values, but it has a new default set up. During the table rebuild such NULL values will be changed to the new default value. 
 
 ChangeTrackingMakeSureEnabled 
 Table change tracking is being added to table {0}. Make sure database change tracking is enabled before running this script. 
 
 TargetUnsupportedChangeTracking 
 The change tracking on table {0} is not supported in the target database version. 
 
 TableRebuildComputedColumnNotPreserved 
 Column [{0}] on table {1} is being changed from a computed to a normal column. The computed column data will not be migrated during the rebuild. 
 
 UserCreatedWithoutLogin 
 Can't create login for user {0}. User will be created without login. 
 
 TargetUnsupportedRowGuidCol 
 The ROWGUIDCOL property on column {0} of table {1} is not supported in the target database version and will be ignored. This will break any code that refers to that column via the property! 
 
 TargetUnsupportedDefault 
 The default {0} is not supported in the target database version. 
 
 TargetUnsupportedRule 
 The rule {0} is not supported in the target database version. 
 
 TargetUnsupportedApplicationRole 
 The application role {0} is not supported in the target database version. 
 
 TargetUnsupportedFullTextCatalog 
 The full text catalog {0} is not supported in the target database version. 
 
 TargetUnsupportedExtendedProperties 
 Extended properties are not supported in the target database version. 
 
 TargetUnsupportedFileGroupClause 
 Filegroups are not supported in the target database version. 
 
 TargetUnsupportedFillFactorOption 
 The FillFactor for index {0} will be ignored. The FillFactor option is not supported in the target database version. 
 
 TargetUnsupportedNotForReplication 
 The not for replication property on column {0} in table {1} is not supported in the target database version. 
 
 TargetPartiallySupportedCreateUserStatement 
 The create user statement must be the only statement in a batch for Microsoft Azure SQL Database. 
 
 TargetUnsupportedUserType 
 The user type {0} is not supported in the target database version. 
 
 TargetUnsupportedUseStatement 
 The use statement is not supported in the target database version. 
 
 TargetUnsupportedWithAppendOption 
 The trigger {0} contains the WITH APPEND clause which is not supported in the target database version. 
 
 TargetUnsupportedMultiPartName 
 The synonym {0} references a 3 or 4 part name which is not supported in the target database version. 
 
 TargetUnsupportedDataCompression 
 The table {0} uses data compression which is not supported in the target database version. 
 
 TargetUnsupportedEncryption 
 Encryption is not supported for object {0} in the target database version. 
 
 LoginMayNotExistForUser 
 The login for user {0} may not exist in the target database. 
 
 TableColumnDropDataLoss 
 This deployment drops the column(s) {0} from table {1}. To preserve any data in these column(s), make sure a migration script covers the change. 
 
 TableDropDataLoss 
 This deployment drops the table {0}. To preserve any data in this table, make sure a migration script covers the change. 
 
 OwnerMappingsIgnored 
 When using migration scripts owner mappings will be ignored. 
 
 TableMappingsIgnored 
 When using migration scripts table mappings will be ignored. 
 
 SequenceRestarting 
 The sequence {0} needs to be restarted as the current start value falls outside of the new range.  
 
 TargetUnsupportedColumnstoreIndex 
 The columnstore index {0} on table {1} is not supported in the target database version. 
 
 TargetUnsupportedClusteredColumnstoreIndex 
 The clustered columnstore index {0} on table {1} is not supported in the target database version. 
 
 TargetUnsupportedFiletable 
 The filetable {0} is not supported in the target database version. 
 
 TargetUnsupportedSequence 
 The sequence object {0} is not supported in the target database version. 
 
 TargetUnsupportedSearchPropertyList 
 The search property list {0} is not supported in the target database version. 
 
 TargetUnsupportedSecurityPolicy 
 The security policy {0} is not supported in the target database version. 
 
 TargetDeprecatedWithAppendOption 
 The trigger {0} contains the WITH APPEND clause which is deprecated in the target database version. 
 
 PlugForMigrations 
 You can use a migration script in SQL Source Control to solve this problem 
 
 TargetUnsupportedLockEscalation 
 LOCK_ESCALATION on table {0} is not supported in the target database version. 
 
 TargetUnsupportedTypeIndex 
 The user type {0} can't have indexes in database versions older than SQL Server 2014. 
 
 TargetServerMemoryOptimizedFileGroup 
 This deployment includes one or more memory-optimized objects (memory-optimized tables, natively compiled stored procedures or memory-optimized table types). Make sure that your target database has a memory-optimized filegroup. 
 
 TargetDatabaseUnsupportedMemoryOptimizedTables 
 The memory-optimized table {0} is not supported in database versions older than SQL Server 2014 or in Microsoft Azure SQL Databases. 
 
 AsymmetricKeyCannotBeRecreated 
 The asymmetric key [{0}] cannot be recreated. The script may fail. 
 
 TargetDatabaseUnsupportedNativelyCompiledStoredProcedures 
 The natively compiled stored procedure {0} is not supported in database versions older than SQL Server 2014 or in Microsoft Azure SQL Databases. 
 
 StrongDependenciesNotDeployed 
 The following objects that reference, or are referenced by, the objects you want to deploy aren’t included in the deployment:

{0}

If you don't include these referenced objects, the deployment script may fail or produce unexpected results. 
 
 TargetUnsupportedStatisticIncremental 
 The STATISTICS_INCREMENTAL option for indexes and the INCREMENTAL option for statistics aren't supported in previous versions of SQL Server (SQL Server 2012 and earlier) and Microsoft Azure SQL Database. The deployment script will not include the incremental statistics option for {0} on {1}. 
 
 TargetUnsupportedMemoryOptimizedUserDefinedTableTypes 
 The memory-optimized user-defined table type {0} is not supported in the target database version. 
 
 PreviousFailedDeploymentDetected 
 The target database includes a table that was recovered from a failed SQL Compare deployment. You can use recovery tables to restore data lost in a failed deployment. 
 
 SequenceValueWillBeRestarted 
 The deployment will restart the sequence {0} in the target database with the starting value of the sequence in the source database.
    
If you want to preserve the value of the sequence in the target database, you'll need to modify the script to run the following:

ALTER SEQUENCE {0} RESTART WITH <value from the source database> 
 
 DeploymentOfMemoryOptimizedObjectsInTransaction 
 You’re attempting to deploy one or more memory-optimized objects (memory-optimized tables, natively compiled stored procedures or memory-optimized table types) in a transaction, which is not supported by SQL Server.  

If you want to deploy memory-optimized objects, you need to select the 'Do not use transactions in deployment scripts' project option.
 
 
 TargetUnsupportedTableType 
 The user defined table type {0} is not supported in the target database version. 
 
 NoTransactionsAndNoBackup 
 This deployment will run without transactions. This could leave your database in an inconsistent state if it fails.  We recommend backing up the database as part of the deployment, or enabling transactions. 
 
 StatisticIncrementalWithIgnoreFileGroups 
 Indexes using the STATISTICS_INCREMENTAL option and statistics using the INCREMENTAL option are only supported on partitioned tables.

The 'Ignore filegroups, partition schemes and partition functions' option is selected, so partition schemes will be ignored. This may cause the deployment of {0} on {1} to fail.

To stop ignoring partition schemes, clear the 'Ignore filegroups, partition schemes and partition functions' option.
 
 
 TargetUnsupportedSelectiveXmlIndex 
 The selective XML index {0} on {1} is not supported in the target database version. 
 
 ObjectsMayDependOnFullTextIndex 
 Full-text indexes can't be deployed in transactions, so SQL Compare will deploy changes to full-text indexes after transactions are complete. If other objects rely on changes to full-text indexes (using CONTAINS, FULLTEXT, CONTAINSTABLE or FREETEXTTABLE), the script may fail.

We recommend you select the 'Do not use transactions in deployment scripts' project option when deploying full-text indexes. 
 
 TargetUnsupportedIncludedColumnsOnIndexes 
 The Included columns for index {0} will be ignored. The Included column option is not supported in the target database version. 
 
 TableRebuildDueRemoteDataArchiveRemoval 
 The deployment will disable Stretch Database on the {0} table. To do this, SQL Compare will download the table's remote data from Azure and then rebuild the table. Downloading remote data may cause the deployment to take a long time. 
 
 TargetUnsupportedDynamicDataMasking 
 The masking function for column {0} will be ignored. The dynamic data masking option is not supported in the target database version. 
 
 TargetUnsupportedStretchDatabase 
 The REMOTE_DATA_ARCHIVE option on table {0} is not supported in the target database version. 
 
 StretchDatabaseMakeSureEnabled 
 The deployment includes stretch tables but Stretch Database isn't enabled on the target database. Make sure Stretch Database is enabled on the target database before you run the deployment script. 
 
 TableRebuildDueAlterWithRemoteDataArchive 
 The deployment will alter the stretch table {0}. To do this, SQL Compare will download the table's remote data from Azure and then rebuild the table. Downloading remote data may cause the deployment to take a long time.