StrataFrame Forum » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » Unique Index modification

Unique Index modification

Edhy Rijo — Sat, 04 Apr 2009 13:17:14 GMT

I have a table with a unique index, I wanted to remove the "Unique" using the DDT and got the following error:
[quote]Modifying the IsUnique property of the Index object is not allowed. You must drop and recreate the object with the desired property.[/quote]
Does this mean that I would need to connect to the customer's server, modify the table and remove the unique flag? or is there a wait to automate this in the DDT?

RE: Unique Index modification

Edhy Rijo — Sat, 04 Apr 2009 13:17:14 GMT

Thanks Trent, will try that out.

RE: Unique Index modification

Trent L. Taylor — Sat, 04 Apr 2009 13:08:20 GMT

[quote]Does this mean that I would need to connect to the customer's server, modify the table and remove the unique flag? or is there a wait to automate this in the DDT?[/quote]

Well, it depends . One way to automate this regardless of the current deployment state is to use the Pre-Deployment scripts to remove this flag.