FillFactor Bug with User Defiend Table Types

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

FillFactor Bug with User Defiend Table Types

Postby Niall » Tue Apr 24, 2012 7:59 am

SQL Compare seems to have a bit of a bug when it comes to User Defined Table Types.

If The Soruce and Destination server have different Index default fill factors SQL Compare adds a fill factor to the Primary Key for the user defiend type, this does not work as it is not legal on UDTs.

Ie Source server has default fillfactor = 90%, Target server has fillfactor =80%

SQL Compare generates

CREATE TYPE [SomeSchema].[SomeType] AS TABLE
(
[PrimaryKeyCol] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED ([PrimaryKeyCol]) WITH (FILLFACTOR=90)
)
GO

This errors.
Niall
 
Posts: 20
Joined: Wed Jul 21, 2010 9:15 am

Re: FillFactor Bug with User Defiend Table Types

Postby Niall » Tue Apr 24, 2012 8:16 am

Niall wrote:Ie Source server has default fillfactor = 90%, Target server has fillfactor =80%


Actually it seems the Fillfactor setting gets added even when both the Source and Target have the same setting.
Niall
 
Posts: 20
Joined: Wed Jul 21, 2010 9:15 am

Postby eddie davis » Thu Apr 26, 2012 4:46 pm

Thank you for your post into the forum.

Unfortunately I am not able to recreate your issue using SQL Compare V10.1.0.102 and SQL Server version 10.0.4064 for both the source and target servers.

Source Server fill factor is set to default value of 90 and the target server was modified to use a fill factor of 80.

What version of SQL Compare are you using?
What version of SQL Server are you using for both source and target?

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Re:

Postby Niall » Thu Apr 26, 2012 7:24 pm

eddie davis wrote:What version of SQL Compare are you using?


10.1.0.102

eddie davis wrote:What version of SQL Server are you using for both source and target?


10.50.2811 (SQL Server 2008 R2 SP1 CU6)
Niall
 
Posts: 20
Joined: Wed Jul 21, 2010 9:15 am

Postby eddie davis » Thu May 24, 2012 7:38 pm

Sorry for the delay in replying back to you, it took longer than expected to create a test machine with two instances of SQL 2008 R2 and then apply SP1 and CU6 respectively.

Unfortunately I am still unable to replicate your reported fault symptoms.

So I can continue further with my investigations, would it be possible for you to generate a SQL Compare snapshot of both the source and target databases?

If the answer is yes, can you please attach the resulting *.snp files to an e-mail with the following call reference number in the subject field of the e-mail - F0059596. Please send the e-mail to support@red-gate.com.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 1 guest