Red Gate forums :: View topic - Fulltext Indext Stoplist Options
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

Fulltext Indext Stoplist Options

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



Joined: 16 May 2007
Posts: 50

PostPosted: Mon May 20, 2013 3:05 pm    Post subject: Fulltext Indext Stoplist Options Reply with quote

When comparing a table script file containing a full text index definition with another script file with an equivalent fulltext definition but where the STOPLIST option is included, then SQL Compare treats the scripts as being the same even though the differencing pane highlights the differences between the scripts.

e.g.

1st script contains this:

CREATE FULLTEXT INDEX ON [dbo].[MyTable] KEY INDEX [PK_MyTable] ON [ftCatalog] WITH STOPLIST OFF
GO

2nd script contains this:

CREATE FULLTEXT INDEX ON [dbo].[MyTable] KEY INDEX [PK_MyTable] ON [ftCatalog]
GO

Is there a project option that can be specified so that this difference is raised at the table level? Full-text indexing is not selected under the 'Ignore' project option.

SQL Compare 10.3.8.406 Professional Edition running on Windows 7 64-bit.

Thanks
Chris
Back to top
View user's profile Send private message
stanori



Joined: 23 Apr 2012
Posts: 84

PostPosted: Wed May 22, 2013 8:18 pm    Post subject: Reply with quote

Hi howarthcd,

Thanks for your post regarding SQL Compare. Unfortunately, there is not a way to present this difference at the same object level as a table. SQL Compare treats this difference at the table level, and will generate the appropriate change in the resulting deployment script.

I would suggest posting your feature request in the following forum so that others can vote as well:
http://redgate.uservoice.com/forums/141379-sql-compare-feature-suggestions

Best Regards,
Steve
_________________
_________________
Steve Tanori
Product Support
Red Gate Software Ltd.
866-997-0378
Back to top
View user's profile Send private message
howarthcd



Joined: 16 May 2007
Posts: 50

PostPosted: Wed May 22, 2013 9:03 pm    Post subject: Reply with quote

Hi Steve

Thanks for your reply, however this isn't a feature request - I believe that it is a bug.

The point is that although the fulltext index definition differs there is no relevant sync statement included in the synchronisation script.

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