How can we help you today? How can we help you today?
awaneesh.pandey
Activity overview Badges (0) Posts (1) Comments (1)

Activity overview

Latest activity by awaneesh.pandey

Hello Brian, Thanks for your reply. We got this error while using the Red-Gate toolkit bundle as well as the SQL Datacomapre 5.2. commercial release both. Intially we got the error in the .net code then we tried with the commercial relase & the got the same error. I have the screen shot for the error but i don't have any means to attach the image for the error over here. As i said that this error occurs only during the update of a DB having a table with 'ntext' datatype. And that to be the fauilre occurs only for insert script not for the update script. Intially when there is no data into the table then the insert works fine but if we have some data into it & try to synchronize for adding the new data & updating the old data in the target database then this error flashese. Please let me know some email id so that i can send you the error screen for your reference. Also the .Net code snippet & the table script in which we are getting error as below: Code Snippet 1. First we are excluding the entire table mapping tablemappings.CreateMappings(dbCompareSource.Tables, dbCompareDestination.Tables) For counter = 0 To tablemappings.Count - 1 tablemappings(counter).Include = False Next 2. Calling a function with the where condition and comparison columns and include that table in the table mapping The function has the follwing code For Each mapping In mappings If (mapping.Obj1.Name = tablename) Then If (ComparisionColumns <> "") Then mapping.MatchingMappings.Clear() strarr = ComparisionColumns.Split(",") For Each columnnames As String In strarr mapping.MatchingMappings.Add(mapping.FieldMappings(columnnames)) Next mapping.RefreshMappingStatus() If CheckTargetRecord(tablename, Batchid) > 0 Then If Not (mapping.IndexMappings.PrimaryKey Is Nothing) Then For counter = 0 To mapping.IndexMappings.PrimaryKey.Obj1.Fields.Count - 1 mapping.FieldMappings(mapping.IndexMappings.PrimaryKey.Obj1.Fields(counter).Name).Include = False Next End If For counter = 0 To mapping.Obj1.Fields.Count - 1 If (mapping.Obj1.Fields(counter).Identity = True) Then mapping.FieldMappings(mapping.Obj1.Fields(counter).Name).Include = False End If Next End If If Trim(condition) <> "" Then mapping.Where = New WhereClause(condition) If blDataAppend = False Then DeleteRecords(tablename, condition, Batchid) End If End If mapping.Include = True End If Exit For End If Next 3. Then finally we are comparing the two databases with the new mappings and generating the script. The script generated has the MISSING value. DataSession.CompareDatabases(dbCompareSource, dbCompareDestination, tablemappings, SessionSettings.IncludeRecordsInOne + SessionSettings.IncludeDifferentRecords) block = DataProvider.GetMigrationSQL(DataSession, True) Script of the Table CREATE TABLE [dbo].[cfgReport]( [ReportID] [int] IDENTITY(1,1) NOT NULL, [UserID] [int] NULL, [ReportName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ReportClassName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ReportDescription] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [SchemaName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_cfgReport_DefaultQueryColumn] DEFAULT (1), [PackageType] [nvarchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ReportModule] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ReportType] [nvarchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ReportTypeSub1] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ReportXml] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DefaultQuery] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DefaultQueryLink] [nvarchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_cfgReport_DefaultQueryLink] DEFAULT (N'all'), [DefaultQueryColumn] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DefaultQueryOperator] [nvarchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_cfgReport_DefaultQueryOperator] DEFAULT (N'Equal'), [QueryRequired] [bit] NOT NULL CONSTRAINT [DF_cfgReport_QueryRequired] DEFAULT (1), [OrderBy] [nvarchar](1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [MasterSuretyID] [int] NULL CONSTRAINT [DF_cfgReport_MasterSuretyID] DEFAULT (0), [DeleteFlag] [bit] NULL CONSTRAINT [DF_cfgReport_DeleteFlag] DEFAULT (0), CONSTRAINT [PK_cfgReport] PRIMARY KEY CLUSTERED ( [ReportID] ASC ) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] Thanks, -Awaneesh / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. "Invalid Column Name 'MISSING'"- Error while executing block
Hello Brian, Thanks for your reply. We got this error while using the Red-Gate toolkit bundle as well as the SQL Datacomapre 5.2. commercial release both. Intially we got the error in the .net code...
0 votes
"Invalid Column Name 'MISSING'"- Error while executing block
  1. Community
  2. SQL Data Compare Previous Versions
Hello, We are facing a very weird error while updating a database getting records inserted into the target database. The error we get is " Invalid Column Name 'MISSING'". And the data copy into th...
2 followers 3 comments 0 votes
Total activity
3
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1