Problem with 3rd Party UDDTs being include

sean.flooksean.flook Posts: 3
edited May 18, 2006 11:09AM in SQL Packager Previous Versions
I am trying to create an update package but everytime I get to the Generating SQL script dialog, scripting (data) stage I get an error saying unknown type - sys.ST_SPATIAL. ST_SPATIAL is a UDDT from a 3rd party that we use to store spatial data in the database.

I have tried this with only selecting a single table to update that does not use ST_SPATIAL and I have removed the Include Dependencies but I still get this error.

What must I do in order to get packger to ignore this UDDT?
Sean Flook
· Share on Twitter

Comments

  • david connelldavid connell Posts: 172 Silver 1
    Hi Sean,

    Try disabling "Include indexed views" from the Data options. (This option can be found by selecting Options from the Tools menu, and then by selecting the data tab form)
    FYI please see for more information
    http://www.red-gate.com/messageboard/viewtopic.php?t=2446

    Hope this helps

    David Connell
    · Share on Twitter
  • sean.flooksean.flook Posts: 3
    This did not work.

    I am not actually including any data in the package just changes to the objects.

    I get this error even if I have only selected a change to a single table that does not include the UDDT. The application seems to be checking everything and ignoring my selections.
    Sean Flook
    · Share on Twitter
  • david connelldavid connell Posts: 172 Silver 1
    Hi Sean,
    Is it possible to send me a backup of your database please?
    (david.connell@red-gate.com)
    Regards
    David Connell
    · Share on Twitter
  • TilmanTilman Posts: 395 Bronze 2
    Hi Sean,

    thanks for sending in your databases. We were able to reproduce the problem here. Apart from the issue in Data Compare whereby UDTs in indexed views don't work, there is also a problem in SQL Packager whereby it is impossible to switch off the 'Include indexed views' option, i.e. if you switch it off, click OK, and then go back its enabled again. Sorry about that. (Switching off Include indexed views in Data Compare it works.)

    The only workaround I can offer at the moment is to use the SQL Packager command line, which is part of SQL Packager Pro, however. If you want to give it a go and you don't have a Pro version please contact sales@red-gate.com and they will give you one for free.

    We will fix both issues in the next release of SQL Bundle.

    Apologies again,

    Tilman
    · Share on Twitter
Sign In or Register to comment.