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  |  

Maximum ASP
  Ads  
Engage Software - Training Partner for DotNetNuke
 


  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! (...  Is it "safe" to bulk-create pages through SQL inserts to dnn_Tabs?
Previous Previous
 
Next Next
New Post 12/16/2007 1:22 PM
User is offline patja
13 posts
10th Ranked


Is it "safe" to bulk-create pages through SQL inserts to dnn_Tabs? 

I am migrating a legacy static HTML site over to DNN and am looking for ways to reduce the migration effort.  The site has about 100 pages and I would like to be able to create the empty pages through some automated import process, and then I can delegate the task of copy/pasting the existing content over to the new pages.

Looking at the database, its structure seems pretty straightforward.  I am wondering if it is safe to just write a SQL script that does a bunch of inserts to the dnn_Tabs table, using the data I can see for the few pages I manually created as a template.

While I'm comfortable in SQL and ASP .NET, I am pretty much a newbie with DNN and am nervous there might be more to it.  I've worked enough with complex apps like SAP to know that reverse engineering just by looking at the db schema is dangerous.  Is there stuff done at the file system level or in other tables in DNN when you create a page manually that I will miss or corrupt if I just go creating new rows in dnn_Tabs?

Thanks, Pat

 
New Post 12/17/2007 7:58 AM
User is offline Will Strohl
1410 posts
www.WillStrohl.com
6th Ranked




Re: Is it "safe" to bulk-create pages through SQL inserts to dnn_Tabs? 

As long as you perform the proper amount of effort in investigating the path that the logic will follow, I do not think that there should be a problem.  If I were you, I would begin investigating with the TabController.vb file to see what might happen before and after the call to the insertion of a new tab.  After addressing that, then you should be safe with moving forward in duplicating the efforts at the DB level.


Will LinkedIn profile
DNN Training Videos | My Blog | DotNetNuke® Skins by SSD
Google Toolbar Button for DNN | Suggested DNN Upgrade Paths
ODUG Web Site
 
New Post 12/17/2007 12:17 PM
User is offline Sebastian Leupold
16079 posts
www.deutschnetnuke.de
1st Ranked












Re: Is it "safe" to bulk-create pages through SQL inserts to dnn_Tabs? 

you should definately add pages and module using BCL as there are additional tables that need to be filles as well, as tabpermissions, modulepermissions, modulesettings,...


Sebastian Leupold

DeutschNetNuke dnnWerk - The DotNetNuke Experts German DotNetNuke User-Group European Network of DotNetNuke Professionals

DotNetNuke Project UserDefinedTable
DotNetNuke Project Release Tracker
 
Previous Previous
 
Next Next
  Forum  General DotNetN...  Configure It! (...  Is it "safe" to bulk-create pages through SQL inserts to dnn_Tabs?
 


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.

 


Bring2mind
Document Centric DNN Module Solutions
www.bring2mind.net
WEBPC™ DotNetNuke® sites for Small Business
WEBPC™ are internet consultants and web hosters catering to the small business market.
www.webpc.biz
Perpetual Motion Interactive Systems Inc.
A solutions company specializing in Microsoft enterprise technologies.
www.perpetualmotion.ca

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