Red Gate forums :: View topic - SP ordering incorrect when using FTI
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager Previous Versions
SQL Packager Previous Versions forum

SP ordering incorrect when using FTI

Search in SQL Packager Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
paulh



Joined: 08 Oct 2005
Posts: 33

PostPosted: Wed May 23, 2007 11:43 am    Post subject: SP ordering incorrect when using FTI Reply with quote

Hi, I just tried to package a database that contained full-texting indexing and there were a couple of problems...

1. No "sp_fulltext_database 'enable'" statement was included in the script.
2. It scripted some SPs that had a CONTAINSTABLE statement before the FTIs were created, so the script rolled back as the tables did not have FTI.

Paul
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6667

PostPosted: Sat May 26, 2007 11:58 pm    Post subject: Reply with quote

Hi Paul,

Thanks for your post. I see what you're saying; Packager doesn't deal with creating full-text catalogs or enabling the database. There is a short blurb about it in the help file:
Quote:
Note that if you want your database to use filegroups or full-text processing you should create the database manually, and use the Upgrade an existing database option.


If you have any further comments, please let me know.
Back to top
View user's profile Send private message
paulh



Joined: 08 Oct 2005
Posts: 33

PostPosted: Tue May 29, 2007 10:35 am    Post subject: Reply with quote

Brian

What I did was create an empty database and then use the "Upgrade an existing database" setting. The help doesn't say you have to create the FTI manually, just the database.

The script also does create the FTI and SPs, my problem is that it does it in the incorrect order; so on the whole I'd still say that this was a bug.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6667

PostPosted: Tue May 29, 2007 10:09 pm    Post subject: Reply with quote

Hi Paul,

I agree.

I'd say that the root of the problem is that the Packager's dependency parser doesn't index anything inside CONTAINS() functions. I can double-check this tomorrow, but I seem to recall advising someone awhile back to create two packages, one with everything but stored procedures and a second one just with the stored procedures in it.
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