| Author |
 Topic  |
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
 Posted - 19 December 2008 : 16:47:23
|
I'm in the process of migrating my db from Access to SQL2000.
I have run setup, and all the DBS files I could find in my archives, but several DBS files were no longer there. I know, it's a bit daft not to store them, but when I was installing those mods in the beginning of my Snitz adventure at the end of 2002 I didn't realise how important those files where...
Is there a simple tutorial/checklist I can use, which enables me to reverse engineer the DBS files based on what I see in my current Access db?< |
portfolio - linkshrinker - oxle - twitter |
Edited by - MarcelG on 22 December 2008 14:51:01 |
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 19 December 2008 : 17:10:29
|
Marcel, are you able to list the MODs you have? Maybe folks in the community have the dbs_ files you need.  < |
 |
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
Posted - 20 December 2008 : 11:18:55
|
Indeed! That's a good idea. 
They're almost all listed here ; http://oxle.com/topic/903.html
Some additional modifications are made by myself which also include DB updates (the Members feeds, the sidebar, the sidebar userpreferences, ....)
For those I will simply have to make the DBS changes myself....
< |
portfolio - linkshrinker - oxle - twitter |
Edited by - MarcelG on 20 December 2008 11:20:09 |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 20 December 2008 : 12:43:58
|
E-mail sent ...
? = no
i = yes
? * Alternative paging by sr_erick
? * File Attachments/Uploads
? * Header redesign
? * Limit Quick Paging by OneWayMule
? * Modified Forum Code (Quote etc)
? * Sidebarmod
? * Site Statistics
? * Sponsoring Members Mod
? * The [You] feature (Yes, especially for you!)
i * Active Users
i * Additional Forum Code (Iframe etc)
i * AntiSpam Registration
i * Avatar uploads
i * Avatars pfiew...
i * Basic Statistics
i * CTRL-B/CTRL-U/CTRL-I in post.asp for Bold, Underline and Italic
i * Custom Policy
i * Events Calendar
i * Flag Mod
i * Forum Themes
i * Hover color mod
i * Image Resize Mod
i * Message Icons
i * Polls
i * Private Messages
i * Smile Manager (Additional Smilies)
i * Sticky Topic Mod Didn't know that that was incorporated in the default Snitz!< |
|
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 22 December 2008 : 04:58:53
|
No DB changes needed for the [you] mod, just a couple of lines to add to inc_func_common.asp - Linkage.
< |
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
Posted - 22 December 2008 : 07:24:10
|
I managed to find all DBS files that I need, and created them for the mods I made myself.
I'm currently experimenting with the migration, but I don't think I'll succeed....
- I've got a SQL 2000 database at Kiwihosting, and it allows me to connect using a DSN, or via MS SQL Server Studio Express
- SQL Studio Express does not have a 'import' option....
- I don't have access to the filesystem of the SQL server...
- I'm currently using MS Access 2007, to move the data from the local Access 2000 file to the SQL database, over a DSN.
I expect a miserable failure, but we'll see how it goes.< |
portfolio - linkshrinker - oxle - twitter |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 22 December 2008 : 08:00:37
|
| Look into using Linked Servers in the help section of MS SQL Server Studio Express.< |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
Posted - 22 December 2008 : 09:04:38
|
| I've just installed the SQL 2000 Enterprise Manager, and yay!!! I've got the Import button! < |
portfolio - linkshrinker - oxle - twitter |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 22 December 2008 : 09:17:43
|
| I'm downloading SQL 2000 Enterprise Manager ... is it ok to install it on the same computer where MS SQL Server 2005 Studio Express is installed?< |
|
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
Posted - 22 December 2008 : 10:37:27
|
Well, it sure seems to be the case ; I've got both running on the same Vista box.
I'm running into some issues btw ; the FORUM_MODS table isn't copied over correctly....
quote:
Microsoft OLE DB Provider for SQL Server error '80040e14'
The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
/upload_avatar_engine.asp, line 112
mmm..
-edit - found it, turns out I had FORUM_MODS.M_NAME set to TEXT instead of nvarchar...
Fixed. < |
portfolio - linkshrinker - oxle - twitter |
Edited by - MarcelG on 22 December 2008 10:44:03 |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 22 December 2008 : 12:11:06
|
quote:
Originally posted by Etymon
I'm downloading SQL 2000 Enterprise Manager ... is it ok to install it on the same computer where MS SQL Server 2005 Studio Express is installed?
yep should be fine, I have them both running. just remember 200 EM will NOT connect to a 2005 database < |
|
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
Posted - 22 December 2008 : 14:50:03
|
Okay, it is getting a bit offtopic so I am going to rename this topic to make it ontopic... )
But, anyhow ; I think I have done a succesful (test)migration from MS Access to SQL 2000, but I'm not entirely sure.
I followed the steps in Carlos Miranda Levys topic as much as I could, including all the DBS files I could find.
I was unable to use Windows Authentication, as I am on shared hosting without support for windows accounts but that didn't seem to be a problem at all....
I completed the import, ran setup (it asked me to upgrade the database, so I did), I updated the forum counts, and it all looked ok.
I've tested all the mods I've installed, I've tested registration, topic deletion, reply deletion, splitting topics, archiving a forum, IP-gating, etc, and I encountered only 2 database-structure related errors (one missing column in the avatar table, one incorrect column-type (see above).
Additionally I had to remove one MS Access random row-workaround (and replaced it by ORDER BY NEWID() as that was what the workaround was for)
Is there a simple checklist I could follow now to make sure everything is ok ? I don't want to run into problems later on...especially seeing this remark in Carlos Miranda Levys post:quote:
One thing to worry here is that in both of the migrations listed above, the forum appeared to work fine, although I had not followed proper procedure. [...]If it would not have been thanks to the warnings and advice of others like Rui, I would have carried on with my "successfully" migrated faulty forums.
Any help is welcome!< |
portfolio - linkshrinker - oxle - twitter |
Edited by - MarcelG on 22 December 2008 14:58:34 |
|
|
|
SiSL
Average Member
Turkey
671 Posts |
|
|
AnonJr
Moderator
United States
5768 Posts |
|
|
Topic |
|
Topic Locked
