Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

telerik -- supercharge your DNN websites
  Ads  
r2i.ntegrated
 


  Sponsors  

Meet Our Sponsors

Mad Development is a full service interactive agency focusing on the merge of design, technology, e-commerce, and affiliate marketing by providing total website solutions.
AspDotNetStoreFront - E-Commerce by Design - The Leading ASP.NET shopping cart platform for developers!
SteadyRain
DataSprings - Great Ideas. Always Flowing.
R2integrated - formerly bi4ce
Jango Studios - Skins, Modules and Hosting for DotNetNuke
 


DotNetNuke Forums
 
  Forum  General DotNetN...  Configure It! (...  Renaming Database?
Previous Previous
 
Next Next
New Post 10/1/2008 8:13 AM
Unresolved
User is offline ioiiooo
3 posts
10th Ranked


Renaming Database? 

We have run into a problem with a module where our database name ("dnn_system") is too long when combined with a certain module foreign key (the module creates tables with long names like "dnn_system_VendorNameHere_Product_ModuleConfigurationHere" that apparently are just beyond the SQL 128 character limit). 

Is there a way to rename our database and related tables in DNN to something shorter that won't break DotNetNuke?
 
New Post 10/1/2008 2:27 PM
User is offline Jeff Cochran
1629 posts
5th Ranked


Re: Renaming Database? 

I'd make the vendor fix the module.  :)

I don't know an easy way to do this with DNN.  Depending on your SQL skills it's not impossible, but make sure you have backups.  Working backups.  You'll need to change DNN's web.config at least as well.

Jeff
 
New Post 10/1/2008 2:46 PM
User is offline JK
357 posts
www.bestwebsites.co.nz
8th Ranked


Re: Renaming Database? 

Make a backup first :) Stop the website so the DB tables are not in use. Manually rename all tables from dnn_system_tablename to just dnn_tablename or even better, just to tablename.  Then change object qualifier in your web.config to "dnn_" (or to "" if you changed names to just tablename).  Then hope!  Restore from backup if it doesnt work.  I've never tried this so can say for sure if it will work..

JK

You know your website is cool, so why not let your users help you by spreading the word on social networking sites - get the DotNetNuke Social Bookmarks Module with 55 different ways to add social bookmarks to your site ... or download the FREE demo right now
 
 Page 1 of 1
Previous Previous
 
Next Next
  Forum  General DotNetN...  Configure It! (...  Renaming Database?
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.
 


DM Analytics, LLC
DM Analytics, LLC provides software solutions that facilitate rapid development of independent or dependent datamarts and their associated web-based reporting.
www.dmanalytics.com 		Integral Hosting | DNN only $14.95/month
Experienced .NET hosting on Windows 2003, ASP.NET 1.1 & 2.0, MSSQL with real technical support.
www.integralhosting.com 		Aricie
Aricie is one of the French pioneers and experts in DotNetNuke technology.
www.aricie.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP