PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 6/13/2010 3:47 AM by  Chris Duncan
Upgrade the SQL Database form 2000 to 2005
 4 Replies
AddThis - Bookmarking and Sharing Button
Sort:
You are not authorized to post a reply.
Author Messages
Chris Duncan
New Member
New Member
Posts:3
Points:5


--
6/10/2010 6:34 AM

    Well finally, I am getting round to upgrading our HMP to the latest version..We are on 7.5.177, But have realised that my database is on Sql2000 and the newer versions need Sql2005/2008...

    So before I can do anything I need to upgrade the database...I have a Sql2005 server already that I can move to..


    Can anyone give me some advice on how??? Or do I need to send in a copy???

    Regards

    Chris

    Rod Weir
    HelpMaster development team
    Helpdesk Hall of Fame
    Helpdesk Hall of Fame
    Posts:555
    Points:1017


    --
    6/11/2010 1:39 AM

    Hi Chris,

    Good to hear you're upgrading.  v9.1 is a great improvement over v7.5.

    The basic upgrade process for you would be something like...

    1. Make a backup of your 7.5 database
    2. Restore the backup to your SQL Server 2005 instance (you might like to rename it also in this process)
    3. Install HelpMaster v9.1
    4. Run the database and reports Wizard to upgrade your database - point it at your SQL Server 2005
    5. Run the v9.1 Desktop edition and connect to your newly upgraded database, and that's it!

    More help info here...
    http://www.helpmasterpro....tm#Installation/html files/Installation Overview - Upgrade.htm

    and here

    http://www.helpmasterpro....hh_goto.htm#Database Wizard/html files/Upgrading an existing HelpMaster Pro database.htm



    If you have any trouble, please let us know.

    Best regards,
    Rod

    HelpMaster development team
    Check out the HelpMaster roadmap
    Chris Duncan
    New Member
    New Member
    Posts:3
    Points:5


    --
    6/11/2010 6:56 AM

    Thanks Rod,

    But when I try to upgrade the database using the wizard it tells me that it isn't a valid database.

    Are you sure that those instructions work when moving a SQL2000 database to a SQL2005??

    Chris

     

     

    Rod Weir
    HelpMaster development team
    Helpdesk Hall of Fame
    Helpdesk Hall of Fame
    Posts:555
    Points:1017


    --
    6/12/2010 6:28 PM
    It could be a permissions issue. When you restore your database to the new SQL Server, please ensure that the account you use to connect the HelpMaster Database and Reports Wizard has sufficient database (SQL Server) permissions to read, write and "own" the database. db_owner permission is essential for performing a database upgrade.

    If you know the SQL Server "SA" account (system administrator) you may like to connect using that as it has all the permission you require.

    If it still doesn't work, please let me know.

    Hope this helps,
    Rod
    HelpMaster development team
    Check out the HelpMaster roadmap
    Chris Duncan
    New Member
    New Member
    Posts:3
    Points:5


    --
    6/13/2010 3:47 AM
    You were correct it was a permissions issue!
    Many thanks!
    All I have to do now is sort out why it thinks my support has expired and get a new key as the current v9 one isn't working!!!

    Nearly there!

    Chris
    You are not authorized to post a reply.


    New version - HelpMaster v24 now available! by Rod Weir in Announcements with 0 replies A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpr...-f...

    New version - HelpMaster v23 now available! by Rod Weir in Announcements with 0 replies A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpro.com...

    March 2023 v22.7 maintenance release now available by Rod Weir in Announcements with 0 replies A maintenance release for v22.7 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

    July 2022 release now available - New version released! by Rod Weir in Announcements with 0 replies A new feature release of HelpMaster is now available!  v22.7.22 For a list of the major new features of v22, see the new documentation site ht...

    June 2022 v22.2 maintenance release now available by Rod Weir in Announcements with 0 replies A maintenance release for v22.2 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

    RE: Use PowerBI for HelpMaster dashboards by Rod Weir in Reports and reporting Hi SR, Thanks for the post. Yes, the PowerBI reports for HelpMaster have been well received. Download the latest version, from here. https://www...

    RE: Use PowerBI for HelpMaster dashboards by Scenic_Rim_IT in Reports and reporting Hi Rod - just wondering how PowerBI reports are going? Any chance you have a beta/pre-release version we can help test for you?...

    New version - HelpMaster v24 now available! by Rod Weir in Announcements A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpr...-f...

    New version - HelpMaster v23 now available! by Rod Weir in Announcements A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpro.com...

    March 2023 v22.7 maintenance release now available by Rod Weir in Announcements A maintenance release for v22.7 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

    July 2022 release now available - New version released! by Rod Weir in Announcements A new feature release of HelpMaster is now available!  v22.7.22 For a list of the major new features of v22, see the new documentation site ht...

    June 2022 v22.2 maintenance release now available by Rod Weir in Announcements A maintenance release for v22.2 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

    February 2022 release now available - New version released! by Rod Weir in Announcements A new major release of HelpMaster is now available! For a list of the major new features of v22, see the new documentation site https://docs.helpma...

    November 2021 release now available - New Major Version! by Rod Weir in Announcements A new major release of HelpMaster is now available! For a list of the major new features of v22, see the new documentation site https://docs.helpma...

    May 2021 release now available - New Major Version! by Rod Weir in Announcements A new major release of HelpMaster is now available! For a list of the major new features of v21, see the new documentation site https://docs.helpma...