The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
Guys, perhaps this has been asked (and answered) before, but I'm looking for a quick script to move all topics (including their replies) from one forum to another forum (within one site).
In my case it's from forum ID 50 to forum ID 20.
It concerns 328 topics with 2218 replies. Does anyone have a nice script laying around for that?
It concerns 328 topics with 2218 replies. Does anyone have a nice script laying around for that?
نوشته شده در
What database are you using?
I can write you one that will work with MySQL and SQL Server, except for the update counts part, but you can run that manually afterwards...
I can write you one that will work with MySQL and SQL Server, except for the update counts part, but you can run that manually afterwards...
نوشته شده در
I'm using SQL (2000).
نوشته شده در
Check out my signature
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=64453
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=64453
نوشته شده در
I knew it was floating around somewhere! 
Thanks!
edit Move completed! Now updating the forum counts.
Thanks!
edit Move completed! Now updating the forum counts.
نوشته شده در
Originally posted by MarcelG Now updating the forum counts.
Heh, suprised you even posted in it :P
May patience of the prophets be with you on updating counts if you have huge number of posts. Without Rui, I would not have such opportunity to update my counts or archive my posts EVER.