Red Gate forums :: View topic - setting up full-text index
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 3
SQL Source Control 3 forum

setting up full-text index

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
merk



Joined: 15 Jun 2006
Posts: 17

PostPosted: Tue Jan 15, 2013 9:48 pm    Post subject: setting up full-text index Reply with quote

It would be really cool if source control could handle setting up the indexing on any tables that have full text index set up. It makes a task that would otherwise be very quick an easy somewhat tedious, since I have to try to commit changes, wait for it to give me an error telling me what table needs an index and then go through the motions of setting all that up.

Any chance this is something that will become automated in the 'get' process?
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 209

PostPosted: Thu Jan 17, 2013 11:02 pm    Post subject: Reply with quote

Unfortunately SQL Source Control behaves in this manner because full text indexes can't be updated transactionally, so we do them all at the end of the script, after the transaction. Unfortunately that means that if you have something which relies on them in the middle of the script, then it will fail.

The workaround is to synchronize the fulltext catalogs / tables with fulltext indexes first, and then synchronize the rest of the database.

There is a existing feature request you may want to vote for
http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/1787285-full-text-indexes-cause-process-to-fail
These forums allow our users to request features and vote on them.
The development team actively monitor these forums so if a request receives alot of support the request maybe added to a future release.
_________________
Manfred Castro
Product Support
Red Gate Software
Back to top
View user's profile Send private message
merk



Joined: 15 Jun 2006
Posts: 17

PostPosted: Fri Jan 18, 2013 12:28 am    Post subject: Reply with quote

I guess this isn't a very high priority request considering that feature request is from may of 2011 Winkp I voted for it anyhow though.
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