| Author |
 Topic  |
|
|
TheGarbageBoy
Starting Member
2 Posts |
 Posted - 02 November 2004 : 17:23:07
|
Hi there,
We have a Snitz Forums 2000 Version 3.4.03 setup that has some tables on our SQL server. We are in the process of moving a few things and as a result would like to remove our current setup of Snitz Forums. My concern is I notice the Forum has some data on our SQL server and I don't see any option within the Snitz Forum administration to "uninstall Forum".
I just wondered if anyone could tell me a clean way to remove a Snitz Forum and its data on a SQL server, as opposed to manually deleting content and content folders?
Thanks in advance,
TGB. |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
TheGarbageBoy
Starting Member
2 Posts |
Posted - 02 November 2004 : 18:17:12
|
Thanks for your quick reply.
That's ok, I suspected as much.
Cheers. |
 |
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 03 November 2004 : 09:42:07
|
quote:
Originally posted by Podge
drop database <insert database name>
If there was nothing else in the databse that you'd want to keep, which didn't look like the case to me... |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
CPO
Starting Member
5 Posts |
Posted - 04 November 2004 : 22:03:45
|
You may be able to use dynamic tsql script to do this, something like this maybe:
select 'DROP TABLE '+ so.name + '
GO' From sysobjects so
where so.name like 'forum_%'
If you run this in the database of your forum, it will give you a script in the results and you copy paste that into the query windo and run it to drop all tables that have a prefix of 'forum_' (which is what i prefixed my tables with, you might have done it differently, just replace the forum_ with whatever your prefix is). I hope this helps and that it works. I'm not responsible if it doesn't since i haven't tried it :)
Here's an sample of my results...
DROP TABLE FORUM_A_REPLY
GO
DROP TABLE FORUM_A_TOPICS
GO
DROP TABLE FORUM_ALLOWED_MEMBERS
GO
DROP TABLE FORUM_BADWORDS
GO
DROP TABLE FORUM_CATEGORY
GO
DROP TABLE FORUM_CONFIG_NEW
GO
By the way, since i didn't test this, i'm not sure about any of the referential integrity or anything (foreign keys and such). Which if there is any, this script won't account for that... It is possible to create a script to do that, but it would probably be easier to just drop them manually...
Hope this helps...
-CPO |
|
|
| |
Topic |
|
Topic Locked
