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...Administration ...Administration ...[HELP] change the database [HELP] change the database
Previous
 
Next
New Post
1/15/2011 9:47 AM
 
koukou


Joined: 1/15/2011
Posts: 4
Hello everyone,
I have a problem with the database, in fact when I was installing DNN and during the phase of the configuration of the DB it gives me an error (I don't remember the error), I search everywhere but I did not find a solution, so  used  the default database (Database.mdf located in the folder: App_Data), everything worked very well and I begin to build my DNN website , the problem is that when I wanted to change the database for adding  tables, I do not know how and if is it possible. my questions are:
   1-is it possible to add another database to my dnn website without losing my job
   2-or is there a possibility to change the DB: Database.mdf
   3-if you have any other suggestions to help me because I really need a database where I can put my own tables

thinks a lot
 
New Post
1/15/2011 6:10 PM
 
Sacha Trauwaen


Sacha Trauwaen's Avatar

www.satrabel.be
Joined: 8/31/2005
Posts: 380
Hi,

You can without problem add your tables to the dnn database.

There are,i think, some limitation with the use of a db file "Database.mdf".

For a production website, i sujest you to use a db created with ms sql management studio before de installation of dnn.

Forge projects : Open Url Rewriter - Open Content - Open Form

 
New Post
1/15/2011 6:46 PM
 
koukou


Joined: 1/15/2011
Posts: 4
hi ,
actually i have already installed the dnn (i have choose the auto option i didn't creat any DB>>>), and i have already begun to product my website ( the static content),now i have to use the DB so add some tables but i don't know if is it possible to modify "Database.mdf" or if is it possible to integrate a new DB without losing my work(=the static content )

i really need your help
thanks
 
New Post
1/15/2011 10:01 PM
 
William Severance


www.wesnetdesigns.com
Joined: 2/18/2005
Posts: 3253
The Database.mdf file located in the App_Data folder is not accessible in MS SQL Server Management Studio without first attaching to the file.

Please see the following older, but still valid blog entry concerning how to attach to the Database.mdf file and in particular note the issues that will require you to modify your web.config's connection strings (2) after attaching to the database file outside of DotNetNuke:

http://www.dotnetnuke.com/Community/B...

I recommend (except for quick test installs of DotNetNuke on localhost) always creating a blank database manually (usually with username/password credentials created for SQL Server Authentication rather than Windows Authentication)  then supplying its connection information to the install wizard when installing DotNetNuke.

Once you have attached to the Database.mdf file you will be able to add your own custom tables, stored procedures, etc. in the same manner as if you had initially created a database to be used by DotNetNuke.
Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
 Page 1 of 1
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...[HELP] change the database [HELP] change the database


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