|
|
Rank: Enthusiast
Joined: 10/30/2007
Posts: 17
|
Are there any plans to make this work with SQL Server 2000?
|
|
Rank: Fanatic
Joined: 7/25/2006
Posts: 433
Location: Silkeborg, Denmark
|
Allthough I haven't tried it yet, in theory it should work with SQL 2000. So if you are able to test it on one and give me the results here it would be greatly appreciated :-) If not, then the SQL commands it uses to clean up the DB can be found in the file /umbraco/Plugins/CleanSweep/CleanSweepWizard.sql after the package has been imported. You can try to execute and modify it yourself manually. /SoerenS
Brug for råd til hvordan du driver en god webshop? / Need advice on how to run an effective webshop?
|
|
Rank: Enthusiast
Joined: 10/30/2007
Posts: 17
|
I got it to work but I had to modify the SQL in the package.
SQL Server 2000 doesn't support the try catch block. :(
The first thing I tried was to remove the try catch blocks along with a couple of other tweaks in the sql. This caused the tables to be deleted but an error was thrown due to the foreign key constraints. The program caught the error from the SQL and stopped.
Instead of using a cursor I explicitly dropped each table in the proper order. I also had to customize the script for the user who owns the tables in my environment.
While this solution works for me, it is not workable for everyone unless they want to modify the package before they use it.
I am not sure how to handle the errors in SQL Server 2000. If that could be accomplished it would work with the cursors. Another possible solution could be to find the user name which owns each table and use dynamic sql to do the drop.
Marc
|
|
Rank: Aficionado
Joined: 7/23/2006
Posts: 172
|
Hi Søren
I used it to clean a site running on FAB-it.
It cleaned the database allright - but I had to delete the folders manually. Don't know if this is the intension.
Søren Linaa
Level 1 & 2 Certified Professional
|
|
Rank: Enthusiast
Joined: 10/30/2007
Posts: 17
|
Other than the SQL changes I had to make for SQL Server 2000 the package is working great on my v3.0.3 instance using MSDE. I have used it several times and it is very handy when developing packages.
|
|
Rank: Fanatic
Joined: 7/25/2006
Posts: 433
Location: Silkeborg, Denmark
|
Søren Linaa wrote:
Hi Søren
I used it to clean a site running on FAB-it.
It cleaned the database allright - but I had to delete the folders manually. Don't know if this is the intension.
Which folders are you talking about exactly? It doesn't delete folders like /xslt and such, only the content of those plus any subfolders. The reason for this is that some people have assigned rights directly to these folders instead of just the root folder, and if those folders are deleted you'd have to reassign the rights. Also, it doesn't delete itself, ie. /umbraco/plugins/cleansweep/ and I'm not sure if I'll implement that before releasing the package. /SoerenS
Brug for råd til hvordan du driver en god webshop? / Need advice on how to run an effective webshop?
|
|
Rank: Fanatic
Joined: 7/25/2006
Posts: 433
Location: Silkeborg, Denmark
|
Marc wrote:
Other than the SQL changes I had to make for SQL Server 2000 the package is working great on my v3.0.3 instance using MSDE. I have used it several times and it is very handy when developing packages.
Great job Marc! I'll make a note in the readme that it doesn't work on SQL 2000. Unfortunately I don't have access to a SQL 2000 server right now, so I can't modify and test the script myself. /SoerenS
Brug for råd til hvordan du driver en god webshop? / Need advice on how to run an effective webshop?
|
|
|
Guest |