Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...PK for Portal Localisations and Tab SettingsPK for Portal Localisations and Tab Settings
Previous
 
Next
New Post
4/10/2010 12:10 PM
 
Mark Breen


www.margin.ie
Joined: 11/19/2008
Posts: 142

 Hello DNN Friends,

 

I use the wonderful RedGate SQL Data Compare to assist me in transferring changes that I make to the local dev environment into the live environment.

This tool compares the data in the tables and can perform update/insert/deletes as appropriate when the two systems have different data.

It seems that in 5.3.1, there are two tables Tab Settings and Portal Localisation that do not have PK's set.  RedGate likes to know the PK so that is the reason why I am asking, can anyone advise me for sure.  My worry is that it should be a compound key, or my other worry is that there should be no key at all!

 

Thanks in advance, 

 

Mark

 

Mark Breen Ireland 1987 BMW R80 g/s
 
New Post
10/16/2012 9:47 AM
 
Gus Beare

www.carawaydesign.com
Joined: 1/16/2006
Posts: 178

Hi

 don't suppose you every got an answer to this one?

 I use Redgate and am facing the same issue.

But it's a bigger issue that DNN uses IDENTITY cols everywhere. It's impossible to migrate a development copy to a changing production copy as is..

Gus

"if the only tool you have is a hammer you tend to see every problem as a nail" http://www.carawaydesign.com
 
New Post
10/17/2012 6:36 AM
 
Sebastian Leupold


Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

www.dnnwerk.de
Joined: 3/8/2004
Posts: 46212

there have been a number of datbase schema improvements in DNN 5.5.x, which added missing PKs for PortalLocalization (EntryId), while TabSettings has a unique key "IX_TabSettings_TabID_SettingName", which might be used as PK as well.

Regarding Identity colums, this is done by intention, however you may turn IDENTITY INSERT off, when replicating content, as long as there are no modifications on data and you are excluding log files from your replication.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
 Page 1 of 1
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...PK for Portal Localisations and Tab SettingsPK for Portal Localisations and Tab Settings


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out