| Author |
Topic |
|
gsgill76
Posting Yak Master
137 Posts |
 Posted - 2006-10-19 : 02:00:23
|
| Hi I am tried to compare two tables with tablediff (replication) utility.Table Structure is as USE [PMSTEMP]CREATE TABLE [dbo].[GROUPS]( [G_CAT] [varchar](15) COLLATE Latin1_General_CS_AI NOT NULL, [G_NAME] [varchar](30) COLLATE Latin1_General_CS_AI NULL, [G_MAIL] [varchar](40) COLLATE Latin1_General_CS_AI NULL, [G_STAMPDUTY] [smallint] NULL, [G_NO_INTER] [smallint] NULL, [ROWID] [timestamp] NOT NULL,PRIMARY KEY CLUSTERED ( [G_CAT] ASC)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]INSERT INTO [dbo].[GROUPS] ([G_CAT], [G_NAME], [G_MAIL], [G_STAMPDUTY], [G_NO_INTER]) VALUES ('DH', 'GENERAL', NULL, 1, NULL)INSERT INTO [dbo].[GROUPS] ([G_CAT], [G_NAME], [G_MAIL], [G_STAMPDUTY], [G_NO_INTER]) VALUES ('DZ1', 'MAIN BROKER', NULL, 1, NULL)INSERT INTO [dbo].[GROUPS] ([G_CAT], [G_NAME], [G_MAIL], [G_STAMPDUTY], [G_NO_INTER]) VALUES ('DZ2', 'EXCHANGES', NULL, 0, NULL) Other DB Table Structure isUSE [PMSRESTORE]CREATE TABLE [dbo].[GROUPS]( [G_CAT] [varchar](15) COLLATE Latin1_General_CS_AI NOT NULL, [G_NAME] [varchar](30) COLLATE Latin1_General_CS_AI NULL, [G_MAIL] [varchar](40) COLLATE Latin1_General_CS_AI NULL, [G_STAMPDUTY] [smallint] NULL, [G_NO_INTER] [smallint] NULL, [ROWID] [timestamp] NOT NULL,PRIMARY KEY CLUSTERED ( [G_CAT] ASC)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]INSERT INTO [dbo].[GROUPS] ([G_CAT], [G_NAME], [G_MAIL], [G_STAMPDUTY], [G_NO_INTER]) VALUES ('DH', 'GENERAL', NULL, 1, NULL)INSERT INTO [dbo].[GROUPS] ([G_CAT], [G_NAME], [G_MAIL], [G_STAMPDUTY], [G_NO_INTER]) VALUES ('DZ1', 'MAIN BROKER', NULL, 1, NULL)INSERT INTO [dbo].[GROUPS] ([G_CAT], [G_NAME], [G_MAIL], [G_STAMPDUTY], [G_NO_INTER]) VALUES ('DZ2', 'EXCHANGES', NULL, 0, NULL)These code show both tables having same structure & data, when I issue command at command prompt as:"C:\Program Files\Microsoft SQL Server\90\COM\tablediff" -sourceserver VSNET1 -sourceuser sa -sourcepassword sysadm -sourcedatabase PMSTEMP -sourcetable GROUPS -destinationserver VSNET1 -destinationuser sa -destinationpassword sysadm -destinationdatabase PMSRESTORE -destinationtable GROUPS -f C:\Diff_between_PMSTEMP_and_PMSRESTORE\Diff_GROUPSThis return the output file as:-- Host: VSNET1-- Database: [PMSRESTORE]-- Table: [dbo].[GROUPS]-- Column(s) ROWID are not included in this script because they are of type(s) text, ntext, varchar(max), nvarchar(max), varbinary(max), image, timestamp, or xml. Columns of these types cannot be updated by tablediff utility scripts; therefore non-convergence of data can still occur after this script has been applied. If the tablediff utility output references any of these columns, you must update the columns manually if you want them to converge.-- unable to create UPDATE for record with only large data types-- [G_CAT] = 'DH'-- unable to create UPDATE for record with only large data types-- [G_CAT] = 'DZ1'-- unable to create UPDATE for record with only large data types-- [G_CAT] = 'DZ2'I don’t understand the last six lines, although they are comment out, but I just want to know why they are so. What does they want to say? What its mean?Regards,Thanks.Gurpreet S. Gill |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-10-19 : 11:41:09
|
| You specified the -f parameter, which tells the utility to generate a T-SQL file to fix the subscriber so it matches the publisher. I think that message is saying that it was unable to generate the script due to the large data type columns in the table. |
 |
|
|
gsgill76
Posting Yak Master
137 Posts |
Posted - 2006-10-20 : 00:53:45
|
| hi snSQLI know about -f switch, but the thing is i dont have any large data type in my table, structure you can see, then why i am getting this.Regards,Thanks.Gurpreet S. Gill |
|
|
|
|
|
|
TableDiff Problem