Products

Solutions

Resources

Partners

Community

Blog

About

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 ...Is it "safe" to bulk-create pages through SQL inserts to dnn_Tabs?Is it "safe" to bulk-create pages through SQL inserts to dnn_Tabs?
Previous
 
Next
New Post
12/16/2007 4:22 PM
 

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 10:58 AM
 

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 Strohl

Upendo Ventures Upendo Ventures
DNN experts since 2003
Official provider of the Hotcakes Commerce Cloud and SLA support
 
New Post
12/17/2007 3:17 PM
 

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,...


Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Is it "safe" to bulk-create pages through SQL inserts to dnn_Tabs?Is it "safe" to bulk-create pages through SQL inserts to dnn_Tabs?


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