BUG: Upgrader & Foreign Keys

rated by 0 users

Reply

|

Contact

By: Ben Tiedt

Posted: Tue, Apr 15 2008 3:06 PM In reply to

Unfortunately, this did not get addressed for the CS2008 release.  We will be looking at improving support for external add-ons more in future versions of CS and we'll need to take this into account.

• Post Points: 20 |

rated by 0 users

Reply

|

Contact

By: Bill Bosacker

Posted: Wed, Apr 16 2008 12:39 PM In reply to

 Hey Ben,

That's cool.  There were a couple patches over the last year that added some foreign key constraints that the upgrade package doesn't seem to be aware of, thus it fails during conversion.  However, I think that I might be able to do this manually by using some of the tools in SQL Server.  I can script the database with drops, which will provide me with a script that contains drops for every foreign key.  After running that I can run the upgrade, then take your new database script and execute the foreign key creations.  That should hopefully leave me with a compatible database.

Take it easy,
Bill

P.S.  I remember reading something about the FCK Editor being removed from the release, and has been changed to a free addon.  Do you have a link to the addon?

• Post Points: 35 |

rated by 0 users

Reply

|

Contact

By: Ben Tiedt

Posted: Wed, Apr 16 2008 2:18 PM In reply to

Bill Bosacker:

I remember reading something about the FCK Editor being removed from the release, and has been changed to a free addon.  Do you have a link to the addon?

It is here: http://dev.communityserver.com/media/p/617346.aspx

• Post Points: 5 |

rated by 0 users

Reply

|

Contact

By: Jose Lema

Posted: Wed, Apr 16 2008 3:05 PM In reply to

Hey Bill,

Bill Bosacker:

There were a couple patches over the last year that added some foreign key constraints that the upgrade package doesn't seem to be aware of, thus it fails during conversion.

Can you provide more specifics around this? We haven't heard this feedback from others so I'm wondering what's unique about your setup. (For now, just talking about the schema that we ship, not 3rd party)

Thanks!

• Post Points: 20 |

rated by 0 users

Reply

|

Contact

By: Bill Bosacker

Posted: Wed, Apr 16 2008 4:27 PM In reply to

 Hey Jose,

Here is a list of all the foreign keys that are defined in my database.  When I run the Upgrader, it fails due to the constraints:

/****** Object:  ForeignKey [FK__aspnet_Me__Appli__0EA330E9]    Script Date: 04/16/2008 13:00:16 ******/
ALTER TABLE [dbo].[aspnet_Membership] DROP CONSTRAINT [FK__aspnet_Me__Appli__0EA330E9]
GO
/****** Object:  ForeignKey [FK__aspnet_Me__UserI__0F975522]    Script Date: 04/16/2008 13:00:16 ******/
ALTER TABLE [dbo].[aspnet_Membership] DROP CONSTRAINT [FK__aspnet_Me__UserI__0F975522]
GO
/****** Object:  ForeignKey [FK__aspnet_Pa__Appli__07EC11B9]    Script Date: 04/16/2008 13:00:19 ******/
ALTER TABLE [dbo].[aspnet_Paths] DROP CONSTRAINT [FK__aspnet_Pa__Appli__07EC11B9]
GO
/****** Object:  ForeignKey [FK__aspnet_Pa__Appli__11957784]    Script Date: 04/16/2008 13:00:19 ******/
ALTER TABLE [dbo].[aspnet_Paths] DROP CONSTRAINT [FK__aspnet_Pa__Appli__11957784]
GO
/****** Object:  ForeignKey [FK__aspnet_Pa__Appli__20B7BF83]    Script Date: 04/16/2008 13:00:20 ******/
ALTER TABLE [dbo].[aspnet_Paths] DROP CONSTRAINT [FK__aspnet_Pa__Appli__20B7BF83]
GO
/****** Object:  ForeignKey [FK__aspnet_Pa__Appli__3F3C46A3]    Script Date: 04/16/2008 13:00:20 ******/
ALTER TABLE [dbo].[aspnet_Paths] DROP CONSTRAINT [FK__aspnet_Pa__Appli__3F3C46A3]
GO
/****** Object:  ForeignKey [FK__aspnet_Pa__Appli__5807F46D]    Script Date: 04/16/2008 13:00:20 ******/
ALTER TABLE [dbo].[aspnet_Paths] DROP CONSTRAINT [FK__aspnet_Pa__Appli__5807F46D]
GO
/****** Object:  ForeignKey [FK__aspnet_Pa__Appli__6DEC4894]    Script Date: 04/16/2008 13:00:20 ******/
ALTER TABLE [dbo].[aspnet_Paths] DROP CONSTRAINT [FK__aspnet_Pa__Appli__6DEC4894]
GO
/****** Object:  ForeignKey [FK__aspnet_Pa__Appli__70D3A237]    Script Date: 04/16/2008 13:00:21 ******/
ALTER TABLE [dbo].[aspnet_Paths] DROP CONSTRAINT [FK__aspnet_Pa__Appli__70D3A237]
GO
/****** Object:  ForeignKey [FK__aspnet_Pe__PathI__09D45A2B]    Script Date: 04/16/2008 13:00:23 ******/
ALTER TABLE [dbo].[aspnet_PersonalizationAllUsers] DROP CONSTRAINT [FK__aspnet_Pe__PathI__09D45A2B]
GO
/****** Object:  ForeignKey [FK__aspnet_Pe__PathI__137DBFF6]    Script Date: 04/16/2008 13:00:23 ******/
ALTER TABLE [dbo].[aspnet_PersonalizationAllUsers] DROP CONSTRAINT [FK__aspnet_Pe__PathI__137DBFF6]
GO
/****** Object:  ForeignKey [FK__aspnet_Pe__PathI__22A007F5]    Script Date: 04/16/2008 13:00:24 ******/
ALTER TABLE [dbo].[aspnet_PersonalizationAllUsers] DROP CONSTRAINT [FK__aspnet_Pe__PathI__22A007F5]
GO
/****** Object:  ForeignKey [FK__aspnet_Pe__PathI__41248F15]    Script Date: 04/16/2008 13:00:24 ******/
ALTER TABLE [dbo].[aspnet_PersonalizationAllUsers] DROP CONSTRAINT [FK__aspnet_Pe__PathI__41248F15]
GO
/****** Object:  ForeignKey [FK__aspnet_Pe__PathI__59F03CDF]    Script Date: 04/16/2008 13:00:24 ******/
ALTER TABLE [dbo].[aspnet_PersonalizationAllUsers] DROP CONSTRAINT [FK__aspnet_Pe__PathI__59F03CDF]
GO
/****** Object:  ForeignKey [FK__aspnet_Pe__PathI__70C8B53F]    Script Date: 04/16/2008 13:00:24 ******/
ALTER TABLE [dbo].[aspnet_PersonalizationAllUsers] DROP CONSTRAINT [FK__aspnet_Pe__PathI__70C8B53F]
GO
/****** Object:  ForeignKey [FK__aspnet_Pe__PathI__72BBEAA9]    Script Date: 04/16/2008 13:00:25 ******/
ALTER TABLE [dbo].[aspnet_PersonalizationAllUsers] DROP CONSTRAINT [FK__aspnet_Pe__PathI__72BBEAA9]
GO
/****** Object:  ForeignKey [FK__aspnet_Pe__PathI__0BBCA29D]    Script Date: 04/16/2008 13:00:29 ******/
ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] DROP CONSTRAINT [FK__aspnet_Pe__PathI__0BBCA29D]
GO
/****** Object:  ForeignKey [FK__aspnet_Pe__PathI__15660868]    Script Date: 04/16/2008 13:00:29 ******/
ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] DROP CONSTRAINT [FK__aspnet_Pe__PathI__15660868]
GO
/****** Object:  ForeignKey [FK__aspnet_Pe__PathI__24885067]    Script Date: 04/16/2008 13:00:29 ******/
ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] DROP CONSTRAINT [FK__aspnet_Pe__PathI__24885067]
GO
/****** Object:  ForeignKey [FK__aspnet_Pe__PathI__430CD787]    Script Date: 04/16/2008 13:00:29 ******/
ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] DROP CONSTRAINT [FK__aspnet_Pe__PathI__430CD787]
GO
/****** Object:  ForeignKey [FK__aspnet_Pe__PathI__5BD88551]    Script Date: 04/16/2008 13:00:30 ******/
ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] DROP CONSTRAINT [FK__aspnet_Pe__PathI__5BD88551]
GO
/****** Object:  ForeignKey [FK__aspnet_Pe__PathI__74994623]    Script Date: 04/16/2008 13:00:30 ******/
ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] DROP CONSTRAINT [FK__aspnet_Pe__PathI__74994623]
GO
/****** Object:  ForeignKey [FK__aspnet_Pe__PathI__74A4331B]    Script Date: 04/16/2008 13:00:30 ******/
ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] DROP CONSTRAINT [FK__aspnet_Pe__PathI__74A4331B]
GO
/****** Object:  ForeignKey [FK__aspnet_Pe__UserI__0CB0C6D6]    Script Date: 04/16/2008 13:00:30 ******/
ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] DROP CONSTRAINT [FK__aspnet_Pe__UserI__0CB0C6D6]
GO
/****** Object:  ForeignKey [FK__aspnet_Pe__UserI__165A2CA1]    Script Date: 04/16/2008 13:00:31 ******/
ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] DROP CONSTRAINT [FK__aspnet_Pe__UserI__165A2CA1]
GO
/****** Object:  ForeignKey [FK__aspnet_Pe__UserI__257C74A0]    Script Date: 04/16/2008 13:00:31 ******/
ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] DROP CONSTRAINT [FK__aspnet_Pe__UserI__257C74A0]
GO
/****** Object:  ForeignKey [FK__aspnet_Pe__UserI__4400FBC0]    Script Date: 04/16/2008 13:00:31 ******/
ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] DROP CONSTRAINT [FK__aspnet_Pe__UserI__4400FBC0]
GO
/****** Object:  ForeignKey [FK__aspnet_Pe__UserI__5CCCA98A]    Script Date: 04/16/2008 13:00:31 ******/
ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] DROP CONSTRAINT [FK__aspnet_Pe__UserI__5CCCA98A]
GO
/****** Object:  ForeignKey [FK__aspnet_Pe__UserI__758D6A5C]    Script Date: 04/16/2008 13:00:32 ******/
ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] DROP CONSTRAINT [FK__aspnet_Pe__UserI__758D6A5C]
GO
/****** Object:  ForeignKey [FK__aspnet_Pe__UserI__75985754]    Script Date: 04/16/2008 13:00:32 ******/
ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] DROP CONSTRAINT [FK__aspnet_Pe__UserI__75985754]
GO
/****** Object:  ForeignKey [FK__aspnet_Pr__UserI__24927208]    Script Date: 04/16/2008 13:00:35 ******/
ALTER TABLE [dbo].[aspnet_Profile] DROP CONSTRAINT [FK__aspnet_Pr__UserI__24927208]
GO
/****** Object:  ForeignKey [FK__aspnet_Ro__Appli__2E1BDC42]    Script Date: 04/16/2008 13:00:39 ******/
ALTER TABLE [dbo].[aspnet_Roles] DROP CONSTRAINT [FK__aspnet_Ro__Appli__2E1BDC42]
GO
/****** Object:  ForeignKey [FK__aspnet_Us__Appli__7E6CC920]    Script Date: 04/16/2008 13:00:47 ******/
ALTER TABLE [dbo].[aspnet_Users] DROP CONSTRAINT [FK__aspnet_Us__Appli__7E6CC920]
GO
/****** Object:  ForeignKey [FK__aspnet_Us__RoleI__32E0915F]    Script Date: 04/16/2008 13:00:49 ******/
ALTER TABLE [dbo].[aspnet_UsersInRoles] DROP CONSTRAINT [FK__aspnet_Us__RoleI__32E0915F]
GO
/****** Object:  ForeignKey [FK__aspnet_Us__UserI__31EC6D26]    Script Date: 04/16/2008 13:00:49 ******/
ALTER TABLE [dbo].[aspnet_UsersInRoles] DROP CONSTRAINT [FK__aspnet_Us__UserI__31EC6D26]
GO
/****** Object:  ForeignKey [FK_cs_FavoritePosts_ApplicationType]    Script Date: 04/16/2008 13:01:55 ******/
ALTER TABLE [dbo].[cs_FavoritePosts] DROP CONSTRAINT [FK_cs_FavoritePosts_ApplicationType]
GO
/****** Object:  ForeignKey [FK_cs_FavoritePosts_cs_UserProfile]    Script Date: 04/16/2008 13:01:56 ******/
ALTER TABLE [dbo].[cs_FavoritePosts] DROP CONSTRAINT [FK_cs_FavoritePosts_cs_UserProfile]
GO
/****** Object:  ForeignKey [FK_cs_FavoriteSections_ApplicationType]    Script Date: 04/16/2008 13:01:59 ******/
ALTER TABLE [dbo].[cs_FavoriteSections] DROP CONSTRAINT [FK_cs_FavoriteSections_ApplicationType]
GO
/****** Object:  ForeignKey [FK_cs_FavoriteSections_cs_UserProfile]    Script Date: 04/16/2008 13:02:00 ******/
ALTER TABLE [dbo].[cs_FavoriteSections] DROP CONSTRAINT [FK_cs_FavoriteSections_cs_UserProfile]
GO
/****** Object:  ForeignKey [FK_cs_FavoriteUsers_ApplicationType]    Script Date: 04/16/2008 13:02:04 ******/
ALTER TABLE [dbo].[cs_FavoriteUsers] DROP CONSTRAINT [FK_cs_FavoriteUsers_ApplicationType]
GO
/****** Object:  ForeignKey [FK_cs_FavoriteUsers_cs_UserProfile]    Script Date: 04/16/2008 13:02:04 ******/
ALTER TABLE [dbo].[cs_FavoriteUsers] DROP CONSTRAINT [FK_cs_FavoriteUsers_cs_UserProfile]
GO
/****** Object:  ForeignKey [FK__cs_Feed__FeedSta__3CF40B7E]    Script Date: 04/16/2008 13:02:12 ******/
ALTER TABLE [dbo].[cs_Feed] DROP CONSTRAINT [FK__cs_Feed__FeedSta__3CF40B7E]
GO
/****** Object:  ForeignKey [FK__cs_Feed__Setting__3EDC53F0]    Script Date: 04/16/2008 13:02:12 ******/
ALTER TABLE [dbo].[cs_Feed] DROP CONSTRAINT [FK__cs_Feed__Setting__3EDC53F0]
GO
/****** Object:  ForeignKey [FK__cs_FeedPo__FeedI__467D75B8]    Script Date: 04/16/2008 13:02:23 ******/
ALTER TABLE [dbo].[cs_FeedPost] DROP CONSTRAINT [FK__cs_FeedPo__FeedI__467D75B8]
GO
/****** Object:  ForeignKey [FK__cs_Folder__Paren__345EC57D]    Script Date: 04/16/2008 13:02:29 ******/
ALTER TABLE [dbo].[cs_Folder] DROP CONSTRAINT [FK__cs_Folder__Paren__345EC57D]
GO
/****** Object:  ForeignKey [FK__cs_Folder__Setti__3552E9B6]    Script Date: 04/16/2008 13:02:29 ******/
ALTER TABLE [dbo].[cs_Folder] DROP CONSTRAINT [FK__cs_Folder__Setti__3552E9B6]
GO
/****** Object:  ForeignKey [FK__cs_Folder__UserI__336AA144]    Script Date: 04/16/2008 13:02:29 ******/
ALTER TABLE [dbo].[cs_Folder] DROP CONSTRAINT [FK__cs_Folder__UserI__336AA144]
GO
/****** Object:  ForeignKey [FK__cs_Folder__FeedI__43A1090D]    Script Date: 04/16/2008 13:02:33 ******/
ALTER TABLE [dbo].[cs_FolderFeed] DROP CONSTRAINT [FK__cs_Folder__FeedI__43A1090D]
GO
/****** Object:  ForeignKey [FK__cs_Folder__Folde__42ACE4D4]    Script Date: 04/16/2008 13:02:34 ******/
ALTER TABLE [dbo].[cs_FolderFeed] DROP CONSTRAINT [FK__cs_Folder__Folde__42ACE4D4]
GO
/****** Object:  ForeignKey [FK__cs_Folder__UserI__41B8C09B]    Script Date: 04/16/2008 13:02:34 ******/
ALTER TABLE [dbo].[cs_FolderFeed] DROP CONSTRAINT [FK__cs_Folder__UserI__41B8C09B]
GO
/****** Object:  ForeignKey [FK_cs_Links_cs_LinkCategories]    Script Date: 04/16/2008 13:03:05 ******/
ALTER TABLE [dbo].[cs_Links] DROP CONSTRAINT [FK_cs_Links_cs_LinkCategories]
GO
/****** Object:  ForeignKey [FK_cs_nntp_Posts_cs_Posts]    Script Date: 04/16/2008 13:03:28 ******/
ALTER TABLE [dbo].[cs_nntp_Posts] DROP CONSTRAINT [FK_cs_nntp_Posts_cs_Posts]
GO
/****** Object:  ForeignKey [FK_cs_Post_Categories_Parents_cs_Post_Categories]    Script Date: 04/16/2008 13:03:42 ******/
ALTER TABLE [dbo].[cs_Post_Categories_Parents] DROP CONSTRAINT [FK_cs_Post_Categories_Parents_cs_Post_Categories]
GO
/****** Object:  ForeignKey [FK_cs_PostEditNotes_cs_Posts]    Script Date: 04/16/2008 13:04:01 ******/
ALTER TABLE [dbo].[cs_PostEditNotes] DROP CONSTRAINT [FK_cs_PostEditNotes_cs_Posts]
GO
/****** Object:  ForeignKey [FK_cs_PostMetadata_cs_Posts]    Script Date: 04/16/2008 13:04:04 ******/
ALTER TABLE [dbo].[cs_PostMetadata] DROP CONSTRAINT [FK_cs_PostMetadata_cs_Posts]
GO
/****** Object:  ForeignKey [FK_cs_PostRating_cs_Posts]    Script Date: 04/16/2008 13:04:08 ******/
ALTER TABLE [dbo].[cs_PostRating] DROP CONSTRAINT [FK_cs_PostRating_cs_Posts]
GO
/****** Object:  ForeignKey [FK_cs_PostRating_cs_UserProfile]    Script Date: 04/16/2008 13:04:08 ******/
ALTER TABLE [dbo].[cs_PostRating] DROP CONSTRAINT [FK_cs_PostRating_cs_UserProfile]
GO
/****** Object:  ForeignKey [FK_cs_Posts_cs_Threads]    Script Date: 04/16/2008 13:04:34 ******/
ALTER TABLE [dbo].[cs_Posts] DROP CONSTRAINT [FK_cs_Posts_cs_Threads]
GO
/****** Object:  ForeignKey [FK_cs_ProductPermission_SettingsID]    Script Date: 04/16/2008 13:05:01 ******/
ALTER TABLE [dbo].[cs_ProductPermissions] DROP CONSTRAINT [FK_cs_ProductPermission_SettingsID]
GO
/****** Object:  ForeignKey [FK_cs_ProductPermissions_ApplicationType]    Script Date: 04/16/2008 13:05:02 ******/
ALTER TABLE [dbo].[cs_ProductPermissions] DROP CONSTRAINT [FK_cs_ProductPermissions_ApplicationType]
GO
/****** Object:  ForeignKey [FK_cs_Referrals_cs_Urls]    Script Date: 04/16/2008 13:05:11 ******/
ALTER TABLE [dbo].[cs_Referrals] DROP CONSTRAINT [FK_cs_Referrals_cs_Urls]
GO
/****** Object:  ForeignKey [FK_cs_GalleryRoleQuotas_cs_SiteSettings]    Script Date: 04/16/2008 13:05:18 ******/
ALTER TABLE [dbo].[cs_RoleQuotas] DROP CONSTRAINT [FK_cs_GalleryRoleQuotas_cs_SiteSettings]
GO
/****** Object:  ForeignKey [FK_cs_RollerBlogFeeds_cs_RollerBlogUrls]    Script Date: 04/16/2008 13:05:29 ******/
ALTER TABLE [dbo].[cs_RollerBlogFeeds] DROP CONSTRAINT [FK_cs_RollerBlogFeeds_cs_RollerBlogUrls]
GO
/****** Object:  ForeignKey [FK_cs_RollerBlogFeeds_cs_Sections]    Script Date: 04/16/2008 13:05:30 ******/
ALTER TABLE [dbo].[cs_RollerBlogFeeds] DROP CONSTRAINT [FK_cs_RollerBlogFeeds_cs_Sections]
GO
/****** Object:  ForeignKey [FK_cs_RollerBlogPost_cs_RollerBlogFeeds]    Script Date: 04/16/2008 13:05:35 ******/
ALTER TABLE [dbo].[cs_RollerBlogPost] DROP CONSTRAINT [FK_cs_RollerBlogPost_cs_RollerBlogFeeds]
GO
/****** Object:  ForeignKey [FK_cs_SearchBarrel_cs_Posts]    Script Date: 04/16/2008 13:05:46 ******/
ALTER TABLE [dbo].[cs_SearchBarrel] DROP CONSTRAINT [FK_cs_SearchBarrel_cs_Posts]
GO
/****** Object:  ForeignKey [FK_cs_SearchBarrel_cs_Threads]    Script Date: 04/16/2008 13:05:46 ******/
ALTER TABLE [dbo].[cs_SearchBarrel] DROP CONSTRAINT [FK_cs_SearchBarrel_cs_Threads]
GO
/****** Object:  ForeignKey [FK_cs_SectionPermissions_SectionID]    Script Date: 04/16/2008 13:05:52 ******/
ALTER TABLE [dbo].[cs_SectionPermissions] DROP CONSTRAINT [FK_cs_SectionPermissions_SectionID]
GO
/****** Object:  ForeignKey [FK_SERVICE_TYPE_CODE]    Script Date: 04/16/2008 13:06:42 ******/
ALTER TABLE [dbo].[cs_Services] DROP CONSTRAINT [FK_SERVICE_TYPE_CODE]
GO
/****** Object:  ForeignKey [FK_SCHEDULE_TYPE_CD]    Script Date: 04/16/2008 13:06:53 ******/
ALTER TABLE [dbo].[cs_ServiceSchedule] DROP CONSTRAINT [FK_SCHEDULE_TYPE_CD]
GO
/****** Object:  ForeignKey [FK_SERVICE_ID]    Script Date: 04/16/2008 13:06:54 ******/
ALTER TABLE [dbo].[cs_ServiceSchedule] DROP CONSTRAINT [FK_SERVICE_ID]
GO
/****** Object:  ForeignKey [FK_cs_ThreadRating_cs_Threads]    Script Date: 04/16/2008 13:07:57 ******/
ALTER TABLE [dbo].[cs_ThreadRating] DROP CONSTRAINT [FK_cs_ThreadRating_cs_Threads]
GO
/****** Object:  ForeignKey [FK_cs_ThreadRating_cs_UserProfile]    Script Date: 04/16/2008 13:07:58 ******/
ALTER TABLE [dbo].[cs_ThreadRating] DROP CONSTRAINT [FK_cs_ThreadRating_cs_UserProfile]
GO
/****** Object:  ForeignKey [FK_cs_ThreadsRead_cs_Threads]    Script Date: 04/16/2008 13:08:16 ******/
ALTER TABLE [dbo].[cs_ThreadsRead] DROP CONSTRAINT [FK_cs_ThreadsRead_cs_Threads]
GO
/****** Object:  ForeignKey [FK_cs_TrackedThreads_cs_Threads]    Script Date: 04/16/2008 13:08:23 ******/
ALTER TABLE [dbo].[cs_TrackedThreads] DROP CONSTRAINT [FK_cs_TrackedThreads_cs_Threads]
GO
/****** Object:  ForeignKey [FK_cs_UserAvatar_cs_UserProfile]    Script Date: 04/16/2008 13:08:32 ******/
ALTER TABLE [dbo].[cs_UserAvatar] DROP CONSTRAINT [FK_cs_UserAvatar_cs_UserProfile]
GO
/****** Object:  ForeignKey [FK_cs_Users]    Script Date: 04/16/2008 13:08:56 ******/
ALTER TABLE [dbo].[cs_UserProfile] DROP CONSTRAINT [FK_cs_Users]
GO
/****** Object:  ForeignKey [FK__cs_UserRe__FeedP__4A4E069C]    Script Date: 04/16/2008 13:08:58 ******/
ALTER TABLE [dbo].[cs_UserReadPost] DROP CONSTRAINT [FK__cs_UserRe__FeedP__4A4E069C]
GO
/****** Object:  ForeignKey [FK__cs_UserRe__UserI__4959E263]    Script Date: 04/16/2008 13:08:59 ******/
ALTER TABLE [dbo].[cs_UserReadPost] DROP CONSTRAINT [FK__cs_UserRe__UserI__4959E263]
GO

Thanks,
Bill

• Post Points: 20 |

rated by 0 users

Reply

|

Contact

By: Jose Lema

Posted: Thu, Apr 17 2008 12:11 PM In reply to

Hi Bill,

I have a feeling there's something fishy with your system since the cs_Feed and cs_Folder should be renamed (deprecated suffix), but we'll review and get back to you soon.

Thanks for posting this...

• Post Points: 20 |

rated by 0 users

Reply

|

Contact

By: Bill Bosacker

Posted: Sat, Apr 19 2008 12:21 PM In reply to

 Hey Jose,

Thanks for the update.  Let me know what you find out.  I've always used the SDK packages to update my systems and the database schema.  Maybe there was something out of sync?  Due to over obligations I won't be upgrading all systems until around the middle of May, so I have about a month.  I moved to TFS back in December and man am I happy I ever did.  Upgrading to CS 2008 is going to be the first big test using multiple branches and down merging.

I have the SDK as you guys release it at the top, a single branch where I put my common across the board modifications, and then I'll be creating multiple branch trees from there for each of the sites that I work on.  When you guys update the SDK, all I have to do is update the top level and then do down merges.  Its pretty sweet and means that I can get rid of WInDiff. 

Take it easy,
Bill

• Post Points: 5 |