Skip to content

Instantly share code, notes, and snippets.

@ChrisHammond
Created November 12, 2018 04:36
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ChrisHammond/3925206b7bc7177c8b27a01a53257aa1 to your computer and use it in GitHub Desktop.
Save ChrisHammond/3925206b7bc7177c8b27a01a53257aa1 to your computer and use it in GitHub Desktop.
DNN Core Forums to Active Forums migration instructions
Documenting the instructions for migrating from the DNN Core 5.0.3 module to Active Forums 5.0.
2018 Notes
These instructions were originally written by myself (Chris Hammond) in 2012 and posted in the Codeplex Wiki, with the deprecation of Codeplex they were lost and are being reincarnated in this GIST.
Active Forums is on V6, can you migrate to that? Possible, but I haven't tried.
Instructions for use
Always test on a copy of your production site before using in production, you've been warned
Install Active Forums 5.0
Place Active Forums module on a page
Get the Module ID for the Active Forum module by navigating to the Module Settings (easiest to find when you have popups disabled in DNN 6, look at the URL of the Settings page. This ID will be your TargetModuleId
Get the Module ID for the DNN Forum module on a page in the same manner as above. This ID will be your SourceModuleID
Figure out your Portal ID by looking at the URL of your Host/Site Management page
Get the latest copy of the Migration script grab v1.3 from this work item
Find the two instances of CHANGEME in the script and put in your Target and Source module ids.
Check the PortalId in the script, it is defaulted to 0, this may be correct for most of you
If you are running this script in a SQL Query Window in SQL Server Management Studio (RECOMMENDED) search and replace the tokens {databaseOwner} and {objectQualifier} in the migration script. The values you will replace these tokens with will most likely be "dbo." and "", but you can verify by checking your web.config file and looking for objectQualifier and databaseOwner in there.
You can execute the Script in the Host/SQL page and you don't have to search/replace for the tokens, DNN will do it for you, but because this script may take a while to run you probably don't want to run it via HOST/SQL
Wait for the script to complete, this may take 15 to 20 minutes if you have a large site (testing a site with 53k topics and 434k replies it takes over 20 minutes to run)
You should go through all of your Forums and Forum Groups and verify permissions and settings, you do this via the Control Panel in the Active Forum module. The migration script makes a lot of assumptions and has some default settings, so to be safe please verify every forum/setting.
ADDITIONAL INSTRUCTIONS COMING SOON
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment