Unique Index Problem
 
Home My Account Forum Try It! Buy It!
About Contact Us Site Map
StrataFrame Forum
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      

Home » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » Unique Index Problem


Unique Index ProblemExpand / Collapse
Author
Message
Posted 03/06/2008 9:03:10 AM
StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame Beginner

Group: StrataFrame Users
Last Login: 04/14/2008 7:41:48 AM
Posts: 45, Visits: 102
I have a number of unique indexes on my database.  When I import it into a DDT project, all the indexes imported as non-unique.  So I changed them all in DDT to be unique and then deployed the database.  Everything worked fine except 1 index got deployed as non-unique.  So I checked the DDT project and it IS marked as unique.  So I unchecked and checked Unique just to make sure.  I redeployed the database and the progress log said the index in question was successfully altered.  So I went into the SQL Server Management Studio and the index is still non-unique.  Checked the DDT project again and the index is flagged as UNIQUE.  Any idea why this index won't deploy as unique?

Thanks!!

Post #14682
Posted 03/06/2008 9:40:09 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Yesterday @ 3:24:00 PM
Posts: 3,733, Visits: 3,926
This type of thing is hard to diagnose over a post.  If you deploy to a fresh instance (i.e. create a new database or deploy to another SQL Server) and the index is created properly, then there is probably some pre-existing issue that the SMO is having an issue with.  The first thing that I would do is manually delete the index on the server, deploy, and if it is created correctly from that point forward then you are probably good to go.  Past that I don't have any "abundantly wise advice" without actually getting into the very specifics and details in a reproducable state.
Post #14683
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 1 (1 guest, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Ben Chase, Trent L. Taylor, Steve L. Taylor

PermissionsExpand / Collapse

All times are GMT -6:00, Time now is 2:35am

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.047. 9 queries. Compression Enabled.
Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.