| Author |
 Topic Search  Topic Options
|
wack 
Newbie
Joined: 10 May 2003
Status: Offline
Points: 20
|
 Posted: 08 October 2003 at 11:45am |
|
hi i'm using the 7.01 in sql version. When i want to change my dbTables or stored procedures with enterprise manager they all change of owner & become useless cos the forum needs dbo as owner for each table or procedure. Will it work if i just delete the tblActiveUsers (since it has no permanent data in it) and the stored procedure that i need to change and then just run ms_sql_server_setup.asp. That script doesn't overwrite existing tables or procedures i presume?
Will this work or will i ruin my database ?
|
 |
svpworld
Groupie
Joined: 06 March 2003
Location: usa
Status: Offline
Points: 49
|
Posted: 09 October 2003 at 6:20am |
Dear Borg,
I put off upgrading to ver 7 as I felt the extra's didn't warrant the effort, but now with your latest release I am drooling (and I know my members will be too!). My problem, I am running the MS SQL version 7 beta 3 (yep I know I deserve a smack!) and I have nearly 1600 members and 6145 posts... What's the best way for me to upgrade without losing anything? I noticed there is a script to upgrade from 6.34 to 7.01 SQL, could i use this for the beta 3 version, perhaps with some simple mods to get to the full 7.01, and then upgrade from 7.01 to the latest version?
Hope someone can offer some advice and not swear too strongly at me for being a beta user! 
Simon Williams
SVPWorld
Edited by svpworld
|
|
Lamur
Newbie
Joined: 13 September 2003
Status: Offline
Points: 23
|
Posted: 09 October 2003 at 10:28pm |
|
Sorry for the late reply. I just re-uploaded a few of the files and it worked out great for me. Thanks alot for the great product!
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Posted: 10 October 2003 at 2:46am |
 svpworld wrote:
Dear Borg,
I put off upgrading to ver 7 as I felt the extra's didn't warrant
the effort, but now with your latest release I am drooling (and I know
my members will be too!). My problem, I am running the MS SQL version 7
beta 3 (yep I know I deserve a smack!) and I have nearly 1600 members
and 6145 posts... What's the best way for me to upgrade without
losing anything? I noticed there is a script to upgrade
from 6.34 to 7.01 SQL, could i use this for the beta 3 version, perhaps
with some simple mods to get to the full 7.01, and then upgrade from
7.01 to the latest version?
Hope someone can offer some advice and not swear too strongly at me for being a beta user!
Simon Williams
SVPWorld
|
I think beta 3 was one of the later ones so hopefully you won't need to
do to much, but you will have to go through the version history file
and make any changes to the database by hand.
|
|
|
|
TimD
Newbie
Joined: 26 February 2003
Location: United States
Status: Offline
Points: 12
|
Posted: 10 October 2003 at 11:20am |
Greetings all. I will be upgrading from 7.01 to 7.5 Access version but am a little concerned with the messages regarding login problems after the upgrade is uploaded.
I know I will need to backup the database, is there anything else I should be aware of before I proceed?
Also, will my members still be able to upload pictures to the site? I didn't notice that feature here on this board?
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Posted: 10 October 2003 at 11:26am |
|
The login problem is a problem with the way people setup the board
preventing the browsere reading cookies and if people searched the
forum it has been posted on 1000's of times in the last year. If it
doesn't effect your present imstallation it won't after upgrading.
Upload is the same, it's just not avaialable on this board for security reasons.
|
|
|
|
TimD
Newbie
Joined: 26 February 2003
Location: United States
Status: Offline
Points: 12
|
Posted: 10 October 2003 at 11:40am |
-boRG-
Thank you, as always you have the answers. I am hoping that it will not be required for me to post again however I will do so just to say all is OK.
Thanks again,
Tim
|
|
Awes
Mod Builder Group
Joined: 25 September 2003
Location: United States
Status: Offline
Points: 11
|
Posted: 10 October 2003 at 11:47am |
I'll be upgrading this weekend... Great work -boRg-!
Best advice I can give you TimD is to make a backup and print your admin settings before you convert to reference during the new set-up. I changed my cookie name so this is just an example of how I will need to refer back to the old setings. Print your skin files out too if you have a custom one like I do;)
All this will help if you run into a problem after installation!
|
|
How 2 upgade from 7.01 to 7.5