SP ordering incorrect when using FTI

Forum for users of SQL Packager database archive utility

Moderator: David Atkinson

SP ordering incorrect when using FTI

Postby paulh » Wed May 23, 2007 11:43 am

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
paulh
 
Posts: 33
Joined: Sat Oct 08, 2005 5:28 pm

Postby Brian Donahue » Sat May 26, 2007 11:58 pm

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:
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.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby paulh » Tue May 29, 2007 10:35 am

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.
paulh
 
Posts: 33
Joined: Sat Oct 08, 2005 5:28 pm

Postby Brian Donahue » Tue May 29, 2007 10:09 pm

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.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests