Print Page | Close Window

Best way to move from MS 2000 to 2005

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6226
Printed Date: 09 May 2025 at 1:37pm


Topic: Best way to move from MS 2000 to 2005
Posted By: WebGuyz
Subject: Best way to move from MS 2000 to 2005
Date Posted: 03 September 2007 at 7:41am
I tried to upgrade to 2005 this early morning and started getting these errors on the new database;
 
09/03/07 05:50:04:859 -- (6568) Error occurred during TAddToQuarantineThread when accessing the quarantine database: Cannot insert the value NULL into column 'MsgID', table 'spamfilter.dbo.tblMsgs'; column does not allow nulls. INSERT fails ( 83 84 85 86 86a 86b 86c 87 88 89 90 91)
 
I stopped all the SFE's and then used the 2005 wizard to copy the db from MS 2000 where it works fine. I set the compatability mode to 2000 but not sure if its dynamic or not since I changed that option while it was running.
 
Put everything back for now. Is there a recommened best practice for upgrading SFE to MS SQL 2005?
 
Thanks!!


-------------
http://www.webguyz.net


Replies:
Posted By: LogSat
Date Posted: 04 September 2007 at 11:43pm
The compatibility mode should not be an issue, SpamFilter will work in 2005 compatibility mode.

Could you instead please verify and ensure that when you migrated the database, on the new database the column "msgid" in the table tblMsgs has still been configured to be an "Identity" column, meaning that SQL Server will assigning the values for that column?

If that column was not of the "Identity" type, something has gone wrong in your migration, and you'll want to re-check everything as other problems may have occurred.


-------------
Roberto Franceschetti

http://www.logsat.com" rel="nofollow - LogSat Software

http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP

Posted By: WebGuyz
Date Posted: 05 September 2007 at 1:25am
I used the 2005 Copy Wizard to create the database and move the data, but in retrospect I should have done a detach/attach. Will try that this weekend.
 
Thanks!


-------------
http://www.webguyz.net


Print Page | Close Window