- For each
.sql
file, use SSMS → Tasks → Export Data... → select your database → filename should be the same as the.sql
but with.csv
, Destination:Flat File Destination
,Unicode
→Write a query to specify the data to transfer
→ paste in the contents of the.sql
file - Open the
.csv
files in your favorite text editor and re-save them as UTF-8 with no BOM. - Copy the
.csv
files to/var/www/discourse/script/import_scripts/
on your Docker instance. - Edit the
specific to TDWTF
section if you are converting a different Community Server forum. The data is 'community server section id' => discourse category id for any categories you have already made on Discourse. - Copy
communityserver.rb
to/var/www/discourse/script/import_scripts/
- Run the following command in your Docker instance:
(cd /var/www/discourse/script/import_scripts/ && RAILS_ENV=production sudo -E -u discourse bundle exec ruby communityserver.rb)
- You have now migrated your Community Server forum to Discourse.
BenLubar/tdwtf-convert
This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
About
I may as well make this Open Sores Software to annoy morbs. <3 morbs
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published