Competition: What’s your favorite Redgate tool? Enter now.

Unable to update data.

Adrian EatonAdrian Eaton Posts: 2
edited August 14, 2006 11:12AM in SQL Packager Previous Versions
I am getting this error message when trying to update the data from one table between two servers.

There are no updateable columns in the table [dbo].[xSecurityFunctions] even though differences exist these cannot be sychronised.

What does this mean and is there a way to get around the problem.

I am using SQL Packager version 5.2.5.0

This is the Schema of the table.

CREATE TABLE [xSecurityFunctions] (
[FunctionId] [int] NOT NULL ,
[Name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Description] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Hide] [bit] NOT NULL CONSTRAINT [DF_xSecurityFunctions_Hide] DEFAULT (0),
[TimeStamp] [timestamp] NOT NULL ,
[CreatedDate] [datetime] NOT NULL CONSTRAINT [DF_xSecurityFunctions_CreatedDate] DEFAULT (getdate()),
[Createdby] [int] NOT NULL CONSTRAINT [DF_xSecurityFunctions_Createdby] DEFAULT (0),
[UpdatedDate] [datetime] NOT NULL CONSTRAINT [DF_xSecurityFunctions_UpdatedDate] DEFAULT (getdate()),
[UpdatedBy] [int] NOT NULL CONSTRAINT [DF_xSecurityFunctions_UpdatedBy] DEFAULT (0),
CONSTRAINT [PK_xSecurityFunctions] PRIMARY KEY CLUSTERED
(
[FunctionId]
) WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    I'd assume it means that the only difference that Packager found in the table was in the timestamp column, and timestamp columns, by their nature, can't be synchronized. There should be an option in the 'data options' tab of the SQL Packager options to include timestamp columns, so you should turn that off and it should prevent the error message.
Sign In or Register to comment.