Progress % display issue

jmeyerjmeyer Posts: 70 Bronze 2
edited November 29, 2016 12:34PM in SQL Data Compare
When refreshing tables in the "tables & views" dialog box I regularly see the progress indicators display percentages of more than 100% in some case 5000% and more. I can reproduce this by running the script below in the TEMPDB of two servers and then have DataCompare refresh the tales/views list. I apologize for the long script
USE tempdb;
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO

IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'[dbo].[Test]')
                    AND type IN (N'U') )
  DROP TABLE dbo.Test;
GO

CREATE TABLE [dbo].[Test](
	[WHSE_ID] [int] IDENTITY(1,1) NOT NULL,
	[BSSN] [char](9) NULL,
	[SEQ] [tinyint] NULL,
	[grcend] [date] NULL,
	[MOSDISGR] [tinyint] NULL,
	[TERMEND] [date] NULL,
	[TERMBEG] [date] NULL,
	[GUARREF] [varchar](12) NULL,
	[ORIGSCL] [char](8) NULL,
	[SCYPGA] [char](2) NOT NULL,
	[SCYPGATXT] [varchar](20) NOT NULL,
	[PROGRAM] [char](6) NOT NULL,
	[REGCAT] [char](7) NOT NULL,
	[LENDER] [char](8) NOT NULL,
	[GUARANTOR] [char](6) NOT NULL,
	[STUSSN] [char](9) NOT NULL,
	[DISBDT1] [date] NOT NULL,
	[GRADE] [char](2) NOT NULL,
	[GRADETXT] [varchar](20) NOT NULL,
	[SCYPGMYR] [char](1) NOT NULL,
	[SCYPGMYRTXT] [varchar](20) NOT NULL,
	[HOSPITAL] [char](3) NOT NULL,
	[HOSPITALTXT] [varchar](20) NOT NULL,
	[CURROWN] [char](8) NOT NULL,
	[LOANADD] [date] NULL,
	[RULE78] [decimal](9, 2) NOT NULL,
	[DAYSREMGRC] [smallint] NOT NULL,
	[DAYSENROL] [smallint] NOT NULL,
	[REPAYBEGIN] [date] NULL,
	[DAYSINREPAY] [smallint] NULL,
	[MOSINREPAY] [smallint] NULL,
	[PGASHO] [varchar](20) NOT NULL,
	[GTRSHO] [varchar](20) NOT NULL,
	[CURPRIN] [decimal](9, 2) NOT NULL,
	[CURINT] [decimal](9, 2) NOT NULL,
	[GOVINT] [decimal](9, 2) NOT NULL,
	[CUROTHR] [decimal](9, 2) NOT NULL,
	[AVGDAYBAL] [decimal](9, 2) NOT NULL,
	[PREVPRIN] [decimal](9, 2) NOT NULL,
	[PREVINT] [decimal](9, 2) NOT NULL,
	[PREVGOVINT] [decimal](9, 2) NOT NULL,
	[PREVOTHR] [decimal](9, 2) NOT NULL,
	[BFIRST] [varchar](30) NOT NULL,
	[BMID] [varchar](13) NOT NULL,
	[BLAST] [varchar](30) NOT NULL,
	[BSUFFIX] [char](5) NOT NULL,
	[BBIRTH] [date] NULL,
	[SFIRST] [varchar](13) NOT NULL,
	[SMID] [varchar](13) NOT NULL,
	[SLAST] [varchar](30) NOT NULL,
	[SSUFFIX] [char](5) NOT NULL,
	[BADD1] [varchar](50) NOT NULL,
	[BADD2] [varchar](50) NOT NULL,
	[BADD3] [varchar](50) NOT NULL,
	[BCITY] [varchar](64) NOT NULL,
	[BSTATE] [char](2) NOT NULL,
	[BZIP] [char](9) NOT NULL,
	[BADDIND] [char](1) NOT NULL,
	[BADDLSTCHG] [date] NOT NULL,
	[BFOREIGNCT] [varchar](50) NOT NULL,
	[BFOREIGNST] [varchar](50) NOT NULL,
	[BPHNEXT] [char](4) NOT NULL,
	[BPHNNUM] [char](4) NOT NULL,
	[BPHNEXC] [char](3) NOT NULL,
	[BPHNARA] [char](3) NOT NULL,
	[BPHNINT1] [char](3) NOT NULL,
	[BPHNINT2] [char](3) NOT NULL,
	[BPHNINT3] [char](4) NOT NULL,
	[BPHNINT4] [char](7) NOT NULL,
	[BPHNIND] [char](1) NOT NULL,
	[SKIPBEG] [date] NULL,
	[COSIGN] [char](1) NOT NULL,
	[COMAKE] [char](1) NOT NULL,
	[COBORR] [char](1) NOT NULL,
	[ENDORS] [char](1) NOT NULL,
	[ORGSCLNM] [varchar](100) NOT NULL,
	[ORGSCLTP] [char](2) NOT NULL,
	[ORGSCLTPTXT] [varchar](50) NOT NULL,
	[ORGSCLPROP] [char](1) NOT NULL,
	[CURSCL] [char](8) NOT NULL,
	[LASTENROLL] [date] NULL,
	[DAYSGRC] [smallint] NOT NULL,
	[DAYSREMENR] [smallint] NOT NULL,
	[CURSCLTYP] [char](2) NOT NULL,
	[CURSCLTYPTXT] [varchar](20) NOT NULL,
	[CURSCLPROP] [char](1) NOT NULL,
	[GUARSCLCDE] [char](8) NOT NULL,
	[CURSCLST] [char](2) NOT NULL,
	[ORGSCLST] [char](2) NOT NULL,
	[FIRSTPAYDUE] [date] NULL,
	[DISCDATE] [date] NULL,
	[NXTINSTDUE] [date] NULL,
	[INTCAPFREQ] [tinyint] NOT NULL,
	[INTCAPFREQTXT] [varchar](15) NOT NULL,
	[REPTYPE] [char](2) NOT NULL,
	[REPTYPETXT] [varchar](50) NOT NULL,
	[INSTLAMT1] [decimal](9, 2) NOT NULL,
	[INSTLAMT2] [decimal](9, 2) NOT NULL,
	[INSTLAMT3] [decimal](9, 2) NOT NULL,
	[INSTLAMT4] [decimal](9, 2) NOT NULL,
	[INSTLAMT5] [decimal](9, 2) NOT NULL,
	[INSTLAMT6] [decimal](9, 2) NOT NULL,
	[INSTLAMT7] [decimal](9, 2) NOT NULL,
	[REPTERM1] [smallint] NOT NULL,
	[REPTERM2] [smallint] NOT NULL,
	[REPTERM3] [smallint] NOT NULL,
	[REPTERM4] [smallint] NOT NULL,
	[REPTERM5] [smallint] NOT NULL,
	[REPTERM6] [smallint] NOT NULL,
	[REPTERM7] [smallint] NOT NULL,
	[INIREPTERM] [smallint] NOT NULL,
	[DISB1AMT] [decimal](9, 2) NOT NULL,
	[TOTDISB] [decimal](9, 2) NOT NULL,
	[TOTINS] [decimal](9, 2) NOT NULL,
	[TOTORGFEE] [decimal](9, 2) NULL,
	[TOTOTHRFEE] [decimal](9, 2) NULL,
	[ORIGPRIN] [decimal](9, 2) NOT NULL,
	[FULLDISB] [char](1) NOT NULL,
	[LASTDISBDATE] [date] NULL,
	[LASTDISBAMT] [decimal](9, 2) NOT NULL,
	[DEFBEG] [date] NULL,
	[DEFEND] [date] NULL,
	[DAYREMDFR] [smallint] NOT NULL,
	[DEFERTYP] [char](2) NOT NULL,
	[DEFERTXT] [varchar](20) NOT NULL,
	[MOSELAPDFR] [smallint] NOT NULL,
	[CURFORBBEG] [date] NULL,
	[CURFORBEND] [date] NULL,
	[DAYFORBREM] [smallint] NOT NULL,
	[FORBTYP] [char](2) NOT NULL,
	[FORBTXT] [varchar](20) NOT NULL,
	[MOSELAPFOR] [smallint] NOT NULL,
	[INIFORBAPP] [char](1) NOT NULL,
	[NUMSUBSFORB] [tinyint] NOT NULL,
	[PRECLAIMSUB] [date] NULL,
	[INICLAIMSUB] [date] NULL,
	[CLAIMREAS] [char](2) NOT NULL,
	[CLAIMREASTXT] [varchar](20) NOT NULL,
	[CLAIMREJDATE] [date] NULL,
	[CLAIMPD] [date] NULL,
	[CLMINTPD] [decimal](9, 2) NOT NULL,
	[CLMPRIPD] [decimal](9, 2) NOT NULL,
	[DAYSAGE] [smallint] NOT NULL,
	[INICLMRESUB] [date] NULL,
	[SUPCLMRESUB] [date] NULL,
	[SUPCLMPD] [date] NULL,
	[SUPPINTPD] [decimal](9, 2) NOT NULL,
	[SUPPRINPD] [decimal](9, 2) NOT NULL,
	[BORRINTPUR] [decimal](9, 2) NOT NULL,
	[BORRPRIPUR] [decimal](9, 2) NOT NULL,
	[DAYSREPCONV] [smallint] NOT NULL,
	[DAYCAPAPPL] [date] NULL,
	[AMTLASTCAP] [decimal](9, 2) NOT NULL,
	[TOTCAPINT] [decimal](9, 2) NOT NULL,
	[NUMDAYINTCAP] [smallint] NOT NULL,
	[INTWRIOFF] [decimal](9, 2) NOT NULL,
	[PRIWRIOFF] [decimal](9, 2) NOT NULL,
	[LASTPMT] [date] NULL,
	[LASTPRIPMT] [decimal](9, 2) NOT NULL,
	[LASTINTPMT] [decimal](9, 2) NOT NULL,
	[ZEROBALCD] [char](2) NOT NULL,
	[ZEROBALTXT] [varchar](20) NOT NULL,
	[ZEROBALSUBCD] [char](2) NOT NULL,
	[ZEROBALSUBTXT] [varchar](20) NOT NULL,
	[ZEROBALAPL] [date] NULL,
	[ZEROBALEFF] [date] NULL,
	[DELQDAYS] [smallint] NOT NULL,
	[DELIQDATE] [date] NULL,
	[DAYSINTDELQ] [smallint] NOT NULL,
	[INTDELQDATE] [date] NULL,
	[CYCLESTAT] [char](2) NOT NULL,
	[CYCLETEXT] [varchar](20) NOT NULL,
	[CYCLESUB] [char](2) NOT NULL,
	[SUBCYCTEXT] [varchar](20) NOT NULL,
	[REMREPAYTERM] [smallint] NOT NULL,
	[CURINSTAMT] [decimal](9, 2) NOT NULL,
	[EXPPAYOFF] [date] NULL,
	[DAYSREMREP] [smallint] NULL,
	[OWNSHO] [varchar](20) NOT NULL,
	[OWNERPARENT] [char](8) NOT NULL,
	[SUPEROWNER] [varchar](20) NOT NULL,
	[OWNERBOND] [char](8) NOT NULL,
	[SECONPORT] [varchar](20) NOT NULL,
	[OWNERSTART] [date] NOT NULL,
	[TAXABLEBOND] [char](1) NOT NULL,
	[SOLDDATE] [date] NULL,
	[SELLER] [char](8) NOT NULL,
	[OWNERST] [char](2) NOT NULL,
	[INTTYPE1] [char](2) NOT NULL,
	[INTTYPE2] [char](2) NOT NULL,
	[INTTYPE3] [char](2) NOT NULL,
	[INTTYPE4] [char](2) NOT NULL,
	[INTTEXT1] [varchar](20) NOT NULL,
	[INTTEXT2] [varchar](20) NOT NULL,
	[INTTEXT3] [varchar](20) NOT NULL,
	[INTTEXT4] [varchar](20) NOT NULL,
	[INTBEGDATE1] [date] NOT NULL,
	[INTBEGDATE2] [date] NULL,
	[INTBEGDATE3] [date] NULL,
	[INTBEGDATE4] [date] NULL,
	[INTENDDATE1] [date] NULL,
	[INTENDDATE2] [date] NULL,
	[INTENDDATE3] [date] NULL,
	[INTENDDATE4] [date] NULL,
	[INTAPPDATE1] [date] NOT NULL,
	[INTAPPDATE2] [date] NULL,
	[INTAPPDATE3] [date] NULL,
	[INTAPPDATE4] [date] NULL,
	[INTRATETYP1] [decimal](5, 3) NOT NULL,
	[INTRATETYP2] [decimal](5, 3) NOT NULL,
	[INTRATETYP3] [decimal](5, 3) NOT NULL,
	[INTRATETYP4] [decimal](5, 3) NOT NULL,
	[SPECINTCOD1] [char](1) NOT NULL,
	[SPECINTCOD2] [char](1) NOT NULL,
	[SPECINTCOD3] [char](1) NOT NULL,
	[SPECINTCOD4] [char](1) NOT NULL,
	[SUBINTTYPE1] [char](1) NOT NULL,
	[SUBINTTYPE2] [char](1) NOT NULL,
	[SUBINTTYPE3] [char](1) NOT NULL,
	[SUBINTTYPE4] [char](1) NOT NULL,
	[SUNINTTEXT1] [varchar](20) NOT NULL,
	[SUNINTTEXT2] [varchar](20) NOT NULL,
	[SUNINTTEXT3] [varchar](20) NOT NULL,
	[SUNINTTEXT4] [varchar](20) NOT NULL,
	[PAYRPD] [int] NOT NULL,
	[FNLDMDBR] [date] NULL,
	[FNLDMDCOS] [date] NULL,
	[PORTAGELN1] [char](3) NOT NULL,
	[PORTAGELN2] [char](3) NOT NULL,
	[PORTRPTLN1] [char](3) NOT NULL,
	[PORTRPTLN2] [char](4) NOT NULL,
	[PORTRPTLN3] [char](2) NOT NULL,
	[PORTRPTLN4] [char](3) NOT NULL,
	[PORTRPTLN5] [char](3) NOT NULL,
	[PORTTIMLIN] [char](3) NOT NULL,
	[CREATEDATE] [date] NOT NULL,
	[LITSTATCOD] [char](2) NOT NULL,
	[DATELITBEG] [date] NULL,
	[NEWLOANIND] [char](1) NOT NULL,
	[LON1OWNRPT] [char](1) NOT NULL,
	[TIERPRICE] [char](3) NOT NULL,
	[AMTGUARANT] [decimal](9, 2) NOT NULL,
	[DATEGUARAN] [date] NULL,
	[MOSREMGRAC] [smallint] NOT NULL,
	[MOSREMDEFR] [smallint] NOT NULL,
	[MOSREMFORB] [smallint] NOT NULL,
	[MOSREMENRO] [smallint] NOT NULL,
	[MOSREMREPA] [smallint] NOT NULL,
	[MOSZEROBAL] [smallint] NOT NULL,
	[MOSINGRACE] [smallint] NOT NULL,
	[MOSENROLLD] [smallint] NOT NULL,
	[MOSINLITIG] [smallint] NOT NULL,
	[SOLDCODE] [char](1) NOT NULL,
	[SOLDTEXT] [varchar](20) NOT NULL,
	[BSTAPPCODE] [char](2) NOT NULL,
	[PRINXFRSAL] [decimal](9, 2) NULL,
	[INTXFRSALE] [decimal](9, 2) NULL,
	[LONSUBSTAT] [char](2) NULL,
	[NEWZEROBAL] [char](2) NOT NULL,
	[NEWZEROTXT] [varchar](20) NOT NULL,
	[NEWZEROSUB] [char](2) NOT NULL,
	[NEWZEROSUBTXT] [varchar](20) NOT NULL,
	[NEWZEROAPPDATE] [date] NULL,
	[NEWZEROEFFDATE] [date] NULL,
	[EMAILADDCD] [char](1) NOT NULL,
	[EMAILADDVF] [date] NULL,
	[EMAILVALID] [char](1) NULL,
	[EMAILADDLN] [tinyint] NULL,
	[EMAILADDTX] [varchar](255) NULL,
	[MSTRPROMCD] [char](1) NOT NULL,
	[MSTRPROMEX] [varchar](10) NOT NULL,
	[MSTRPROMTY] [char](1) NOT NULL,
	[MSTRPROMRE] [char](2) NOT NULL,
	[ORIGSEASON] [char](8) NOT NULL,
	[ALTLOANID] [varchar](17) NOT NULL,
	[COMMONSEQ] [char](4) NOT NULL,
	[PNOTESIGN] [date] NULL,
	[MNOTE] [varchar](11) NULL,
	[MNOTESEQ] [char](4) NULL,
	[REDPGMNM] [char](3) NULL,
	[CAPALLOW] [char](1) NULL,
	[LNOWNNUM] [varchar](17) NULL,
	[CRSCORE] [smallint] NULL,
	[REDPGMTXT] [varchar](20) NULL,
	[ORIGPORT] [varchar](20) NULL,
	[PNOTEYR] [char](7) NULL,
	[PNOTEYRTXT] [varchar](20) NULL,
	[BORACCID] [char](10) NULL,
	[STTUACCID] [char](10) NULL,
	[SERVICERCD] [tinyint] NOT NULL,
	[SERVICERTXT] [varchar](20) NOT NULL,
	[FMCTRUST] [bit] NOT NULL,
	[DATAFILENAME] [varchar](255) NULL,
	[LOADDATE] [smalldatetime] NOT NULL,
	[cm_loan_key] [int] NOT NULL,
	[cm_rule_id] [smallint] NOT NULL,
	[totmosindefer] [tinyint] NULL,
	[totmosinforb] [tinyint] NULL,
	[cm_guarantor] [char](6) NOT NULL,
	[CSSN] [char](9) NULL,
	[CACCID] [char](10) NULL,
	[CFIRST] [varchar](30) NULL,
	[CMID] [varchar](13) NULL,
	[CLAST] [varchar](30) NULL,
	[CSUFFIX] [char](5) NULL,
	[CBIRTH] [date] NULL,
	[CADD1] [varchar](50) NULL,
	[CADD2] [varchar](50) NULL,
	[CADD3] [varchar](50) NULL,
	[CCITY] [varchar](64) NULL,
	[CSTATE] [char](2) NULL,
	[CZIP] [char](9) NULL,
	[CADDIND] [char](1) NULL,
	[CADDLDT] [date] NULL,
	[CADDFLG] [char](1) NULL,
	[CPHNARA] [char](3) NULL,
	[CPHNEXC] [char](3) NULL,
	[CPHNNUM] [char](4) NULL,
	[CPHNEXT] [char](5) NULL,
	[CPHNIND] [char](1) NULL,
	[CEMAILADDTX] [varchar](255) NULL,
	[CEMAILADDCD] [char](1) NULL,
	[C2SSN] [char](9) NULL,
	[C2ACCID] [char](10) NULL,
	[C2FIRST] [varchar](13) NULL,
	[C2MID] [varchar](13) NULL,
	[C2LAST] [varchar](23) NULL,
	[C2SUFFIX] [char](5) NULL,
	[C2BIRTH] [date] NULL,
	[C2ADD1] [varchar](50) NULL,
	[C2ADD2] [varchar](50) NULL,
	[C2ADD3] [varchar](50) NULL,
	[C2CITY] [varchar](64) NULL,
	[C2STATE] [char](2) NULL,
	[C2ZIP] [char](9) NULL,
	[C2ADDIND] [char](1) NULL,
	[C2ADDLDT] [date] NULL,
	[C2ADDFLG] [char](1) NULL,
	[C2PHNARA] [char](3) NULL,
	[C2PHNEXC] [char](3) NULL,
	[C2PHNNUM] [char](4) NULL,
	[C2PHNEXT] [char](5) NULL,
	[C2PHNIND] [char](1) NULL,
	[C2EMAILADDTX] [varchar](255) NULL,
	[C2EMAILADDCD] [char](1) NULL,
	[C3SSN] [char](9) NULL,
	[C3ACCID] [char](10) NULL,
	[C3FIRST] [varchar](13) NULL,
	[C3MID] [varchar](13) NULL,
	[C3LAST] [varchar](23) NULL,
	[C3SUFFIX] [char](5) NULL,
	[C3BIRTH] [date] NULL,
	[C3ADD1] [varchar](50) NULL,
	[C3ADD2] [varchar](50) NULL,
	[C3ADD3] [varchar](50) NULL,
	[C3CITY] [varchar](64) NULL,
	[C3STATE] [char](2) NULL,
	[C3ZIP] [char](9) NULL,
	[C3ADDIND] [char](1) NULL,
	[C3ADDLDT] [date] NULL,
	[C3ADDFLG] [char](1) NULL,
	[C3PHNARA] [char](3) NULL,
	[C3PHNEXC] [char](3) NULL,
	[C3PHNNUM] [char](4) NULL,
	[C3PHNEXT] [char](5) NULL,
	[C3PHNIND] [char](1) NULL,
	[C3EMAILADDTX] [varchar](255) NULL,
	[C3EMAILADDCD] [char](1) NULL,
	[DATAFILENAME_SUP] [varchar](255) NULL,
	[CSEPARCD] [char](2) NULL,
	[CREAS] [varchar](40) NULL,
	[CREASCD] [char](2) NULL,
	[CSCDESC] [varchar](40) NULL,
	[CLEARHFLG] [char](1) NULL,
	[SKIPBEGDT] [date] NULL,
	[SGMNTCD] [char](2) NULL,
	[RISKSCORE] [tinyint] NULL,
	[SGMNTSTRTGY] [char](3) NULL,
	[BILLAMT] [decimal](9, 2) NULL,
	[BILLDUEDT] [date] NULL,
	[IMCD] [varchar](17) NULL,
	[PASTDUEAMT] [decimal](9, 2) NULL,
	[NUMPAYPASTDUE] [tinyint] NULL,
	[NUMPAYSMO] [tinyint] NULL,
	[MAXDELQ] [smallint] NULL,
	[MAXDELQDT] [date] NULL,
	[CMBBILLCD] [char](1) NULL,
	[IDXTYPCD] [char](3) NULL,
	[IDXTYPTXT] [varchar](40) NULL,
	[GFEEREPAYPCT] [decimal](6, 3) NULL,
	[GFEEREPAYAMT] [decimal](9, 2) NULL,
	[BILLSENTDT] [date] NULL,
	[MAXMTHFORBALLOW] [tinyint] NULL,
	[AUTHUSRIND] [char](1) NULL,
	[CALLSRECD] [tinyint] NULL,
	[LSTCALLRECDDT] [date] NULL,
	[CALLSOUT] [tinyint] NULL,
	[LSTCALLOUTDT] [date] NULL,
	[LSTLTRDT] [date] NULL,
	[LSTLTRCD] [char](5) NULL,
	[CCALLSOUT] [tinyint] NULL,
	[CLSTCALLOUTDT] [date] NULL,
	[CLSTLTRDT] [date] NULL,
	[CLSTLTRCD] [char](5) NULL,
	[DEATHNTFDT] [date] NULL,
	[DEATHFIRST] [varchar](13) NULL,
	[DEATHMID] [varchar](13) NULL,
	[DEATHLAST] [varchar](23) NULL,
	[DEATHDT] [date] NULL,
	[BNKRPTCYNTFDT] [date] NULL,
	[BNKRPTCYFILSSN] [char](9) NULL,
	[BNKRPTCYDT] [date] NULL,
	[BNKRPTCYFILCITY] [varchar](64) NULL,
	[BNKRPTCYFILST] [char](2) NULL,
	[BNKRPTCYCASENO] [varchar](12) NULL,
	[BNKRPTCYTYP] [char](2) NULL,
	[ORIGISSUEDISC] [decimal](15, 2) NULL,
	[LETTERID] [varchar](10) NULL,
	[ACTIONDEFDESC] [varchar](20) NULL,
	[CLETTERID] [varchar](10) NULL,
	[CACTIONDEFDESC] [varchar](20) NULL,
	[BKRSTA] [char](2) NULL,
	[BKRSTATXT] [varchar](20) NULL,
	[CADDVALID] [char](1) NULL,
	[CEMAILVALID] [char](1) NULL,
	[CPHNVALID] [char](1) NULL,
	[C2ADDVALID] [char](1) NULL,
	[C2EMAILVALID] [char](1) NULL,
	[C2PHNVALID] [char](1) NULL,
	[C3ADDVALID] [char](1) NULL,
	[C3EMAILVALID] [char](1) NULL,
	[C3PHNVALID] [char](1) NULL,
	[NXTINSTDUE_BILLED] [decimal](9, 2) NULL,
	[BILLTYPE] [char](1) NULL,
	[INTRATEREDPGM] [char](1) NULL,
	[SCRAFLAG] [char](1) NULL,
	[SCRABEGINDT] [date] NULL,
	[SCRAENDDT] [date] NULL,
	[COSRELRCVDDT] [date] NULL,
	[COSRELGRANTDT] [date] NULL,
	[ACHREQDT] [date] NULL,
	[HSP_TOTDAYSFORB_ALLOC] [smallint] NULL,
	[HSP_totdayinforb] [smallint] NULL,
	[HSP_totmosinforb] [decimal](4, 1) NULL,
	[HSP_MAXDAYFORBALLOW] [smallint] NULL,
	[HSP_MAXMTHFORBREMAIN] [decimal](4, 1) NULL,
	[HSP_MAXDAYFORBREMAIN] [smallint] NULL,
	[HSP_totmosinforb_alloc] [decimal](4, 1) NULL,
	[DAYELAPFOR] [smallint] NULL,
	[CURFORBDAYS] [smallint] NULL,
	[CURFORBMTHS] [tinyint] NULL,
 CONSTRAINT [PK_Test] PRIMARY KEY CLUSTERED 
(
	[WHSE_ID] ASC,
	[CREATEDATE] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
 CONSTRAINT [UQ_Test_CREATEDATE_BSSN_SEQ_PROGRAM_GUARANTOR_CURROWN_OWNERBOND] UNIQUE NONCLUSTERED 
(
	[CREATEDATE] ASC,
	[BSSN] ASC,
	[SEQ] ASC,
	[PROGRAM] ASC,
	[GUARANTOR] ASC,
	[CURROWN] ASC,
	[OWNERBOND] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 70) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING ON
GO

CREATE NONCLUSTERED INDEX [IX_Test_ALTLOANID_CREATEDATE] ON [dbo].[Test] 
(
	[ALTLOANID] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_AMTGUARANT_CREATEDATE] ON [dbo].[Test] 
(
	[AMTGUARANT] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_BBIRTH_CREATEDATE] ON [dbo].[Test] 
(
	[BBIRTH] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_BLAST_CREATEDATE] ON [dbo].[Test] 
(
	[BLAST] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_BORACCID_CREATEDATE] ON [dbo].[Test] 
(
	[BORACCID] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_BSSN_SEQ_CREATEDATE_cm_loan_key] ON [dbo].[Test] 
(
	[BSSN] ASC,
	[SEQ] ASC,
	[CREATEDATE] ASC
)
INCLUDE ( [cm_loan_key])  ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_BSSN_SEQ_INICLAIMSUB_CREATEDATE] ON [dbo].[Test] 
(
	[BSSN] ASC,
	[SEQ] ASC,
	[INICLAIMSUB] ASC,
	[CREATEDATE] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_CLAIMREAS_CREATEDATE] ON [dbo].[Test] 
(
	[CLAIMREAS] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_CLETTERID_CREATEDATE] ON [dbo].[Test] 
(
	[CLETTERID] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_cm_guarantor_CREATEDATE] ON [dbo].[Test] 
(
	[cm_guarantor] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_cm_loan_key_CREATEDATE] ON [dbo].[Test] 
(
	[cm_loan_key] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_cm_loan_key_CURROWN_CREATEDATE] ON [dbo].[Test] 
(
	[cm_loan_key] ASC,
	[CURROWN] ASC,
	[CREATEDATE] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_COSIGN_CREATEDATE] ON [dbo].[Test] 
(
	[COSIGN] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_CREATEDATE] ON [dbo].[Test] 
(
	[CREATEDATE] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_CREATEDATE_FMCTRUST] ON [dbo].[Test] 
(
	[CREATEDATE] ASC,
	[FMCTRUST] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_CSSN_CREATEDATE] ON [dbo].[Test] 
(
	[CSSN] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_CURROWN_CREATEDATE] ON [dbo].[Test] 
(
	[CURROWN] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_CURSCL_CREATEDATE] ON [dbo].[Test] 
(
	[CURSCL] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_CYCLESTAT_CREATEDATE] ON [dbo].[Test] 
(
	[CYCLESTAT] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_CYCLESUB_CREATEDATE] ON [dbo].[Test] 
(
	[CYCLESUB] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_DATAFILENAME_CREATEDATE] ON [dbo].[Test] 
(
	[DATAFILENAME] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_DATEGUARAN_CREATEDATE] ON [dbo].[Test] 
(
	[DATEGUARAN] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_DEFERTYP_CREATEDATE] ON [dbo].[Test] 
(
	[DEFERTYP] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_DISB1AMT_CREATEDATE] ON [dbo].[Test] 
(
	[DISB1AMT] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_DISBDT1_CREATEDATE] ON [dbo].[Test] 
(
	[DISBDT1] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_FORBTYP_CREATEDATE] ON [dbo].[Test] 
(
	[FORBTYP] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_FULLDISB_CREATEDATE] ON [dbo].[Test] 
(
	[FULLDISB] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_GUARREF_CREATEDATE] ON [dbo].[Test] 
(
	[GUARREF] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_INICLAIMSUB_CREATEDATE] ON [dbo].[Test] 
(
	[INICLAIMSUB] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_LENDER_PROGRAM_CREATEDATE] ON [dbo].[Test] 
(
	[LENDER] ASC,
	[PROGRAM] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_LETTERID_CREATEDATE] ON [dbo].[Test] 
(
	[LETTERID] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_LNOWNNUM_CREATEDATE] ON [dbo].[Test] 
(
	[LNOWNNUM] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_LOANADD_CREATEDATE] ON [dbo].[Test] 
(
	[LOANADD] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_NEWZEROBAL_CREATEDATE] ON [dbo].[Test] 
(
	[NEWZEROBAL] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_NEWZEROBAL_OWNERBOND_CREATEDATE] ON [dbo].[Test] 
(
	[NEWZEROBAL] ASC,
	[OWNERBOND] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_NEWZEROSUB_CREATEDATE] ON [dbo].[Test] 
(
	[NEWZEROSUB] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_ORGSCLNM_CREATEDATE] ON [dbo].[Test] 
(
	[ORGSCLNM] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_ORIGSCL_CREATEDATE] ON [dbo].[Test] 
(
	[ORIGSCL] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_ORIGSEASON_CREATEDATE] ON [dbo].[Test] 
(
	[ORIGSEASON] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_OWNERBOND_CREATEDATE] ON [dbo].[Test] 
(
	[OWNERBOND] ASC,
	[CREATEDATE] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_PNOTEYR_CREATEDATE] ON [dbo].[Test] 
(
	[PNOTEYR] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_PROGRAM_CREATEDATE] ON [dbo].[Test] 
(
	[PROGRAM] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_TIERPRICE_CREATEDATE] ON [dbo].[Test] 
(
	[TIERPRICE] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_ZEROBALCD_CREATEDATE] ON [dbo].[Test] 
(
	[ZEROBALCD] ASC
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_Test_ZEROBALSUBCD_CREATEDATE] ON [dbo].[Test] 
(
	[ZEROBALSUBCD] ASC
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Test]  WITH CHECK ADD  CONSTRAINT [CK_Test_CREATEDATE] CHECK  (([CREATEDATE]>='19961201' AND [CREATEDATE]<'20161001'))
GO

ALTER TABLE [dbo].[Test] CHECK CONSTRAINT [CK_Test_CREATEDATE]
GO

ALTER TABLE [dbo].[Test]  WITH CHECK ADD  CONSTRAINT [CK_Test_SERVICERCD] CHECK  (([SERVICERCD]=(1)))
GO

ALTER TABLE [dbo].[Test] CHECK CONSTRAINT [CK_Test_SERVICERCD]
GO

ALTER TABLE [dbo].[Test] ADD  CONSTRAINT [DF_Test_LOADDATE]  DEFAULT (getdate()) FOR [LOADDATE]
GO

ALTER TABLE [dbo].[Test] ADD  CONSTRAINT [DF_Test_totmosindefer]  DEFAULT ((0)) FOR [totmosindefer]
GO

ALTER TABLE [dbo].[Test] ADD  CONSTRAINT [DF_Test_totmosinforb]  DEFAULT ((0)) FOR [totmosinforb]
GO


Comments

  • Eddie DEddie D Posts: 1,660 Rose Gold 5
    Hi

    Thank you for your forum post and sorry that you have encountered a problem.

    What exact full version number of SQL Data Compare are you using?

    Would you please enable the verbose logging, as per this help ARTICLE and repeat the steps you took previously? When the problem occurs, locate the current log file and send a copy to [email protected] with the subject "Support Ticket #76008.

    Many Thanks
    Eddie
    Eddie Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
  • jmeyerjmeyer Posts: 70 Bronze 2
    This appears to be fixed in 12.0.39.3632. Though, seeing that the progress display now stays at 100% for long periods of time makes the cynic in me think that it's just a cosmetic change in that you cap the display of percentages at 100% :wink:
  • Yep, that's right :) Unfortunately it turns out to be hard to accurately figure out how many objects there are to register in a database without registering it first, so there's a bit of estimation involved. This has been a problem in Compare for a while, but v12 made it particularly obvious with how it displays progress. I've written up a bug (SC-9133) for seeing if we can do a better job of estimating progress, but it's unlikely to take priority over other work that we're doing at the moment, so I don't have any ETA for fixing it properly.
  • jmeyerjmeyer Posts: 70 Bronze 2
    :wink:

    Well, you could always retain the # objects in the project file after the first run. As long as there are only minor changes to the # objects you'd be fine, and in case of large # of changes, you'd still have the 100% cap in place.
Sign In or Register to comment.