Red Gate forums :: View topic - FillFactor Bug with User Defiend Table Types
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

FillFactor Bug with User Defiend Table Types

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Niall



Joined: 21 Jul 2010
Posts: 20

PostPosted: Tue Apr 24, 2012 7:59 am    Post subject: FillFactor Bug with User Defiend Table Types Reply with quote

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.
Back to top
View user's profile Send private message
Niall



Joined: 21 Jul 2010
Posts: 20

PostPosted: Tue Apr 24, 2012 8:16 am    Post subject: Re: FillFactor Bug with User Defiend Table Types Reply with quote

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.
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 925
Location: Red Gate Software

PostPosted: Thu Apr 26, 2012 4:46 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Niall



Joined: 21 Jul 2010
Posts: 20

PostPosted: Thu Apr 26, 2012 7:24 pm    Post subject: Re: Reply with quote

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)
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 925
Location: Red Gate Software

PostPosted: Thu May 24, 2012 7:38 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group