| Author |
 Topic  |
|
|
krellee
Starting Member
9 Posts |
 Posted - 23 July 2003 : 11:41:58
|
Hi
We are in the middle of setting up a new forum on a differant server to our old one is there anyway i can transfer the user details to the new database from the old?  |
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 23 July 2003 : 12:03:46
|
| If the old one is Snitz, you have to run setup.asp after uploading all the new files, that will update the database. |
 |
|
|
krellee
Starting Member
9 Posts |
Posted - 23 July 2003 : 12:06:43
|
I've set up the new database however i need to transfer the users from the old database(members table) to the new one(members table)
is this done from the setup.asp page as well? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
work mule
Senior Member
USA
1358 Posts |
Posted - 23 July 2003 : 13:34:26
|
What are you using? Access, MySQL, MSSQL (SQL Server)?
If it's MSSQL and you are using Enterprise Manager, then you can use the import/export wizard. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 23 July 2003 : 14:17:41
|
quote:
Originally posted by work mule
If it's MSSQL and you are using Enterprise Manager, then you can use the import/export wizard.
Even with Access that would be possible, if EM was available, and there are no differences between the forum versions for each DB. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
krellee
Starting Member
9 Posts |
Posted - 24 July 2003 : 04:09:17
|
| Thanks for everyones replys I'am using MSSQL I was a bit worried that on the password field the old version uses the exact word but the new one has an encrptyed pw would this be a problem? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 24 July 2003 : 04:29:16
|
I would recommend that you upgrade your existing forum before you move. That will take care of the password problem. I certainly do not advice a direct import of data from 3.3.x. to a 3.4.x. structure, not only because of the password issue, but also because there are new fields for 3.4 that do not exist in the other version.
So, to me, the move is clear:
1. Upgrade the existing forum from 3.3. to 3.4.
2. Create a blank 3.4. forum in the new host
3. Use DTS to import the user table data from the upgrade 3.4. forum to the new 3.4. forum.
Here is a link to a recommended upgrade strategy from 3.3.05 to 3.4.03: http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=39276&SearchTerms=,upgrade,3.4.03 |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
krellee
Starting Member
9 Posts |
Posted - 24 July 2003 : 08:10:42
|
Thanks i'll give it a go |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
